This topic is locked

Master-detail reports

10/20/2008 9:27:04 AM
ASPRunnerPro General questions
J
jla001 author

Hi, we are trying to obtain a master detail report in which the master fields are shown only once (preferably in a free formatting, so not only as horizontal records) and where the detail records fields are shown as a list. (We are using ASPRunner Build 506).

Unfortunately we can currently only find the default reporting view in which all data are shown as horizontal records. Also it seems that when report grouping is used, only the grouping field goes into the repeated report part and the other master table field are repeated as a part of the detail records.
We currenty can obtain
CompanyName

FindingID WIOLocation Implication ActionID CompanyResponsible ActionDes

FindingID WIOLocation Implication ActionID CompanyResponsible ActionDes

FindingID WIOLocation Implication ActionID CompanyResponsible ActionDes

CompanyName

FindingID WIOLocation Implication ActionID CompanyResponsible ActionDes

FindingID WIOLocation Implication ActionID CompanyResponsible ActionDes
In the end we would like to be able to see something like the example underneath:
FindingID CompanyCode

CompanyName Implication

ActionID ActionDes CompanyResponsible

ActionID ActionDes CompanyResponsible

ActionID ActionDes CompanyResponsible

ActionID ActionDes CompanyResponsible
How can we obtain such a hierachical view?

J
Jane 10/24/2008

Hi,
you can concat some fields on the Edit SQL query tab and then use it as group fields on the Report: Group fields tab.