Eclipse Community Forums: BIRT » Table Grouping and Sub Report Conflict

Help

Home

Home » Archived » BIRT » Table Grouping and Sub Report Conflict(Table Grouping and Sub Report Conflict)

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

Table Grouping and Sub Report Conflict [message #1591718]

Thu, 29 January 2015 18:04

Eric Roberts

Messages: 5
Registered: January 2015

Junior Member

I am constructing a report comprised of a Table that contains a sub report in one of its data columns. The sub report is linked to the table by parameter binding to one of the table's data sets. This works and displays properly up to this point. However, the table also requires to be Grouped on one of the data sets. When this Grouping is applied to the table, the data in the sub report vanishes from the output. The data shows up again if the Grouping is removed, but I need to have the Grouping in order to complete the report.

I am completely stumped and have no idea how to resolve this. Please Help!

Report message to a moderator

Re: Table Grouping and Sub Report Conflict [message #1591726 is a reply to message #1591718]

Thu, 29 January 2015 18:09

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Can you attach your design or create a simple example of it with the sample database that will show the issue. Sample database version would be better as it would allow me to test, but your report might allow me to see the issue just by looking at the design.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Table Grouping and Sub Report Conflict [message #1591747 is a reply to message #1591726]

Thu, 29 January 2015 18:23

Eric Roberts

Messages: 5
Registered: January 2015

Junior Member

I can't provide the data, and I'm not sure how to attach the design.

My design is a table with several columns, and one of the columns has a sub report in the data row. The sub report is also a table by the way. the two tables are bound together by one of the data sets in the "super" table (using parameter binding). A grouping has also been applied to the "super" table.

Report message to a moderator

Re: Table Grouping and Sub Report Conflict [message #1591760 is a reply to message #1591747]

Thu, 29 January 2015 18:32

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

At the top choose "Post Reply" and you'll go to a form with an uploader.

As for the data, I know you may not be able to attach your data. The report will be fine. The sample database option I mentioned would be using the Classic Models Sample Database that ships with BIRT.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Table Grouping and Sub Report Conflict [message #1591761 is a reply to message #1591747]

Thu, 29 January 2015 18:34

Eric Roberts

Messages: 5
Registered: January 2015

Junior Member

Just figured out how to upload my design. Still can't provide you with data, it belongs to the company, and is being collected from the SQL query by the java controller that is generating the report. I hope that this can help you to figure out my problem. Thank you.

Attachment: ClassRostersActivityGroup.rptdesign
(Size: 71.62KB, Downloaded 257 times)

Report message to a moderator

Re: Table Grouping and Sub Report Conflict [message #1591769 is a reply to message #1591761]

Thu, 29 January 2015 18:38

Eric Roberts

Messages: 5
Registered: January 2015

Junior Member

Actually here's the data. I forgot that I made a note pad file of it.

Attachment: Activity Group - Class Roster.txt
(Size: 16.54KB, Downloaded 187 times)

Report message to a moderator

Re: Table Grouping and Sub Report Conflict [message #1592009 is a reply to message #1591769]

Thu, 29 January 2015 21:48

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

I don't see a reason for it to not work with a quick glance. Any way you could quickly set up the report to run off your txt file? I'm getting close, I think, but it's taking me some time to figure out what I'm associating with what since I don't know much about the data. Smile

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Table Grouping and Sub Report Conflict [message #1592183 is a reply to message #1592009]

Fri, 30 January 2015 00:05

Eric Roberts

Messages: 5
Registered: January 2015

Junior Member

The data in the report is being queried dynamically based on user parameter inputs. The data I gave you was taken from just one set of inputs.

If you're trying to get the report to run, then I suggest that you delete the report parameters on both the Master Page and in the Data Explorer tab. I am unable to give you those parameters values and they are not what's causing problems on the report. In fact delete everything on the Master Page as it will probably prevent you from running the report.

Report message to a moderator

Re: Table Grouping and Sub Report Conflict [message #1592202 is a reply to message #1592183]

Fri, 30 January 2015 00:21

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

I modified the data into a couple different CSV files and was working on creating scripted data sets to work as you had them to join to the existing elements in the report since I didn't know what your setup is as to recreate it. Just didn't know if you'd have an easier time setting it up to run for me than I was having. Smile

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:	Crosstab taking average of averages
Next Topic:	BIRT 371 report running fine on BIRT Designer but running on taking long time to run

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 12:48:17 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter