on 03-17-2019 5:56 AM
I'm working on crystal report which it display details of the products for a specific day of current year and same day for the last year but I faced a problem when I tried to plot a bar chart for current and last year where it shows the legend twice for example item1 , item2 , item1 ,iem2 since I used to sql queries one for current and other for last year. almost done with report and it's working so tried to figure out a way to solve bar chart issue , finally I tried to use union all to combine 2 queries but is it a appropriate way ?
any help would be appropriated
Thanks in advance
HI Maryam,
Please post a screenshot of the chart.
Ideally, you'd want the query to return 3 fields:
Date, Current year Summary, Last Year Summary
You can then use the Date field as the 'On Change of' and the two summary fields under the 'Show Values' area.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.