Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

Crystal Reports

If have to select information from two different tables,to display the information on crystal rep.
For the first part of the report I run a querydef from visual basic to display the information for the query, then for the second part of the report I inserted database fields directly on the report.

Here is the problem, when run only the querydef from visual basic it displays the information for the first part of the report, but once I insert the databasefields on the report it somehow cancels the querydef and only displays the second part of the information for the diretcly linked databasefields in crystalreports.
0
gerhd
Asked:
gerhd
  • 2
1 Solution
 
gerhdAuthor Commented:
The problem is diplaying values in one crystalreport for a querydef ran in visual basic and  directly linked databasefields in crystalreports. I use an MS Access database and the querydef I call is a query written in Access. I also set different parameters in the querydef.
0
 
gerhdAuthor Commented:
Adjusted points to 150
0
 
rscott_youngCommented:
Here are a couple of ideas:

1)  Is there a logical link between the two tables?  If so, then you could link the tables, pass just the one SQL query to Crystal, and display the fields accordingly.

2)  You could create a sub-report in Crystal to display the second set of data below the first.

Hope this helps!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now