Solved

Crystal Reports

Posted on 1998-11-11
3
173 Views
Last Modified: 2010-04-30
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
Comment
Question by:gerhd
  • 2
3 Comments
 

Author Comment

by:gerhd
ID: 1444317
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
 

Author Comment

by:gerhd
ID: 1444318
Adjusted points to 150
0
 

Accepted Solution

by:
rscott_young earned 150 total points
ID: 1444319
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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question