Recent content by prakashroch

i have a stored procedure which creates a temporary table the table has 5 columns ....since all the 5 columns have a different where clause i have 5 different update statements which update the columns. .the problem is the stored procedure is running extremely slow …..the table holds approx 2000...

Thanks Jim that was cool ....since i am new to CR i had no idea abt whileprintingrecords and evaluateafter functions now i know how they work..... so basically whileprintingrecords exceutes the code below it while printing the record and evaluateafter will check for the change in the value of...

i want to highlight the first item in the subgroup and then highlight the remaining items alternately. The number of records(items) in the subgroup keep changing. Here is how my group header 1 , group header 2 and detail section look like H=Highlight Brand (group header 1) Subbrand...

I have this statment in my formula Sales: " + {?Selection1} + "Area: " + {?Selection2} I want to bold the Text "Sales" and "Area" when it gets displayed in the Report couldnt find any bold function Any suggestions?? Thanks

Thanks Terry i worked....since i am new to stored procedures i thought i need to read the number of rows and run the update in loop .....also my try4 was a subquery ...i realized that i cant do the inner join if try4 is subquery so decided to make a memory table out of the subquery.. thanks anyways

i have two tables one is try3 and other try4 Field try3 ->Itemname,Sales,Itemid in try3 Itemname and itemid colums are are alredy filled and sales for each record is "Zero" ,there are 100 such records Field try4 ->Sales,Itemid Each distinct itemid has sales value i want to assign...

i have two tables one is try3 and other try4 Field try3 ->Itemname,Sales,Itemid in try3 Itemname and itemid colums are are alredy filled and sales for each record is "Zero" ,there are 100 such records Field try4 ->Sales,Itemid Each distinct itemid has sales value i want to assign...

thanks for the help ...it works

how do i get alternate backgorund color rows in CR .... say first row gets white and second row gets gray

I am collecting some real time process data from a manufacturing application into Sybase. I have a table in FoxPro whose source the Sybase table. The Sybase table is supplying values ever 2sec to FoxPro. In order to see the latest values in FoxPro I have to close the FoxPro application and...

I was wondering how RETURN ("myled11") works coz the subclass names are myled1 ,myled2 so on ?? Thanks for your help

It works …… In the class i added the number of LED's i wanted in each of "myled#" so in case of "myled4" there are 4 leds of same color in it. Mike if I am not bothering can you explain me how the class works. Thanks a lot Prakash

Hi Mike What i was looking for is if the EMP_ID ="2" then there would be 2 led's if the EMP_ID ="4" then there would be 4 led's Doesnt matter if the color of all the leds is same. Hope this is clear if not please let me know Thanks

Hi Mike, Can You send me the sample on pa_gandhi@hotmail.com Thanks

Hello, I have grid, which displays many records during run time. I have a column in the grid that I want to display graphically say in form of LED's or bulbs. LED’s are circular shaped and are placed outside, adjacent to the row of the grid. There are 5 leads for each row. I can change the color...