Search:

Hi,

I'm working on Crystal Reports 9. Recently I was enquired about Crystal Enterprise.

I'm just wondering what is the difference between Crystal Reports and Crystal Enterprise.

Can I...

Hi Everybody,

I'd designed a report using 3 tables. Namely A,B,C

Linking these tables using inner joins.

For Tables B,C, the parameter fields restricts the result (Using selecton formula)
...

Hi everybody,

Here is my problem. To generate a particular report I'm creating a table and inserting the records by ASP code. The no. of columns in the table varies with the input. i.e I'm...

Yes, Crystal Reports (RAS) should be installed in the server. You can publish the report in the web in two ways. Search Crystal Decisions site, you can get sample code for both.

Finally I set some default value which will not affect the result.

Anyway I'll try ur idea.

No, Actually I have checked the "Suppress Printing if No Records" in Report Options dialog. (accidentally, and I simply forgot)

After checking all the possibilities, I noticed that one. So I...

I resolved the problem by checking a run time value which is set when the lastrecord is read.

i.e suppressing the page header when the cournter is set (i.e when the last record in the main...

Got it! Any way thanks!

Hi Everybody,

I have a strange problem. I'm using CR 9. My report works fine. The problem is it if there is no records found, then it is not displaying anything including Report Header, Report...

I'm not sure whether this folg is a right solution. but it'll work.

Try to create a formula and check the numeric value. Form a group using code
Like

If {table.field} in [800 to 830] then
1...

Hi everybody,

I'm using CR 9. Is there any way to set a parameter as optional?

Thanks

Have u linked these commands by currency?

Hello everybody,

Here is my problem. I'm generating a sub report in the report footer of the main report.

My problem is the page header for main report is displaying in the sub report.
...

I think hoyinso is not mentioning the field value, but the count.

Ususally if Crystal won't display anything (particulary groups / records) if the database returns nothing.

go to "Section Expert".

Select the section where you want to inser page break.

You can make use of "New Page After", "New Page Before" options and you can write for formula to apply this only...

Sorry for that.

I should have checked before posting.

Thanks,

For the first question, Hope you have written the formula in "Display String" (Format)section.

Try to check CurrentFieldValue instead of {table.field}.

I checked with zero, it...

I think Report object will do the work (in Crystal 9)

Dim Appl As New CRAXDRT.Application
Dim Report As New CRAXDRT.Report

Set Report = Appl.OpenReport("Path")

Report.PrinterName =...

Is that field is blank or null? If it is blank, just check with blank space instead of checking null.

What's your problem?

And didn't declare the variables?

Try to put the field in a separate section (If possible), and Suppress section if that value is blank.

Hi,

Right Click the summary field, select "Format Field", go to "Common" Tab.

You can find X-2 for "Display" String option. Click that button and write the following formula

If...

Hello,

One of my report designed using CR 9 takes around 6 to 7 mins while running from Crystal. The same report takes 14 to 15 mins while running from the web server. Why the difference is so...

Hi everybody,

Is it possible to find a Nth Largest value of an array of numbers using formula (built in)?

Thanks

Yes, you can use summary fields in other formula fields.