Recent content by mycrystalbaby

Hi, It will be great, if somebody could help me with this problem? I am using Crystal X with SQl 8.0. I am trying to create a report with dynamic labels; I could do that with if else statement, but don’t want to use it. As everyday, these values will go on increasing and I can’t modify this...

Thank you so much for your reply. I made a mistake by not sending the exact error. "Cannt inert the NULL in to column VOB_ID, table VISTA.dv_dvrack_t;column does not allow nulls." If I allow null, then also I get the same message. Thanks AA

Hi, It will be great, if somebody could help me with this problem. I am trying to create a new report from a stored procedure. When I select the stored procedure to create this report, it asks for the parameter and gives the message that can’t enter the null in unique ids. I tried different SPs...

Thanks again. I did not understand what does it mean "Faster connection"? Thanks. AA

The main report takes about 200 seconds to run. I was wrong; it has about 350,700 records to read. What is does is, gives the count of those records in the first drill down. View is very simple, it has one join between two tables.. So it is very straight forward data coming from sql. Database...

Thank you so much for responding back. I was under thing impression that On demand sub reports dont access the data untill you dont click on the link. Let me see, if I can have a stored procedure instead of using the table directly in the view. Thanks again. Anita

Hi, It would be great if somebody could help me with this problem. I am using Crystal 10 with sql 8.0. I have a report with three drills down levels; second drill down has two on demand sub reports. This report is extremely slow, as we have 50k records in the database. We have tried our best...

Thank you so much for taking time to reply again. Well, I achieved this by using the field from the view in the report(instead of parameter field). this is my final formula. DateVar StartDate := Date(Year(CurrentDate),Month(CurrentDate),1); DateVar EndDate :=...

Hellow Again! Thank you so much for this, but I have a question about this parameter, when I create this parameter, how many values, I need to insert there? Value Description 0 Current Month 1 Current Month + 1 2 Current Month + 2 //etc. as I see etc...

Hi, I would really appriciate, if somebody could help me with this. I am using a CR-X with SQL8.0. I am trying to create a report which has a sub report as well. I would like to have a parameter for this report as a text box, so user can write a number there. It will be to enter a Month. i.e...

I really apologize for this. Raw data 10, 12, 14 3 B,C,A 10, 12, 14 3 B,C,A 10, 12, 14 3 B,C,A 8,9 2 A,B 8,9 2 A,B 11 1 A This was the raw data and I would like to...

Hi, I did not get, what you suggested. Let me send you some data, actually I missed it.. If it is 1 pole breaker, it will be a single row in the database, if it is 2 pole breaker then two rows in the database, if 3 pole breaker then 3 rows in the database. BREAKER_NAME NUM_POLE PHASE 10...

Yes this is if then formula. Well, Actual fied from the db is {NUM_POLES} and {PHASE}. {PHASE} is string in the database and have only three values A,B and C. {NUM_POLES} is number in the database and has three values always, 1,2 and 3. So we have to write formula if {NUM_POLES}=1 then...

Hi, In my report one field is number and other is string I need to write a formula like this..please tell me how to do that? // this is a number NumberVar Pole :={NUM_POLES}; //this is a string StringVar Phase :={PHASE}; If Pole="1" then Phase else if Pole="2" and Phase="C; then "B","C" PS...

I have few reports, where we would like to use the same report version for German clients. When I change my system settings to German and test those reports, few things don’t work properly. e.g, numbers in US are denoted as 10.000,00 and in German it is denoted as 10,000.00. At few places it...