| |
Data Dynamics Reports Support
Started by cyndichatman at 07-06-2009 2:33 PM. Topic has 5 replies.
  
|
|
Sort Posts:
|
|
|
|
 07-06-2009, 2:33 PM
|
cyndichatman
Joined on 10-30-2003
Posts 95
|
Drill down report
Attachment: pl.zip
|
|
|
|
|
I have created a simple report that uses an XML datasource. Also in the zip is an xml file with test data.
What I am trying to list is list account names in a matrix. If an account is a subaccount of another account, field Sub is set to True and Parent lists the account that is the parent of the subaccount. In the XML file, I have 3 accounts:
Revenue is the parent account that has two sub accounts: Product 1 and Product 2.
When the report is first generated, I want only one line for Revenue. Beside Revenue I want a plus sign that the user can click and the get details for Product 1 and Product 2.
I have create a matrix with one row group. The row is not visible if Sub is set to True. If I try to set that the row's visibility can be toggled by report item Name, then DDR crashes.
How can I create a drilldown that functions the way I describe?
|
|
|
|
|
Report
|
|
|
|
|
07-07-2009, 6:09 AM
|
GauravC
Joined on 12-11-2008
Posts 579
|
|
|
|
Hello,
To create a drill down report I would advice you to go through the following online walkthrough.
http://www.datadynamics.com/Help/ddReports/ddrwlkDrillDown.html
This walkthrough illustrates how to create a drilldown report using the Hidden and ToggleItem properties so as to allow users to drill down into more detail that is initially hidden.
Let me know if it helps.
Thanks,
Gaurav
|
|
|
|
|
Report
|
|
|
|
|
07-07-2009, 12:53 PM
|
cyndichatman
Joined on 10-30-2003
Posts 95
|
|
|
|
Thanks, the walkthrough definitely helped, I just had to convert to a matrix instead of using a table. I have two issues that I think are specific to using a matrix with multiple row groups (instead of using a table). Attached is a sample report and XML file that is used as the report's dataset.
When you preview the report
1. When the travel & lodging row is collapsed, why is there so much space between the row header (Travel and Lodging) and the first amount? The amount should be directly below the first column header, Starting Balance.
2. When you expand the travel & lodging row, is there a way for the Hotel, Airfare, and Total Travel and Lodging rows to appear below the Traveling and Lodging row header? Currently they appear to the right of the row header. With a table, you are able to have more than one row, so you can align a row below another row (versus on the same line)
|
|
|
|
|
Report
|
|
|
|
|
07-08-2009, 5:48 AM
|
GauravC
Joined on 12-11-2008
Posts 579
|
|
|
|
Hello,
I have been able to reproduce the firs issue. I can see the gap between the row header and first amount. After recreating the Name row group and visibility value the gap between two is reduced. Please find attached the modified RDLX file with this post.
Regarding the second issue I would like to inform you that at present it is not possible to set the drill down position however I have entered a Case 132380 to fix it.
I have also attached your email address to this case so that you can be notified when the issue get’s fixed.
Let me know if you need further assistance.
Thanks,
Gaurav
|
|
|
|
|
Report
|
|
|
|
|
07-08-2009, 12:22 PM
|
cyndichatman
Joined on 10-30-2003
Posts 95
|
|
|
|
Thanks. On issue 1, the only thing I notice is that I was trying to get the first row to become invisible when the drill down happened. In this scenario, the visibility of the line is not toggled.
However, I have a more pressing issue. Take a look at the revised report and xml file attached. I have two lines Revenue and Cost Of Revenue. Revenue has data below it and needs a plus/minis sign. However, there is no data below the Cost of Revenue row. How can I get the plus/minus sign to NOT show up on the Cost of Revenue row?
|
|
|
|
|
Report
|
|
|
|
|
07-09-2009, 6:11 AM
|
GauravC
Joined on 12-11-2008
Posts 579
|
|
|
|
Hello,
As I have understood, you do not want to show the plus/minus sign in case the row does not contains data.
If this is the case, then please remember that the data could not be known till the time you expand the row. For e.g. if you click on the plus sign for 'Cost of Revenue' row then the resultant data is fetched and thereafter it is shown in the data region.
Till the time, this happens we are not sure whether the data actually exists or not.
Regards,
Gaurav
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » Data Dynamics R... » Drill down report
|
|
|
|
|