jamiguel
asked on
Report builder,D6,Master,Detail
Simple question:
How make a Report Master Detail with 2 querys(master/detail).... i see the documentation but the sample is with 2 ttables, thanks
How make a Report Master Detail with 2 querys(master/detail).... i see the documentation but the sample is with 2 ttables, thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
jamiguel,
I don't see the problem, queries and tables work exactly the same way in ReportBuilder. Attach the queries to a datasource, attach the datasources to a pipeline and use the pipelines for your report. Just as the sample shows you how to do with tables.
J.
I don't see the problem, queries and tables work exactly the same way in ReportBuilder. Attach the queries to a datasource, attach the datasources to a pipeline and use the pipelines for your report. Just as the sample shows you how to do with tables.
J.
ASKER
i work now my query master / detail i follow the next steps:
i make my query:
Select * from tmaster a, tdetail b where a.id=b.id
i connect these query to a datasource and these datasource to dbpipeline add a ppReport and conect to a dbpipeline i add a Group (Report->Group) master field (a.id) and add then fields (in detail band) of the master table, and in group detail add the fields of the detail table, and work !!!
Note all fields are in only 1 dbpipeline,
thanks for all
i make my query:
Select * from tmaster a, tdetail b where a.id=b.id
i connect these query to a datasource and these datasource to dbpipeline add a ppReport and conect to a dbpipeline i add a Group (Report->Group) master field (a.id) and add then fields (in detail band) of the master table, and in group detail add the fields of the detail table, and work !!!
Note all fields are in only 1 dbpipeline,
thanks for all
jamiguel:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
jamiguel,
No comment has been added lately (18 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
RECOMMENDATION: Award points to kretzschmar http:#7172325
Please leave any comments here within 7 days.
-- Please DO NOT accept this comment as an answer ! --
Thanks,
anAKiN
EE Cleanup Volunteer
No comment has been added lately (18 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
RECOMMENDATION: Award points to kretzschmar http:#7172325
Please leave any comments here within 7 days.
-- Please DO NOT accept this comment as an answer ! --
Thanks,
anAKiN
EE Cleanup Volunteer
ASKER
thanks...