crystal report

Question

0.00/5 (No votes)

See more:

.NET3.5

Hi -
I'm trying to display a report that pulls information from two different tables in one MDB database file. I have two categories of information - one category is event information and the other is action information. Both of these categories have:
- Titles
- Dates
- Locations
I'd like to be able to pull these two different sets of data together into one list using the similar characteristics listed above. Could u please help me to do this? I've read it could be done using Common Fields but I can't seem to locate how to set this up. Thank you!

Posted 13-Jul-10 7:31am

Mohamed Safi Samsudeen

Updated 13-Jul-10 7:52am

Smithers-Jones

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-07-13T07:52:00

Solution 1

Use UNION in your query.
Form a query where you fetch these details from both the table. Since both are having similar characterstics, use UNION to collate the data and use it as datasource to your report.

Posted 13-Jul-10 7:52am

Sandeep Mewara