I am trying to do a report structure that has header and detail information. Please see the attachment (Existing Report is already working) .
Header information is coming from the header query and the details information is coming for the detail query. would like to know the build controls that needs to be used and also, how do i join header and details queries.
Thanks.
Quote from: vamsivanka on 05 Jun 2015 02:55:05 PM
I am trying to do a report structure that has header and detail information. Please see the attachment (Existing Report is already working) .
Header information is coming from the header query and the details information is coming for the detail query. would like to know the build controls that needs to be used and also, how do i join header and details queries.
Thanks.
If there is an existing report you can look at it to see the method, right? You didn't mention if your source is relational or dimensional, but I'd guess relational based on your screen shot.
If you have two queries in the report you can join them in the query explorer by dragging in a join from the toolbox. Then you'd create the appropriate grouping, create a header for that group and put the header items in there.
Alternatively you'd leave the two queries un-joined and then create a master detail relationship in the layout.
May be i didn't explain it right at the first time. I go the answer.
I am trying to have the List Header Information about the Titles of the List. to do this....
Select the List control, Change the "Column Titles" property to "At start of details".
Thank You.