Recent content by jowilliams

The DWSyntax utility (shipped with PB -- to ver 6.5 at least)is really useful for modify/describe. Also, you can make a datawindow resembling the one you'll be creating dynamically and then export the object to take a look at the 'create; syntax for it.

I ran it successfully in increasingly large 'chunks' and yes, it seemed to hit a threshold & die. Am I right in thinking that Crystal may require a good up to 100MB locally to generate the report -- I just cleared a bunch of stuff from my hard drive (I only had a few megs free and perhaps the...

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

.Database>Verify Database, right? That worked a treat. Presumably I would need to do that for any DDL statements that were executed on my tables/views... many thanks

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