Search results for query: *

A user is trying to generate a report but gets a Dr Watson at approx 60,000 rows. I've exported the SQL syntax and run it successfully against the database, so I'm assuming it's a Crystal issue. Any thoughts? Dr Watson excerpt follows: Application exception occurred: App: (pid=585)...

I have changed a the data source of an existing report that contains a subrpt - it was using 16 tables, now it uses a VIEW. Now when I run the report (via a PowerBuilder application) it returns no data (but neither does it report any errors). My guess (and it is a guess because I'm new to the...

Is there a maximum number of tables that I can join for use in a report? I have an existing report joining 15 tables and need to add another 3. I can successfully add the tables via Visual Linking but when I then preview the SQL syntax, the new tables don't show up. The fields do, however show...

I'm amending an existing report in Crystal 6.0. The report uses data from a view. I've added a couple of columns to the view. When I try to create a formula using the new columns, they're not available in the list of fields. If, however, I create a new report and select the view, I can 'see'...

I need to truncate a summary field in a crosstab - the field in question is a formula that calculates a number to 2 decimal places. I need to display the summarized field (sum of the formula) on the report as truncated but I do not want to truncate until after the summarization is done because...