Skip to Content
author's profile photo Former Member
Former Member

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

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...... ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 08:49 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.