white_falcon02 Posted January 20, 2019 Share Posted January 20, 2019 Hi all,I am a newbie so please excuse my ignorance. I have the following data set which is generated from the sql analytical query that I am looking to turn into a line chart.periodsummedorderPeriod17-Dec69061230.1512/1/201718-Jan101563562.41/1/201818-Feb119569031.12/1/201818-Mar118191987.83/1/201818-Apr123163992.74/1/201818-May135128309.45/1/201818-Jun133909155.66/1/201818-Jul133295855.67/1/201818-Aug117197691.98/1/201818-Sep299121973.39/1/201818-Oct128298360.410/1/201818-Nov137291993.811/1/201818-Dec135947879.912/1/2018The datatypes are as follows:Period: StringSummed: big decimaldatePeriod: DateI have tried evrything I can think of to turn this into a line graph but with no luck. I am tring to set the period as the x-axis and the summed as the y-axis. I know once I see how this isdone, I will be fine from that moment forward but I am definately having issues getting the first chart knocked off and decided it was time to ask for help from you experts. I really appreciate any assistance you pros can give me. Link to comment Share on other sites More sharing options...
Solution yann22580 Posted January 21, 2019 Solution Share Posted January 21, 2019 Hi,Did you followed these steps ?First create a report, then add a DS (dataset) (in the Outline window) with your query, then drag a chart from the palette in the band you need, link your chart to the DS and specifiy your x-axis, y-axis...Regards Link to comment Share on other sites More sharing options...
white_falcon02 Posted January 21, 2019 Author Share Posted January 21, 2019 All I did was create a report with the sql to produce the records you see above, dragged a chart to the details band and attempt to set the x and y. I do not want to display the actual data in the report. Only the chart. Link to comment Share on other sites More sharing options...
white_falcon02 Posted January 21, 2019 Author Share Posted January 21, 2019 @Yann22300, you gave me enough of a clue to be able to get this working. It was the dataset step that I skipped that created the issue. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now