Recent content by jontvr

Thanks, but the core problem is the failure of the whole report if one of the sun-reports fails.

I'm running this on CE10, but the same issue applies to Crystal Reports designer when the report is run directly. My report contains 12 identical sub-reports, but each has a different connection string pointing to geographically dispursed databases. The main report itself contains no data other...

I think you've pretty much nailed my problem on the head. Re-architecting this database isn't an option for me at this time. I know there are plenty of tools that can produce ER diagrams based on explicit relationships. It's the implied relationship that I'm stuck on. Every tool I've looked at...

Thanks for your response. Unfortunately there are no explicit key constraints in this database. All referential integrity is maintained by triggers.

I've inherited an Oracle database with about 200 tables and no fixed referential structure. The naming convention specifies that each field contain a prefix identifying the table the field belongs to in, so the primary to foreign key structure is as follows: select a.a_pk, b.b_pk, c.c_pk from...

If you find that you are creating complex table joins and including complex criteria within Crystal, you should investigate using a stored procedure or view within the datasource itself. Doing that will keep the data compilation within the datasource, which will be much faster, and it will not...

Yeah, tried all the service packs, without luck. I tried writing another report, but Crystal just refuses to work with Exchange. I'm going to look into the mapi side of things next.

A weird problem: I have a report that has run quite happily for ages, and uses Exchange as it's datasource. I tried to run it yesterday and it's telling me that the source has changed. The source hasn't changed, but I proceed through the field mapping dialog anyway, and Crystal consistantly...

Draw a rectangle over the subreport making sure that it extends into the sections above and below the section containing the subreport. As the section expands with the sub-report, so will the rectangle. If you set the rectangle with no fill and no borders, the appearance of the report will be...

Got a strange problem with the format of a chart in Enterprise 9. The page is landscape, but the right-hand edge of the chart is being truncated as if it's in portrait orientation. Other objects in the same section of the report, but to the right of this invisible margin, and rendered ok. This...

Thanks Naith. I guess I couldn't see the wood for the trees. As Homer would say...Doh!!

Thanks, but maybe I wasn't clear. I want the report to open already drilled down if the record count is 1, saving the user the bother. Similar to a conditional suppress, I want to do a conditional hide on the detail section. Something like.... If RecordCount = 1 Then ShowDetail = True Else...

Is it possible to get a report to open and automatically show the detail? When the record count is greater than 1, I want the summary, detail hidden report to display, but if the record count is 1 I want it to automatically show the detail and avoid the drill down. Any ideas? The report is...

I've read that it's possible to use a stored procedure within a report, but could someone explain how to execute one? I wish to show a button on the finished report that the user can click and have a database update actioned. The stored procedure needs to receive a value from one of the fields...

I'm trying to get Active Desktop working on Windows 2000 Professional SP2, IE6. Everything seems to be configured correctly with everything enabled, and the page I've selected is synchronizing on time. Yet, nothing appears on the desktop. I'm at a loss. Any ideas?