Multiple details table in Crystal reports

Hi,
Can any one please tell me how can i use multiple details table in crystal reports.
I have a master table and 2 details table. I need to show the master record and the records from the detail tables.
I have created 2 details sections in my report. The problem is that the records from the 2 details tables are coming alternatively. i dont waht that to happen .

Regards
SudeeshUSE SUBREPORTS. tHIS WILL HELP. USE SUBREPORTS FOR EACH OF THE DETAIL TABLE.

KANGKANsql

Multiple Details In Crystal Report

Hi, I want to create a report which will have two details section in a master section . And I dont want to use subreport. The out put should look like this

MASTER ID - 1001

DETAIL - 1
A - 300
B - 200
C - 400

DETAIL - 2
X- 900
Y- 400
Z- 230

. I want the all the records of "DETAIL 1" to appear first and then all the records of "DETAIL 2" to print . How can I do this without using sub reports
Thanks for your help
-FerozIf possible group the report and suppress group header and details|||can you elaborate a little more .
Thanks|||Hi,

Kindly let me know if anybody has got the solution for this problem?

Thanks in advance|||Include both the tables in the report and link them accordingly.

Create a group Master->field and then its all records will be shown in the details section then the next group will come and its all records will be shown.

You can show the groups name in the Group Header and suppress its footer.|||Thanks a lot for your prompt reply.
Let me be a bit more clear about my requirement:

Hi, I want to create a report which will have two details sections ('Details a' and 'Details b') in a single report.

I am having two unrelated tables with multiple rows.

The out put should look like this:

DETAIL - a
A - 300
B - 200
C - 400

DETAIL - b
X- 900
Y- 400
Z- 230

I want the all the records of "DETAIL a" to appear first and then all the records of "DETAIL b" to print. There is no relationship between two tables. How can I do this without using sub reports.

Appreciate your help in advance!!!|||can you post the tables and report ?

Multiple Datasources in one report

I am very new to crystal so please excuse if this is a basic request...

We are using Crystal 9.2. I have two datasources, one in oracle and the other in sqlserver. I need to join the two datasources together with the full outer join option, but that option is grayed out in the Links tab in the Database expert window. I basically need to do a UNION ALL between the two datasources, I want to display all the rows from both datasources. Is this possible? What am I missing? Do I need to use a subreport? I need to do grouping/totaling between the two datasources.

What would be ideal, is if I could create a view between the two datasources (using the union all option) and then use that view as the datasource for the report. Is there anything like this available?

Any pointers would be greatly appreciated!Migrate data and keep them in a single datasource

Multi-page report

I am new to Crystal Reports, and I'm trying to create a multipage report. The first page is populated at the top and bottom with text and data fields. The middle portion is one large text box (with border) which could contain one or more pages of data.

If the text box goes beyond what will fit on the first page, I want it to generate additional pages. The fields on the bottom of the first page should be repeated on the additional pages. Also the one-line title of the first page should be repeated at the top of the additional pages, with the words "(- contined)" added to it.

Finally, the there is a last page that has text and data fields at the top and bottom (different than the others), and one empty text box with border filling up the middle.

As for the first (and additional) pages, the large text box has a border, which should fill up all available space (central 2/3 of first page, most of additional page) in each page, regardless of how much text is in it.

I have made the top portion of the first page the report header, the title line of the additional pages in the page header (suppressed on first and last page), the footer of the first and additional pages the page footer (suppressed on last page), and the last page the report footer. However, when I preview the report, I only get the first page.

Also, there is one report parameter that is input. When I preview the page, I want it to prompt me for a value, not just insert one automatically.I've played around with it a bit, but I'm down to two problems:

I have a page footer which takes up about two inches at the bottom of the page, but is suppressed on the last page. I have a report footer which is to take up an entire page (actually, I have it less than that). When I preview the report, the page footer appears on the bottom of the report footer page, forcing the bottom few items onto a next page. The report footer would fit entirely on the page if the page footer did not appear at the bottom.

Also, I have it prompting me to type in a parameter value, but the selection is not pulling up the record from the database that matches that parameter. All the fields are blank.