Report/subreport help?

How would you run one report that is made out of two reports at the same time to get them dispayed on seperate pages as well.

Would you create a subreport or something else, and how many subreports can you have within a report, and if you had more then one where is the best places to insert it in the report and would you know where can I find some info about that.

I hope all of this makes sense,because I am just completely stuck.

Regards"How would you run one report that is made out of two reports at the same time to get them dispayed on seperate pages as well... and if you had more then one where is the best places to insert it in the report"

- I would create 2 subreports. The best place to put them (I think) would be the details section. Make a Details a and a Details b and set the NewPageAfter for Details a.

"how many subreports can you have within a report"

- I'm not sure what the limit is. I have a report that has 3 subreports without a problem.

"where can I find some info about that."

- Not sure about any specific websites, but you can try a search in following links:

Crystal Reports Help:
http://support.businessobjects.com/search/advsearch.asp

Crystal Reports Forum:
http://support.businessobjects.com/forums/default.asp|||thanks a lot for your help, I got some good suggestions, I just have to make it work now.

Regards

Report works fine stand alone, but fails when used as subreport

I have a report which I have tested and works fine. now I'm trying to use it as a subreport. the "outer" or main report is very simple: it just has a company standard banner and some header/footer information, and then a single subreport. there is no passing of parameters between main report and sub report. the subreport does have its own parameter to govern its dataset, and provides its own default for that.

The error that I'm getting is this:

[rsErrorExecutingSubreport] An error occurred while executing the subreport ‘subreport1’: An error has occurred during report processing.

[rsMissingFieldInDataSet] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Year’. This field is missing from the returned result set from the data source.

[rsErrorReadingDataSetField] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Year’. The data extension returned an error during reading the field.

[rsMissingFieldInDataSet] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Month’. This field is missing from the returned result set from the data source.

[rsErrorReadingDataSetField] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Month’. The data extension returned an error during reading the field.

[rsMissingFieldInDataSet] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Date’. This field is missing from the returned result set from the data source.

[rsErrorReadingDataSetField] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Date’. The data extension returned an error during reading the field.

[rsMissingFieldInDataSet] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Wt_TO_MTD’. This field is missing from the returned result set from the data source.

[rsErrorReadingDataSetField] The data set ‘WarrantMasterCube’ contains a definition for the Field ‘Wt_TO_MTD’. The data extension returned an error during reading the field.

[rsNone] An error has occurred during report processing.

Of course, this doesn't happen when I execute the subreport by itself. What kinds of things should I be looking at to get to the bottom of this. Thanks!

Try by giving default value for your subreport.

Thanks

Raj Deep.A

|||

As noted above, the report being used as a subreport does have its own default parameter.

The error actually went away without me changing anything in my reports. What I did was leave teh subreport open in preview mode, tehn preview the main report. this seemed to fix the "fields not found" error.

I then edited the parameters property of the subreport object embedded in the main report, so that the user chosen parameter value in the outer report passes through to the subreport, and it all works fine.

Basically there must be some flakiness in some internal component that was causing the error.

Report works byitself, but not in a SubReport

Hi All,
I am trying to run a report which has no parameters. it works fine in
design and even on the report server. but as soon as i put it in a
subreport it gives an error
"Error: SubReport could not be shown"
i have tried almost all of the help available on these group, i have
put the report to be of the same size, removed all the parameters(so
there are no parameters).
will highly appreciate any valuable suggestions.
:-)hi,
theboulevardguy1@.gmail.com wrote:
> "Error: SubReport could not be shown"
This is not an Access or VBA error. So take a look at the report events
(On Load, On Open). There must be some piece of code throwing that
exception.
mfG
--> stefan <--|||I presume you are getting the error in the VS designer. Is the calling
report is in the same project as the subreport?
Also you posted this to reporting services group and access. They are
quite different reports. I am assuming this is a reporting services
report.
theboulevardg...@.gmail.com wrote:
> Hi All,
> I am trying to run a report which has no parameters. it works fine in
> design and even on the report server. but as soon as i put it in a
> subreport it gives an error
> "Error: SubReport could not be shown"
> i have tried almost all of the help available on these group, i have
> put the report to be of the same size, removed all the parameters(so
> there are no parameters).
> will highly appreciate any valuable suggestions.
> :-)