Crystal Sub Report

Anytime. BTW, after you join in the tables 10 deep, you'll have to create
the groups (10 deep) to group at each level.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michelle de la Vega
Sent: Tuesday, November 03, 2009 12:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub Report





Sean,

Great advice, how did I not think of that before...

So far that seems to be working :)

Thanks again!

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA5C7D.3EE7B380
<mailto:image001.jpg%4001CA5C7D.3EE7B380> ]

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Sean McDaniel
Sent: Tuesday, November 03, 2009 11:43 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Sub Report

No,

Crystal is limited to a single level of sub-reports.

You can do the sub-assembly thing by left-joining the tables 10 deep to
itself.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>] On
Behalf Of
Michelle de la Vega
Sent: Tuesday, November 03, 2009 11:28 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Sub Report

Is there any way to put a sub-report inside a sub-report?

I am trying to develop my own custom BOM Costing report and am stumped on
getting all the cost with sub assemblies up to 10 deep.

Thanks for the help,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA5C78.C39FEF70
<mailto:image001.jpg%4001CA5C78.C39FEF70>
<mailto:image001.jpg%4001CA5C78.C39FEF70>
<mailto:image001.jpg%4001CA5C78.C39FEF70> ]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Is there any way to put a sub-report inside a sub-report?

I am trying to develop my own custom BOM Costing report and am stumped on getting all the cost with sub assemblies up to 10 deep.

Thanks for the help,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA5C78.C39FEF70]



[Non-text portions of this message have been removed]
No,

Crystal is limited to a single level of sub-reports.

You can do the sub-assembly thing by left-joining the tables 10 deep to
itself.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michelle de la Vega
Sent: Tuesday, November 03, 2009 11:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sub Report





Is there any way to put a sub-report inside a sub-report?

I am trying to develop my own custom BOM Costing report and am stumped on
getting all the cost with sub assemblies up to 10 deep.

Thanks for the help,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA5C78.C39FEF70
<mailto:image001.jpg%4001CA5C78.C39FEF70> ]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Hi,

We have Crystal XI. Here is an excerpt from Crystal Help that says you
can't. Maybe you can in a new version of Crystal Reports.

Regards,

Linda

What are subreports?

A subreport is a report within a report. The process for creating a
subreport is similar to the process of creating a regular report. A
subreport can have most of the characteristics of a report, including
its own record selection criteria. The only differences between a
subreport and a primary report are that a subreport:

* Is inserted as an object into a primary report; it cannot stand
on its own (although a subreport can be saved as a primary report).
* Can be placed in any report section and the entire subreport
will print in that section.
* Cannot contain another subreport.
* Does not have Page Header or Page Footer sections.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michelle de la Vega
Sent: Tuesday, November 03, 2009 11:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sub Report





Is there any way to put a sub-report inside a sub-report?

I am trying to develop my own custom BOM Costing report and am stumped
on getting all the cost with sub assemblies up to 10 deep.

Thanks for the help,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA5C78.C39FEF70
<mailto:image001.jpg%4001CA5C78.C39FEF70> ]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Sean,

Great advice, how did I not think of that before...

So far that seems to be working :)

Thanks again!

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA5C7D.3EE7B380]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Sean McDaniel
Sent: Tuesday, November 03, 2009 11:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub Report



No,

Crystal is limited to a single level of sub-reports.

You can do the sub-assembly thing by left-joining the tables 10 deep to
itself.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Michelle de la Vega
Sent: Tuesday, November 03, 2009 11:28 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Sub Report

Is there any way to put a sub-report inside a sub-report?

I am trying to develop my own custom BOM Costing report and am stumped on
getting all the cost with sub assemblies up to 10 deep.

Thanks for the help,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA5C78.C39FEF70<mailto:image001.jpg%4001CA5C78.C39FEF70>
<mailto:image001.jpg%4001CA5C78.C39FEF70> ]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]