Skip to Content

bar chart crystal report issue

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

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Mar 18, 2019 at 07:39 AM

    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.


    Add comment
    10|10000 characters needed characters exceeded