Questions tagged [drillthrough]

81 questions
0
votes
1 answer

SSRS - How to create a dynamic subreport within main report

I'm trying to create a user stats SSRS report which shows how many times a report has been accessed. I have the main table set up with report name and count of runs, but what I really want is to click on a the report name when rendered and to show…
0
votes
1 answer

Using dynamic URL to link to Drillthrough pages within the same report in Power BI

I have a report in Power BI. Currently I can drill through from home page using Field A to multiple other pages (say page for Category 1, page for Category 2, page for Category 3, etc.). Is there a way to use dynamic parameters in a URL to replicate…
user13399910
  • 1
  • 1
  • 1
0
votes
0 answers

Dynamically change values in drillthrough donut based on slicer selection

I have different account types under a country, and those accounts have values(income earned). I want to create a drillthrough donut chart which shows all accounts for a country based on slicer selection. Slicer has all the country names? I created…
maleficent
  • 53
  • 1
  • 7
0
votes
1 answer

Drill through in SSRS in Report Server using the expressions

I've my reports previously on SharePoint site. I recently deployed my reports to the Report Server. In the reports there're expressions on the URL Actions part in Text Box properties where expressions have been applied based on the parameters…
0
votes
0 answers

drillthrough rdlc report not loading

Am working in MVC5 visual studio 2015 . i want to create a parent and child report, the parent report loaded while the child report does not load. If i click a parameter field on the parent report, the child report will do as if it wants to load but…
0
votes
1 answer

Detail to detail drillthrough in Power BI

I have a Master page in a Power BI report with a list of IDs. For each ID's there are multiple detail pages set up as drillthrough pages - e.g. Overview Detail and Usage Detail. Each detail page takes in an ID and you can drillthrough from the…
Rodney
  • 5,417
  • 7
  • 54
  • 98
0
votes
1 answer

Does MongoDB Atlas support Drill down capability?

Using MongoDB Atlas for our HR Analytics product, but can't drill down into data. E.g. Attrition analytics -> Go by Location -> drill down into Grade/Band -> Gender, etc.
0
votes
1 answer

SSRS 2008 Drill through parameter filtering >= not working

I have a main summary report which has count and a drill through report showing the detail which has a parameter where the count from main report is passed to drill through. But I want to see the drill through report which has count greater than or…
sparc
  • 345
  • 1
  • 2
  • 13
0
votes
1 answer

DRILLTHROUGH not returning Dimension Keys

I have a created a very simple SSAS tabular model following Kimbal's Fact/Dimension philosophy (e.g. one fact table and 2 dimension tables (date. employee). When I use the DRILLTHROUGH statement (MDX) it returns the measure granular data (as…
0
votes
0 answers

How to export summary and detail drill through SSRS report in one excel on 2 different tabs

I have 2 SSRS reports. One is Summary (Main) report and other is Detail report. Summary report has Drill Through functionality which opens Detail report. I want to export both reports in one Excel file on 2 different tabs. I came across with this…
Jay Desai
  • 821
  • 3
  • 15
  • 42
0
votes
0 answers

SSRS Drill through Report not populating parameters automatically

I've two reports main and drill through, which I’m trying to get to run via the URL. The report will open in a new tab from the URL, but it doesn't run (with the parameters), the user has to select the parameters and one variable is populated from a…
clare
  • 13
  • 3
0
votes
1 answer

SSAS DrillThrough Action missing from Excel

I have several drillthrough actions defined, that were working at one time. For some reason most are no longer visible when I right click > drill through actions within Excel 2016. Has anyone experienced the disappearing actions, before? Any help…
KirstieBallance
  • 1,238
  • 12
  • 26
0
votes
1 answer

Getting Essbase studio, Drill through error:"Null DTExecuteReportOut object returned from provider"

I am getting "Null DTExecuteReportOut object returned from provider" while running Drill through report created from Essbase Studio(11.1.2.3). The report works fine for lower levels but gives this error when trying to pull at higher level like…
P.J
  • 29
  • 8
0
votes
1 answer

Pass SSRS parameters into Drill through report VIA url

Im having trouble passing multiple parameters to my drill though report using an url. I have got a single one working however when i try to add the next one it doesn't like what i have put. …
user5627259
0
votes
1 answer

PowerBI DrillThrough Pass different parameter

So I have a report from where I want to drill through a different report. The problem is that the Title field used as display repeats on different entries, Like this I need to drill by the ID (the only unique field), but this ID field is hard to…
Mike
  • 789
  • 8
  • 15