By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,131 Members | 1,728 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,131 IT Pros & Developers. It's quick & easy.

Subreports in crystal reports

P: n/a
I'm having two tables with no relation and I want to list them both in one
report. How can I do this. I have tried to use sub report, but cant get it to
work? can someone please help me.
If I just create an subreport with one static text object it will not even
then show at runetime.
Oct 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Man oh man, when you have it working, Crystal is great. Geting there
however sometimes feels like a monumental feat.

First I recommend that you draw out on paper what you envision the report to
look like. Plan it all out, because some changes will require you to start
all over, at least it feels like it.

Second, you should have a master report and two sub reports. Each sub
report will contain the data that you are seeking and the master report just
houses the reports.

From memory, I would do this.

1. Create a blank report
2. Define your data connection
3. Right Click on the detail section band, select insert section below
4. In detail 'A' insert an embedded subreport, it should be aware of your
data connection and allow you to make the appropriate selections
5. In detail 'B' repeat

6. Save and incorporate into your application

HTH

"Stig" <St**@discussions.microsoft.com> wrote in message
news:03**********************************@microsof t.com...
I'm having two tables with no relation and I want to list them both in one
report. How can I do this. I have tried to use sub report, but cant get it
to
work? can someone please help me.
If I just create an subreport with one static text object it will not even
then show at runetime.

Oct 20 '05 #2

P: n/a
Thanks for your response, but this is exactly what I have tried to do several
times. And I know I have the data for both tables also. Because if I try to
use a cross-tab, data from both tables are showing. If I just create one
subreport with one text object and write hello World:-) in it. Even this
doesn't show up at runtime. I'm really desperate now.

"AMDRIT" wrote:
Man oh man, when you have it working, Crystal is great. Geting there
however sometimes feels like a monumental feat.

First I recommend that you draw out on paper what you envision the report to
look like. Plan it all out, because some changes will require you to start
all over, at least it feels like it.

Second, you should have a master report and two sub reports. Each sub
report will contain the data that you are seeking and the master report just
houses the reports.

From memory, I would do this.

1. Create a blank report
2. Define your data connection
3. Right Click on the detail section band, select insert section below
4. In detail 'A' insert an embedded subreport, it should be aware of your
data connection and allow you to make the appropriate selections
5. In detail 'B' repeat

6. Save and incorporate into your application

HTH

"Stig" <St**@discussions.microsoft.com> wrote in message
news:03**********************************@microsof t.com...
I'm having two tables with no relation and I want to list them both in one
report. How can I do this. I have tried to use sub report, but cant get it
to
work? can someone please help me.
If I just create an subreport with one static text object it will not even
then show at runetime.


Oct 21 '05 #3

P: n/a

Are you getting any errors or exceptions. How are you attempting to display
the report, winform and report viewer, or via asp.net?

How are you associating the data? Dataset, Connection Properties? Are you
attempting to change the location of the server before opening the report?

Where are you placing this text object? If you are placing it in the detail
section, it should be empty if there is no corresponding data. Place the
text object in the report header or report footer.

Do you have the section that the subreport is in set to suppress? Do you
have the subreport set to suppress.
I realize that most of these are trivial questions, but as I cannot see what
is occurring, I have to start from the beginning.

I you wish, send me screenshots to my email account and I will try to help
you out.

"Stig" <St**@discussions.microsoft.com> wrote in message
news:44**********************************@microsof t.com...
Thanks for your response, but this is exactly what I have tried to do
several
times. And I know I have the data for both tables also. Because if I try
to
use a cross-tab, data from both tables are showing. If I just create one
subreport with one text object and write hello World:-) in it. Even this
doesn't show up at runtime. I'm really desperate now.

"AMDRIT" wrote:
Man oh man, when you have it working, Crystal is great. Geting there
however sometimes feels like a monumental feat.

First I recommend that you draw out on paper what you envision the report
to
look like. Plan it all out, because some changes will require you to
start
all over, at least it feels like it.

Second, you should have a master report and two sub reports. Each sub
report will contain the data that you are seeking and the master report
just
houses the reports.

From memory, I would do this.

1. Create a blank report
2. Define your data connection
3. Right Click on the detail section band, select insert section below
4. In detail 'A' insert an embedded subreport, it should be aware of your
data connection and allow you to make the appropriate selections
5. In detail 'B' repeat

6. Save and incorporate into your application

HTH

"Stig" <St**@discussions.microsoft.com> wrote in message
news:03**********************************@microsof t.com...
> I'm having two tables with no relation and I want to list them both in
> one
> report. How can I do this. I have tried to use sub report, but cant get
> it
> to
> work? can someone please help me.
> If I just create an subreport with one static text object it will not
> even
> then show at runetime.


Oct 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.