Questions tagged [drillthrough]
81 questions
0
votes
0 answers
SSRS 2008 Drillthrough Delay
I have two reports in SSRS 2008, Dashboard and Drillthrough.
Dashboard contains many datasets (all stored procedures), and takes about 4-5 seconds to run.
Clicking on an aggregated value in one of the tables in Dashboard takes the user to…
Chris Mack
- 5,148
- 2
- 12
- 29
0
votes
1 answer
SSRS: Go To Action Expression to Direct to Seperate Drillthrough Reports
Currently, I have a tablix that shows Number of Records by Group and if they were Completed on Time. Tried to show best my Tablix in the picture below:
I only have 5 different groups that show up in my Groups…
smul86
- 401
- 1
- 8
- 22
0
votes
1 answer
SSRS Drill Through Action When Value Is 0
I'm using Visual Studio 2012 for my current project.
I currently have a matrix that has the fields Employee, Count(Files)and Avg(AgeFiles) which is how long they are open/have been open.
Basically, right now I have 7 employees. When I pull in my…
smul86
- 401
- 1
- 8
- 22
0
votes
0 answers
SSAS - dimensional security and drillthrough
I have an OLAP (multidimensional) cube where I have implemented dimensional security by adding an MDX expression to a cube dimension (using the UserName() function).
The security model works fine and the user gets restricted access to data in the…
jockefe
- 11
- 4
0
votes
1 answer
pass result query of report to drillthrough report as parameter
everyone!
Im facing a problem and hoped you could help me. So bassiclly I have to parse Data from MySql to Oracle, but the hard thing is have to do it through SSRS Reporting.
The situation is like this: I have a one report which returns query with a…
Сабак Илаев
- 1
- 1
0
votes
1 answer
MDX Drillthrough subcube not working
I have a query as such
DRILLTHROUGH
SELECT NON EMPTY { [Measures].[#] } ON COLUMNS,
NON EMPTY
{
( [Location].[Name].[Name].&[Test Location] )
} ON ROWS
FROM (
SELECT (
{ [v Item].[Item].&[Option 1], [v Item].[Item].&[Option 2], [v…
Ajwhiteway
- 986
- 1
- 9
- 23
0
votes
1 answer
SSRS: Jump to report drillthrough link with relative and absolute paths outside of Reports folder
I have two reps, constructed in VS 2005 and running in sharepoint mode (Sharepoint 2005, IE11, SQL Server 2008R2). Their locations (whatever):…
Globe
- 280
- 2
- 15
0
votes
1 answer
SSRS Drillthrough report - parameter passing
I have one report with columnName called as 'referenceName'. Two rows get displayed on this report with two different values for 'referenceName' column.
When I am click on the first/second value in the 'referenceName' column only first value gets…
Creative Mind
- 13
- 1
- 5
0
votes
1 answer
drilling from powerbi to ssrs
I currently have a suite of about 25 SSRS reports. Some are very high level and from there you can drill into more detailed reports. Some of the high level reports are basically simulated pivot views of the data in a matrix with drillthroughs on…
Dave Sapelak
- 3
- 3
0
votes
2 answers
How to Disable the double click option for DrillThrough Action in SSAS Cube
I have requirement to create the DrillThrough Action in SSAS Cube. Along with we will give DrillThrough Actine in excel report for few program not for all. We have made the Action based on that and we have limited DrillThrough feature for those…
Displaying Error
- 1
- 1
0
votes
0 answers
SSRS - show and hide based on expression drill down subreport
See the below sample image url. I created the main report having four details with toggle to drill down the sub report. If I click the Detail1 the subreport1 will expand drill down then I click Detail2 the subreport2 to be expand. But still the…
vinoth
- 35
- 2
- 13
0
votes
0 answers
URL - Drill through report not running with parameters
I've two reports A and B, which I’m trying to get to run via the URL. I can get the report to open (from the URL), but it doesn't run (with the parameters), the user has to select the parameters again. Both reports use the same parameters BTW.
The…
ItsDanny
- 165
- 1
- 11
0
votes
1 answer
multiple drillthrough events in one report ssrs
I have a main report linked to two subreports, my problem is I can only access one of the reports using drillthrough event, when I try to use an if statement it no longer recognize the data source, I used a "go to url" action to link to the other…
Christrian BP
- 67
- 1
- 9
0
votes
0 answers
Drill through facts attributs
I am working on a big cube, I am using a drill through action to get the details of my products, so the details have to be dimension attributs to be able to display them.
I wish to display other field that are part of the fact table (Product…
BOB
- 11
- 2
0
votes
1 answer
Show multiple drillthrough tables in a single Excel sheet
I need to create a report (for printing) that has two sections. The top section contains the scorecard, and the bottom section contains the drillthrough information for any "red" items in the scorecard.
The scorecard is currently a PowerPivot table…
Tallie
- 1
- 1