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 Columns Not Wrapping

I want to create a report with two columns with a single group heading with
one table. I will use this as a subreport in a larger report consisting of
single column tables. When I layout the report it shows two columns but when
I preview the report it is just one long half-size column and never wraps to
the second column (and the same thing happens when I put it in the larger
report).
Is there some setting I'm missing to get a multi-column table/report? Is
there another setting to make the multicolumns wrap in the smallest possible
vertical space?
Thanks for any tips.Multi-column reports only render as such on paper (when you actually print
the report), and also in PDF and TIFF export formats. All other render modes
(including the Report Viewer on screen) will appear as a single column.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Don Miller" <nospam@.nospam.com> wrote in message
news:exD9ZFyFIHA.2372@.TK2MSFTNGP04.phx.gbl...
>I want to create a report with two columns with a single group heading with
>one table. I will use this as a subreport in a larger report consisting of
>single column tables. When I layout the report it shows two columns but
>when I preview the report it is just one long half-size column and never
>wraps to the second column (and the same thing happens when I put it in the
>larger report).
> Is there some setting I'm missing to get a multi-column table/report? Is
> there another setting to make the multicolumns wrap in the smallest
> possible vertical space?
> Thanks for any tips.
>|||Thanks, didn't know that (or find it in documentation anywhere).
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:OCxmSq2FIHA.3548@.TK2MSFTNGP06.phx.gbl...
> Multi-column reports only render as such on paper (when you actually print
> the report), and also in PDF and TIFF export formats. All other render
> modes (including the Report Viewer on screen) will appear as a single
> column.
> --
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Don Miller" <nospam@.nospam.com> wrote in message
> news:exD9ZFyFIHA.2372@.TK2MSFTNGP04.phx.gbl...
>>I want to create a report with two columns with a single group heading
>>with one table. I will use this as a subreport in a larger report
>>consisting of single column tables. When I layout the report it shows two
>>columns but when I preview the report it is just one long half-size column
>>and never wraps to the second column (and the same thing happens when I
>>put it in the larger report).
>> Is there some setting I'm missing to get a multi-column table/report? Is
>> there another setting to make the multicolumns wrap in the smallest
>> possible vertical space?
>> Thanks for any tips.
>|||I am getting the second column on the next page.Am i missing something?
"Don Miller" wrote:
> Thanks, didn't know that (or find it in documentation anywhere).
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:OCxmSq2FIHA.3548@.TK2MSFTNGP06.phx.gbl...
> > Multi-column reports only render as such on paper (when you actually print
> > the report), and also in PDF and TIFF export formats. All other render
> > modes (including the Report Viewer on screen) will appear as a single
> > column.
> >
> > --
> >
> > Alain Quesnel
> > alainsansspam@.logiquel.com
> >
> > www.logiquel.com
> >
> >
> > "Don Miller" <nospam@.nospam.com> wrote in message
> > news:exD9ZFyFIHA.2372@.TK2MSFTNGP04.phx.gbl...
> >>I want to create a report with two columns with a single group heading
> >>with one table. I will use this as a subreport in a larger report
> >>consisting of single column tables. When I layout the report it shows two
> >>columns but when I preview the report it is just one long half-size column
> >>and never wraps to the second column (and the same thing happens when I
> >>put it in the larger report).
> >>
> >> Is there some setting I'm missing to get a multi-column table/report? Is
> >> there another setting to make the multicolumns wrap in the smallest
> >> possible vertical space?
> >>
> >> Thanks for any tips.
> >>
> >
>
>|||You need to put all fields on the left hand side. The second column appears
on the report, but doesn't contain anything at design time. Make sure your
whole report (columns 1 & 2) doesn't exceed your page width.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
news:613B2B6A-ABA7-4183-B0C5-C3BAF4BEBCBB@.microsoft.com...
>I am getting the second column on the next page.Am i missing something?
> "Don Miller" wrote:
>> Thanks, didn't know that (or find it in documentation anywhere).
>> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
>> news:OCxmSq2FIHA.3548@.TK2MSFTNGP06.phx.gbl...
>> > Multi-column reports only render as such on paper (when you actually
>> > print
>> > the report), and also in PDF and TIFF export formats. All other render
>> > modes (including the Report Viewer on screen) will appear as a single
>> > column.
>> >
>> > --
>> >
>> > Alain Quesnel
>> > alainsansspam@.logiquel.com
>> >
>> > www.logiquel.com
>> >
>> >
>> > "Don Miller" <nospam@.nospam.com> wrote in message
>> > news:exD9ZFyFIHA.2372@.TK2MSFTNGP04.phx.gbl...
>> >>I want to create a report with two columns with a single group heading
>> >>with one table. I will use this as a subreport in a larger report
>> >>consisting of single column tables. When I layout the report it shows
>> >>two
>> >>columns but when I preview the report it is just one long half-size
>> >>column
>> >>and never wraps to the second column (and the same thing happens when I
>> >>put it in the larger report).
>> >>
>> >> Is there some setting I'm missing to get a multi-column table/report?
>> >> Is
>> >> there another setting to make the multicolumns wrap in the smallest
>> >> possible vertical space?
>> >>
>> >> Thanks for any tips.
>> >>
>> >
>>