pulling info from multiple reports at once to create one big report

[neeko1226]

I have 15 or so reports I built that all have different data sorted by State. I would like to build a process that pulls all 15 of them together by state. In other words, I would like to select the state, and then have a process pull together all 15 reports for that state in one document so they can be exported to a word document as a packet.

I thought of trying to create a "master" report and inserting the 15 as sub-reports, but I can not get them to format correctly. I created a state group on the master, and then suppressed all sections except the group footer, but then the page headers all show on the first page (overlapping eachother) and then the detail and page footers of the subreports all show on the second page (overlapping eachother).

Any Ideas?

 

[IdoMillet]

Subreports don't show page footers so your description doesn't make full sense to me. If you slow down and explain more clearly what sections are not suppressed in the main and sub-reports, where you inserted the subreports, what you are seeing, etc. it would be easier to provide help.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[neeko1226]

OK, good point. I'll describe what the 15 reports are like.

They all are grouped by a two byte char field called State.
They all have report and column headings in the report headers, but each report is not the same.
Within the state grouping, they are all grouped by a field called scope.
Detail is comprised of fields pulled directly from the database and formulas based on fields from the database.
Some of them have summaries in the State group footer.
Most of them have report foot notes the report footers.

I'm trying to have one report that will show them all in order of State. For Example:

AR
rpt 1
rpt 2
...
rpt 15
AZ
rpt 1
rpt 2
...
rpt 15

and so on.

 

[IdoMillet]

The layout of the main report & subreports is not clear.

There is no need to explain all the detail for all 15 subreports. Just explain where 1 subreport is inserted and in what way the result is not as desired/expected.

Another approach is to use a UNION SQL Command or View as the data source. This would allow you to achieve the desired result in a single main report.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[neeko1226]

On the "Master" report, I've tried inserting the reports in the different sections and get the same result. Currently, I have one subreport inserted to the State Group Footer of the "Master" Report. The report header for the first state of my subreport shows up on page one of the "Master", and the detail shows on page two. The second state report header shows on page 3 and the detail for the second state shows on page 4.

If I insert a second subreport below the first subreport, I get the same result, except now they overlap eachother.

 

[IdoMillet]

Subreports should not be inserted "below" each other. They should be inserted in a separate section for each. For example, GF1a, GF1b, GF1c, ...

This is because each subreport is set to "grow" by default.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

Right click each section that a subreport is in and select insert section below.

When you want a subreport afetr another, place it in a subsequent section, that way the sections themselves will prevent overlap.

As an aside, you've inadvertently learned how to overlap subreports

-k

 

[neeko1226]

I see what you both are saying about inserting subsequent group footers to prevent overlapping. That works great.

I still have the issue of the subreports being seperated into two pages though. I have subrpt1 in GF1a and suprpt2 in GF1b, and heres how the report previews:

Page 1 - subrpt1 header
Page 2 - subrpt1 group header, subrpt1 detail and subrpt1 footer
Page 3 - subrpt2 header
Page 4 - subrpt2 group header, subrpt2 detail and subrpt2 footer

I need it to show me:
Page 1 - all of subrpt1
Page 2 - all of subrpt2
etc.

Sorry if I'm not being clear enough. It all seems so clear to me because I've been trying it for two days.

 

[IdoMillet]

Turn on the Keep Together property of the subreport.
Set "New Page Before" on GF1b

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[neeko1226]

Not sure how to turn on the keep together property of the entire subreport?? It is currently turned on for each of the sections of the subreports and I'm still having the issue.

 

[synapsevampire]

The default of a subreport itself is keep together (right click the subreport and select Format Subreport, it's in the Common Tab, dpending upon your software version, nto posting basic information prevents supplying tailored responses and wastes time).

I would turn off the keep together of any sections within the subreport, main report as well as any groups (right click the group and select change group) that the subreport has or is in within the main report and turning those off.

-k

 

[neeko1226]

I tried turnig off all the "keep together" check boxes in the subreports and main report, but the page header of the subreport is still on a different page than the detail and page footer.

Again, sorry if I'm not conveying this clearly. I'm trying. Here's what I have and what I would like to get to.

What I have:
- 15 reports with different information.
- All 15 have column headings in the Page header and footnotes in the Page footer.
- All 15 have two groupings, State, and Scope (1 or 2). The scope grouping repeats on all pages if the detail is > 1 Page.
- All 15 have Detail that displays different areas in each state and scope,.sorted alphebetically by area.

What I would like:
A way to have all 15 reports combined so they group together by State. For example:

AR - rpt 1, rpt 2, rpt 3.....
AZ - rpt 1, rpt 2, rpt 3.....

I know I'm basically starting over, but maybe I'm going about it all wrong by tring to insert them into one "master" report.