Skip to Content

Chart from data with two bex queries in crystal reports 4.0 for enterprise


I'm fairly new to crystal reports and I have a requirement to show the data from 2 bex queries in one single cross table. is it possible ?

after getting it i should be able to create chart with that data

Eg: my table would be something like below :

calendar day

Input : 12 34 50 60

Output : 09 23 19 57

Input Data will be coming from one bex query

Out put data comes from another bex query

is it possible to merge the dimensions and then work on ????

any help is much appreciated

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on May 14, 2014 at 02:02 PM

    Hi Tanveer,

    The only way you can add two BEx queries in a report is using a Subreport. The First BEx query goes in the Main Report and the second one goes in the Subreport.

    You'll not be able to add the dimensions and measures from these two BEx queries in a Crosstab anyway. Perhaps, you could create a mock crosstab and send values (all rows) from the Main Report to the Subreport as a string however, I can see that it's going to get complex.


    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.