Hierarchal data reports

I have set up a hierarchal report, which is based on one data set using a table and grouping. I have a group header, a details, and a group footer section in the table. The details is filtered based on one of the columns, and hidden with the ability for the user to expand and collapse the row based on one of the fields in the group header. My problem is, I am trying to set up a report which gets scheduled to run weekly, and emailed out to its users, in PDF format. The PDF format will not allow the user to expand and collapse the rows. I would just send the users a link to the report, and the can expand / collapse the rows they want to see, if they didn't mind having to be connected to set up their report, and having the extra step of exporting to PDF.

Is there a way to export to Excel and have the expanders still be there?

In the mean time, I have set up the report to always show the details rows, but since I am filtering out based on a certain criteria, the rows that do not have any data, show a blank line, which gives the report a confusing look. The empty rows never showed up when I have drill-down enabled, because if it was hidden, and no data, there is no way to expand the hidden row.

Any suggestions on what I can do will be VERY helpful. Thanks!

Brandon.

hi,

Try using MS reporting services

Follow this link: http://www.c-sharpcorner.com/UploadFile/asif.blog/RecursiveData06132006230750PM/RecursiveData.aspx?ArticleID=fdc78120-bf77-4fb2-9dc5-bb84d734c792

-Ajeeth

|||

I am using MS Reporting services. Why would I be posting to this forum if I were not? Did you even read my question/problem?

My problem is that I can get drill-down working, but it shows a space if I show all the rows because I have a filter which takes out rows which do not meet requirements. Or, I need a report that can be sent through RS scheduler via email and act as an offline report with drill-down abilities.

Thank you.

|||

Oh, did you mean report viewer?

If so, I am sorry. I will look into report viewer. I must have completely misunderstood your response...

Brandon.

|||Are you actually filtering out the groups or the rows? Filtering groups should contract the space for missing rows.|||

Well, I tried filtering on the row at first, the details row.. It would not keep my filter options for whatever reason. I would hit OK, then go back to filters on that row, and it would be gone. So, I changed the details row to a group row, and applied the filter, which filters out, but still shows a space. I did not mention above, but I guess I am using two grouppings, one for the header row, the other for the details, which I am filtering out data.

I am now probably confusing the problem, but now I am trying to allow visibility on the row based on its cell property in one of the text boxes but I can not figure out how to pull the data from the table, for each row. I just need to look up how to reference the text box inside a table, and hope it will calculate based on that text box, for each row in the table.

Thanks