create two tables with two different data set in a report

building reports crystal reports
1

Hello expert,

 I want to create a crystal report with two different data set, how can I put those two different data set separately into two tables?

Many Thanks,

cetzhbo (BOB member since 2011-03-30)

2

Need a bit of clarification. Are the two data sets related to each other (i.e. have a joining field)? Then you should be able to use a command or the database expert.

If not, then it probably would be best to have one data source in the main report and another data source in a sub report to avoid a Cartesian product issue.

I hope this helps.

kevlray :us: (BOB member since 2010-06-23)

3

thanks, but my data source for subreport is the procedure same as main report, how can I merge those duplicated parameter together? those parameters are set in the oracle store procedure.

cetzhbo (BOB member since 2011-03-30)

4

I have not used Oracle stored procedures. So, my suggestion may not work with them.

I am not sure what you mean by duplicated parameter?!?

kevlray :us: (BOB member since 2010-06-23)

5

my main report and subreport are using the same procedure, this precedure has 3 parameters, so when I run the report, there are same 3 same parameters showed up individually for main report and subreport, in WEBI report, we can merge those parameters with same description, but how can I implement it in crystal report?

cetzhbo (BOB member since 2011-03-30)

6

Again I am a bit confused. You say the parameter show up on the main report and the sub-report. So you are displaying the parameters in the main and the sub-report? If not, then I need to understand what you mean by ‘there are same 3 same parameters showed up individually for main report and subreport’.

kevlray :us: (BOB member since 2010-06-23)

7

in the parameter dialogue, parameter presented in following sequence:

       par1
       par2
       par3

       par1
       par2
       par3

upper part for above sequence is coming from main report, and lower part is comming from sub-report.

I only need it to present as follows:

       par1
       par2
       par3

see, there three parameters can be use in main and sub report. I only need to input once for each parameter

cetzhbo (BOB member since 2011-03-30)