Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
volyn
Starting Member
30 Posts |
 Posted - 2010-07-15 : 11:59:14
|
| Hello,I have table drill down report,which has 5 levels. Table is very simple and has 3 columns. when user reaches last level, he has possibility to click on value in first column of 5th level and see details in second "jump to" report.Detail has 15 columns.I need to create snapshot of main report but also for "jump to" report. I dont want to let user looking for detail "jump to" report separately.Is it possible to configure snapshot to let user see result of main report and also click-through second report ?Its a huge database table and it is impossible to generate report online. Subreport extraction to excel is not possible so I dont want to use it.thanks |
|
|
volyn
Starting Member
30 Posts |
Posted - 2010-07-18 : 14:06:33
|
| Or I let you know about exact case I have. I have in table report information about quantity and value of products from not fulfilled orders for each Key account in my company.They can see details grouped by their name itself, then they can drill down to data grouped by brands we sell.In each level I want to let them jump to another report with details, which materials exactly were not fulfilled (in brands, or everything by their name). Details have for example 4times more columns then grouped informations. So it is not possible to use subreport, they will need to export it to excel.Problem is, that in DB table there is a huge qty of data and I cant let them generate reports online.So how to solve that?If I use snapshot, then I have to create as many snapshots as parameters combination. So it sucks, I will create only one table with all Key accounts name and they will find themselves and drill down if they want to. But what about detail report? Could I create snapshot ? Will be snapshot original report jumping to snapshot of second report?Thanks |
 |
|
|
|
|
|
Snapshot also for "jump to report"