Search results for query: *

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...

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...

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...

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...

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...

I am using Crystal X and trying to get the help files through hyperlink option. How can I build the dynamic IP address of the server, so whenever user clicks on that links, it picks up that file from that server. Right now, it is sticking to my local machine IP and always redirects the link to...

I am using CR X with SQL 8, I would like to know, If I can insert a help file on the top of the page (file.chm). When the user will run the report, he will be provided with the link to that help file.

I am using CR X with SQL 8.0. I would like to write a formula to make sure, if any of the field is NULL then return empty. If A=10 and B=NULL A-B should return NULL. How can I achieve this in Crystal X. Thanks in advance.

Hi, Could you please help me with this problem or advice me a way out? I am using Crystal X with SQL 8.0. I have a chart, where I would like to show dynamic legends on change of month. Is there a possibility? We have data available in sql. Thanks A

Hi, I am using CR-X wit SQL 8.0. I have a report, where two fields are coming from the data base Building and Data Center, field’s length for each field is 50. I would like to concatenate these and create a group on top of that. Building +"->"+Data Center. It works, but the problem is if the...

I have a drill down report and I would like to format a field in column wise. e.g, I have 3 values coming from same field which goes one after another in details, but I would like to format that in a way, so user reads it as A B C 1 2 3 Instead of single column A 1 2 3

I have a field in database, called "DateTime".when I created user promptfileters for that, it prompts to enter Data and Time. Is there a way, if could convert it to Date only, so user does not have to enter the time each time.

One of the reports having 12 sub reports within it and each has a chart. When ever sub report does not have the data, it shows the blank space. I would like to show the blank chart (body for the chart), if it does not have any data. I checked the option Suppress, it was un- checked for each...

I am displaying three formulas in one concatenation formula in Crystal report. I would like to keep the text size for first formula as 12 and next two formulas as 10, how do I do it? That’s how my formulas is in Crystal totext({@formula1},0,"")+" "+ {@ formula2}+""+ totext({@formula3} ,0,"")

I have a formula where I am calculate the %age Used/total*100 I am using this formula on the group footer 2b; I would like to show the grand total of this on Group Footer1 e.g GF2b GF2b 1.2% GF2b 2.4% Grand total GF1 ?? I am trying to create a running total...

In Crystal Reports, I have a line chart with three values. I am already modifying these values in display. Is there a way, if I could have dynamic values instead on static? Thanks

I would like to display ft2 as ft^2, how can I do it in Crystal? Thanks

I would like to write a formula for Roundup for any decimal point. e.g, if my result is 1.1, then also it should roundup to 2. If it is 1.5 then also 2 I tried adding .5 in the result set, but it does not give the accurate results. It is very urgent, if somebody could help me, will be highly...