Eclipse Community Forums: BIRT » Multiple Diagrams from one SQL Select

Help

Home

Home » Archived » BIRT » Multiple Diagrams from one SQL Select(Multiple Diagrams from one SQL Select)

Show: Today's Messages :: Show Polls :: Message Navigator

Multiple Diagrams from one SQL Select [message #1424049]

Mon, 15 September 2014 11:31

Marc Vettorel

Messages: 2
Registered: September 2014

Junior Member

Hi all,

i'm new in building report using BIRT. I'm using 3.7.2, and my goal is to get multiple diagrams from one query.

Detail:
I have a grouped query with many articles and prices, grouped by date (one price for one article for each day a month). So it looks like:
article / price / date
xy / 320 / 01.09.2014
mv / 179 / 01.09.2014
ab / 699 / 01.09.2014
xy / 309 / 02.09.2014
mv / 184 / 02.09.2014
and so on

Now i want to have one page for every article with prices for a whole month, with a chart and detailed results.
So i need one own chart for every article, listing all the prices for one month in a line chart.
But i only can get one chart with all articles...
Unfortunately i haven't found the right documentation right now.

Can someone please help and advice?

Best Regards
Marc

Report message to a moderator

Re: Multiple Diagrams from one SQL Select [message #1434425 is a reply to message #1424049]

Tue, 30 September 2014 04:32

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

If I'm understanding correctly, you'll just need to put a chart in a grouped table or list and choose to get your data from the container, for the chart. Now, only the data from each group will pass to the chart. Hope this helps. Let me know if you have questions.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Multiple Diagrams from one SQL Select [message #1434531 is a reply to message #1434425]

Tue, 30 September 2014 07:59

Marc Vettorel

Messages: 2
Registered: September 2014

Junior Member

Hi,

thanks, putting a chart in a grouped table and inherit the data from the table to the chart works.

thanks a lot,
Marc

Report message to a moderator

Re: Multiple Diagrams from one SQL Select [message #1434840 is a reply to message #1434531]

Tue, 30 September 2014 17:28

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

You're welcome! Let us know whenever you have questions! Smile

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Multiple Diagrams from one SQL Select [message #1437020 is a reply to message #1434840]

Fri, 03 October 2014 19:43

Laxman V

Messages: 2
Registered: October 2014

Junior Member

Hi All
Birt download section is not showing clear info, pls advise on download items and to create a multi line chart by retreiving data from Database and to be displayed in a webpage.

Report message to a moderator

Re: Multiple Diagrams from one SQL Select [message #1437021 is a reply to message #1424049]

Fri, 03 October 2014 19:44

Laxman V

Messages: 2
Registered: October 2014

Junior Member

hi
trying to use the BIRT multi lne chart by retrieving data from DB and display in web page. pls advise the steps.

thank you

Report message to a moderator

Re: Multiple Diagrams from one SQL Select [message #1441641 is a reply to message #1437021]

Fri, 10 October 2014 01:40

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Do you have a designer downloaded? Have you connected to your database with a data source and data set, yet? Can you give a little more information on where you're stuck?

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:	BIRT 2.6.1 ....For each row in Parent Dataset; Child does not change
Next Topic:	Footer group in bottom of page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 23:39:57 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter