Questions tagged [drillthrough]

81 questions
4
votes
0 answers

Drill Through not working in SpagoBI server in birt report

This is the setting of the hyperlink in birt report The script used to compute the param is as follows: if (params["idContratto"].match(row["contract_number"].toString()) == null){ if (params["idContratto"].value == "abc"){ …
dhS
  • 3,739
  • 5
  • 26
  • 55
3
votes
1 answer

how to rename drill-through columns in icCube?

Is it possible in icCube to name the columns returned from a drillthrough statement. Now they are just technical names and it is not end-user friendly?
Arthur
  • 1,692
  • 10
  • 14
2
votes
0 answers

Misleading cell security error message prevents drillthrough action on SSAS2008

I have a cube with no cell security configured, and get an intermittent problem with a drillthrough action. The cube has two measure groups: One with accounting transactions from a financials application (Oracle Financials) and one with a set of FX…
ConcernedOfTunbridgeWells
  • 64,444
  • 15
  • 143
  • 197
2
votes
1 answer

Microsoft Power BI drillthrough from one table report to another (each uses different datasets)

I am fairly new to Power BI reporting. My question may be somewhat pedestrian. I have this situation below: I have a Category report in a table in Page 1 of Power BI desktop; this Category report is developed from Categories dataset. I have a…
user3812887
  • 439
  • 12
  • 33
2
votes
2 answers

drill through from power bi card

I need some help with drill through. I have a main dashboard with high level aggregated data. I need to drill through to a details report I have created with more granular data. The chart type I have used in the dashboard is a CARD, to which it…
dragonfury2
  • 375
  • 5
  • 20
2
votes
1 answer

SSRS report pass multiple VALUES to drill through report parameter

I created a report with 5 fields in a hierarchical order: Order Date Time of Day (AM/PM) Parent Name (aka customer) Product Line BIC Part Number (aka Item) Each field expands down to the next level, so order date expands to time of day, etc. I…
Andrew Corson
  • 93
  • 3
  • 11
2
votes
2 answers

Drillthrough function in Power BI column chart - show day numbers instead of dates

I have created 2 different column charts in my Power BI report. The charts show the report usage by month and day (Day 1-31) - in this case for October. Only one month can be selected at a time. I have added a drill-through function to the chart so…
krynil
  • 233
  • 2
  • 5
  • 18
2
votes
0 answers

SSRS 2008 drill through subtotal and grand total parameters

I have a drill through report I'm creating in SSRS (SQL Server 2008 R2). The parameter pass-through to my detail report works fine for any normal detail row in the summary report tables, however the subtotal and grand total rows only pass the first…
2
votes
0 answers

Drillthrough disabled after adding CUBESET function

Originally, I have using CUBEVALUE function in Excel 2010 and it is working fine with the drillthrough function. The cubevalue function looks like this: =CUBEVALUE(connection, member_expression1, member_expression2, member_expression3) When I try…
kingkong0924
  • 301
  • 2
  • 5
2
votes
1 answer

SSRS 2008 R2 drill through report promts for authentication

I am facing an issue with running a drill through report from the parent report. When I click on the link field in the parent report to drill through report I am getting prompted for username and password (windows security). I am connecting to the…
2
votes
0 answers

Drilling through in ssas to a dimension attribute that has hierarchy disabled

I am using SQL Server 2008 R2, developing using BIDS. I have a very large cube, with many dimensions, and I am building a drill through action. The requirement is for a very broad drill through, which includes many fields that are in the fact table…
Moshe Yossef
  • 39
  • 1
  • 4
2
votes
1 answer

What is the difference between a click through and a drill through report in ssrs?

I was asked this question yesterday and I didn't know the answer. I'm a total ssrs noob so if you could explain it thoroughly that would be helpful. What is the difference between a click through and a drill through report in ssrs?
crack3r
  • 49
  • 1
  • 5
1
vote
1 answer

SSRS Drillthrough server report error

I have a SSRS report with an action on a text-box. Go to report property is set to the parent report so this makes the parent report also a drillthrough report for itself. I deployed the report on the report server and it is rendered ok and also the…
1
vote
1 answer

SSRS Drill through Parent report to Child report with 2 parameters

I want to drill through from Parent Report to Child Report, Where 2 columns from Parent acts as Parameter to child. I made 2 parameters Hidden, because value will be retrieved by Parent report. But I m getting "The 'ColB' parameter is missing a…
1
vote
0 answers

Is the Drill Through (or Drill Down) functionality for RDLC report only available for web applications?

We have several Crystal Reports that are used in a Windows Form application that we are re-creating using RDLC. One of the reports needs the ability to drill through (or down) to more detailed data. I've followed several examples (mostly for SSRS)…
1
2 3 4 5 6