How to add several SubReports

centenario · Post by **centenario** » Thu Jan 12, 2012 8:47 pm

Hi, im testing your software and it seems nice, i can make some high quality reports but i got some problems when im trying to make some reports.
All reports and subreports got as Datasource Stored Procedures (SP), SP 1 is the stored Prodcedure that retrieve all employee data, and the rest of Sureporters get data with some relation with those employee
Those reports got the next structure:

- Group Header - SP 1 (employeeID)

- DataBand 1 -SP 1 Employee Data (employeeID, EnterpriseID, Name...)
-Subreporter1 - SP 2 - got 2 parameters and their values come from row of DataBand1: @employeeID, @EnterpriseID
-Subreporter1 - SP 3 - got 2 parameters and their values come from row of DataBand1: @employeeID, @EnterpriseID
-Subreporter1 - SP 4 - got 2 parameters and their values that come from row of DataBand1: @employeeID, @EnterpriseID
-Subreporter1 - SP 5 - got 2 parameters and their values that come from row of DataBand1: @employeeID, @EnterpriseID
- End DataBand 1

-Footer Group

Well, i dont know how can i assign to parameters from subreports values from databand1, is it possible?
I've been trying with Relations and mastercomponent but data is absolutely wrong, show just numbers and not names...etc..

Thanks in advance

Post by **Alex K.** » Fri Jan 13, 2012 1:26 am

Hello,

Can you please send us your report with test data for analysis.

Thank you.

centenario · Post by **centenario** » Fri Jan 13, 2012 7:30 am

Hi, i've deleted that report, but i have created another one similar.
In this one thare are 4 datasources, one is the master and the other one are datasource thant bind subreports.
All subreports got as databand master the databand of datasource master.
Datasources from the firsts 2 subreports got relation datasource master and it retrieves info right
Last one got one parameter that is bind with a column from datasource master, datasource detail got property ReconnectoneveryRow = true.

I doesnt show info in a right way.

Datasources are Stored Procedures.

Where do i send you my report ?

centenario · Post by **centenario** » Fri Jan 13, 2012 7:47 am

Well i attach my report
Thanks in advance.

Post by **HighAley** » Mon Jan 16, 2012 8:49 am

Hello.

centenario wrote:Hi, i've deleted that report, but i have created another one similar.
In this one thare are 4 datasources, one is the master and the other one are datasource thant bind subreports.
All subreports got as databand master the databand of datasource master.
Datasources from the firsts 2 subreports got relation datasource master and it retrieves info right
Last one got one parameter that is bind with a column from datasource master, datasource detail got property ReconnectoneveryRow = true.

I doesnt show info in a right way.

Datasources are Stored Procedures.

You should set the relation on the Data Band of the third sub-report.

Thank you.