Cross tab data is getting multiplied if i use multiple queris in asingle report

[Former Member]

HI,

i am using multiple queris for displaying data and graphs(charts).

my requirement is to display 2 charts and data in crosstab in a single report.

all the three thing (2charts and crosstab) will use diffrent values.

I am writing 3 sql queries for getting appropriate values for charts and crosstab.

Now the problem, both charts and crosstab are taking the values of all 3 queris

i.e if i added crosstab first to the report values are coming correctly. After that if i add graph cross tab values are getting changed and graph values are not getting properly.

if i add graph first then its coming correctly.

if i tried to add all 3 components then values are going cores...... ?

[Former Member · Accepted solution]

When you say you are writing 3 sql queries what do you mean? Are you creating 3 SQL command objects in the database expert? If so this is your problem, Crystal will pull a cartesian product through (this is every possible combinatin of rows from the 3 queries).

If your 2 graphs and 1 crosstab are based on different datasets the way to approach this is to create each on a seperate report, then create a new blank report and add each of your 3 reports as subreports in the report footer.

Hope this helps,

Toby