Subreport: cannot/don't know how to refresh subreport dbname thru VB Code 
Author Message
 Subreport: cannot/don't know how to refresh subreport dbname thru VB Code

I have a CRW6 report with 2 sub-report that retrieves data
from SQL server 6.5.  The report is running as a .rpt file
and is triggered by a Visual Basic exe.

The report produces error stating that dbname.table.field
not found when the sub-report is present because the
dbname not longer exist on the client site.

Problem Description
If we are going to run a report that is developed under
another database (different name but identical structure)
such as one for unit test, one for UAT and one for
production, I have to refresh the connect property thru
the Visual Basic code before running it.  This approach
works fine for those without sub-report.

Investigation Made
1. Delete sub-report from the problem report
No more errors.  It looks like that the sub-report is not
2. Check connection info
I have downloaded a update60.exe in crystal decision site
that allow me to change the connection info such as db
name without the Crystal Report designer.  Its seems that
CRW has extracted the dbname info from my DSN and put it
into the rpt itself.  Not improvement if I change the
dbname thru the utility.
N.B. the utility itself is buggy as it overrides my page
setup from landscape to portrait and all fields are
resized and eventually truncated.

Wed, 10 Dec 2003 11:20:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Subreports don't grow properly

2. Subreports not refreshing from VB application

3. viewing subreports/procedures called by subreports

4. Could I Add a Subreport to a Subreport?

5. Subreports in subreports

6. Subreports within Subreports

7. SubReport within a SubReport?

8. Subreport in subreport ?

9. Subreports in subreports

10. vb5 Crystal Reports 6 and Subreports Can we conditionally call subreports from primary reports

11. CR8 - Subreports of Subreports

12. Using data from a subreports, in other subreport :|


Powered by phpBB® Forum Software