Want The Parameters To Appear ON The Drillthrough Report

Nov 29, 2007

Hello again,

We have a drillthrough report that our users will see as part of an ASP.net page. I would like to nicely show the parameters that were sent through from the main report, maybe in a text box of some kind. However, when I set a text box value to =Fields!FieldName.value, I get the tuple: [Dimension].[Hierarchy].&[Member]. I just want the Member.

I know I can parse out the value, but is there any easier way that I'm missing. We aren't using the parameter bar that comes with RS, we want the report itself, above the matrix with the data, to show the parameters.

Any ideas, resources, references, links or good clean jokes would be appreciated.

Thanks,
Kathryn

View 2 Replies

Pass The Parameters From Main Report To Drillthrough Report

Nov 28, 2007

Good morning, all

I have a really cool Budget report which has two matrices on it. One is used/visible if the user selects four levels of grouping, and one is used if the user selects only three levels of grouping. The four choices for grouping are four fields, Par, FERC, Point, and Resource.

Since grouping is optional, I need a way to pass the parameter for a field that is not grouped on from the main report to the drillthrough report. For example if the user chooses to group on all fields but Point, I need to pass the report parameter that was used by the main report for Point to the drillthrough report as a report parameter.

So, I tried testing the three grouping levels values and if none were equal to "Point" then pass in the parameter by putting the following expression in the Parameter Value box for the Point parameter on the Navigation tab of the datacell of the main report that is the drillthrough link:

=iif(
Parameters!GroupLevel1.Value <> "Point"
and
Parameters!GroupLevel2.Value<>"Point"
and
Parameters!GroupLevel3.Value<>"Point"
,
Join(Parameters!PNTPoint.Value,",")
,
Fields!Point.UniqueName
)

But this is not working; the drillthrough report shows a blank dropdown for the Point parameter and I have to manually set it. Does anyone see an error in the syntax of the iif statement?

Any references, links, resources or good clean jokes would be greatly appreciated.

Thanks,
Kathryn

View 1 Replies View Related

Drillthrough Question - How To Return To Same Report Page Where Drillthrough Occurred?

Apr 10, 2007

Hello,

I have a master report that uses the "Jump to report" property to drill through to a detail report when the user clicks a report column value. This all works great and the users love it. However, when I click the brower's "Back" button to return to the master report, the master report is rerun and I am returned to page 1. If I drilled through on page 25 of the master report then I have lost my original position and I must navigate back to page 25. The users don't love this "feature"!

Is there a way I can return from the drill through detail report to the master report without using the browser's back button and losing my original position in the master report?

Thanks,

BCB

View 1 Replies View Related

Drillthrough Help In Report Builder

Jan 8, 2007

Hi,

I've looked at all of the published materials related to this subject that I could find but cannot find a good answer.

I'm trying to find out if there is a way to directly influence what details are shown when a figure is clicked on in a report.

I know it shows related data but it does not seem to show it all, infact it seems to pick pretty arbitrary things.

I've tried messing around with the attribute properties (in particular the EnableDrillthrough one) but to no avail.

Is there anything I am missing?

Thanks in advance.

View 4 Replies View Related

DRILLTHROUGH In Report Server

May 21, 2007

Dear all,

Please help to create DRILLTHROUGH in a report server project. I am a beginner . I want the DRILLTHROUGH featrure in Report server like same as that of analysis server project

Please help

regards

Polachan

View 3 Replies View Related

Drillthrough Report Link Not Working

Oct 25, 2007

Good morning all!

I am working on a Actuals vs Budget report which needs drillthrough capability. Right now the reports are not deployed, I am working on them in Visual Studio 2005.

My main report has a text box with the Navigation tab set to Jump to report: DrillThrough1025. I have set all the parameters to pass through to the drill through report.

When I preview my main report and click on the drillthrough textbox, the DrillThrough1025 Report opens, but it opens with the parameter bar at the top, waiting for the parameters to be filled in.

Am I making a basic newbie error somewhere?

Any ideas, references, or resources would be greatly appreciated.

Thanks,
Kathryn

View 1 Replies View Related

Trouble With Dynamic Drillthrough Navigation Using Jump To Report

Feb 26, 2007

I'm having trouble dynamically specifying the name of the report I want to drill through to.

I have the follwing expression in the Jump To Report field on the Advanced Textbox Properties Navigation tab:

=IIF( Fields!Third_Element.Value = "NONE", "Details Report.rdl", "Second Level Service Sub Report.rdl")

I get an error saying I'm missing the true part of the expression... Am I specifying the report name incorrectly? Both reports have the same parameters even though each report uses different parameters:

C:devReportsSLA Request TypeService Desk SLA Performance - First Level Service Sub Report.rdl The expression for the textbox ��Second_Element�� contains an error: [BC30455] Argument not specified for parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.

Also, what does the "Omit" parameter do in the paramters set up? I tried dynamically turning parameters on/off based on the report I needed to call and it didn't react as I expected.

Does anyone have any ideas?

Thanks

Carol

View 5 Replies View Related

Drillthrough In Calculated Fields Enable When Drillthrough Option Is Disable In Original Fields, Is This A BUG?

Jan 21, 2008

Hi people
My users are having troubles with link to default drillthrough report when reports are exported to excel (they REALLY don't like this behavior ), so I decided set all of them disabled in report model, this work fine, but calculated field in reports has this drillthrough link.

Let me show you the situation. Entity Product has an UnitaryCost field, I set the EnableDrillthrough Property in False so when I export a report with this field, no link is shown.

But if I create in the report a calculated field Round(UnitaryCost) this field has a Drillthrough Link

Is this the standard and expected behavior? or its simply a BUG?

Have I done something wrong in my model? and in this case, How I can correct this?

regards.
Julio Diaz.

View 1 Replies View Related

Run Report By Different Parameters Without Having To Enter Information For All Parameters At Same Time

Oct 29, 2013

I have a SSRS report with four parameters,and I want to be able to enter information for two of the parameters and run the report opposed to all four of them. However, when I select allow blanks and only select the parameters that I want to run the report by, the report come back blank..Essentially, I want to be able to the run report by different parameters without having to enter information for all parameters at the same time.

View 2 Replies View Related

How Do I Jump To Another Report Based On A Value In My Current Report? Report Has No Parameters.

May 3, 2007

How do I jump to another report based on a value in my current report. The report that I am jumping from has no parameters, just values.

View 7 Replies View Related

How To Pass Parameters In Url For A Report Published In Reportserver (report Built On Stocked Procedure) ?

Apr 30, 2007

Hi,

I have created a report with the report server project template.

the report is created from stoked procedure having defaut input parameters.

With visual studio, i publish my report on reportserver. whenever i access to my report on this url :

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fReport+Project4%2fReport4&rs:Command=Render. the created report is with the default parameters.

I would like to know if i can transmet parameters for the stocked procedure to build the report with the request i want.

I tried to put parameter directly in the url in this way

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fReport+Project4%2fReport4&rs:Command=Render&@region='toto'

but without success.

my error message is that one

An attempt was made to set a report parameter '@region' that is not defined in this report. (rsUnknownReportParameter)

My stocked procedure is :

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER procedure [dbo].[akli] @region varchar ='m'
as
select * from dbo.Report2 where region=@region

The request used to buid the report ?
DECLARE @region varchar
EXECUTE dbo.akli @region

What is wrong in that ?

Thanks for your help.

Arioule

View 1 Replies View Related

Passing Report Parameters To An SSRS 2005 Report Hosted In Sharepoint 2007

Nov 18, 2007

Here is a situation in my company:

We have an Office SharePoint 2007 site, we developed a couple of web parts and added them to our site. We used SQL Server Reporting services 2005 as our reporting solution. The reports are hosted on the report center and when we need a report, we open it by sending a URL requesting the report, passing the report parameters in the URL query string. So the report is filtered based on the parameters passed from the web parts.

But since best practices say that you should host reports directly under SharePoint, by configuring the reporting services to run in the SharePoint integrated mode. We followed the steps and installed SharePointRS and we finally succeeded to publish the reports to a SharePoint folder, but we had a limitation: we are unable to pass the report parameters internally to the report hosted in SharePoint. If we passed them in the query string as the report center case, SharePoint neglects them totally.
So the question is: how can I pass parameters internally between a SharePoint web part and a SQL server 2005 reporting services report hosted in SharePoint?

View 1 Replies View Related

Reporting Services :: Passing Cascaded Parameters From Main Report To Drill Through Report In SSRS?

Sep 16, 2015

I am trying to develop a report from cube,and it has one drill through report.when i click on sales amount field on main report,then it open the drill through report with details.Here i passed the **(category,subcat,product)parameters(Cascaded)** to drill through report in action part of main report.In my main report i have two columns .

columns are **Level** and **Salesamount**.

Values are like

**[-]category** **100**
**[-]subcat** **50**
**product** **30**

when i click on 100, parameters are passed & it open the detail report correctly, but when i click on 50,the values for subcat parameter is not getting values in detail report and same as the product also.

Here i used the expressions in parameter values

**pCategory**----iif(inscope(category),!fields.category.value,split(join(Parameters!category.value,","),","))

**psubcat**----iif(inscope(subcat),!fields.subcat.value,split(join(Parameters!subcat.value,","),","))

**pproduct**----iif(inscope(product),!fields.product.value,split(join(Parameters!product.value,","),","))

View 3 Replies View Related

Reporting Services :: Way To Subscribe SSRS Report Using Dynamic Parameters For Email And Trigger Report

Feb 8, 2015

Is there a way to subscribe SSRS report using dynamic parameters for email and trigger the report from autosys job so that report should generate the exact time the job is triggered.Let me describe, my SSRS report should be triggered on success of one autosys job. i need to send email parameter and time of report schedule from this autosys job.

View 3 Replies View Related

How To Pass Parameters From Report Viewer To Report Server

Mar 28, 2008

Hi,

I am having hard time in sending parameters to the report server through reportviewer control from my application. Could anybody help me on this issue?. Is there any way to send the parameters and also what kind of configuration do i need on my report project so that it can accept parameters from my application.

Thanks,

View 9 Replies View Related

Parameters Filtering In Report Server Project Report.

Oct 22, 2007

Dear All,

Is it possible to poplulate some control like Dropdownlist (for example, with Product names Or Product Ids) from database table in SSRS project type and then filter report by choosing various choice pre-populated in dropdownlist control.

Project Type is : SQL Server Reportings 2005.

Desired Action: Report will run in browser, User will choose specific product and Run the report(filter) to show that product relate results.

any help,

Thanks,

View 4 Replies View Related

Customise Report Parameters In Report Manager

Feb 7, 2007

Is it possible to add custom controls in for parameters in report manager??

I have a parameter that requires the user to click a button and select a bunch of things in another form. How can i do this in reporting services??

I also would like to change the layout of the parameters toolbar, ie. make text boxes smaller widths, show/hide parameters based on other parameter values.

I know i could write my own web page that does this and hide the parameters toolbar when they run the report, but this would mean that we lose other functionality that report manager has, eg. scheduling.

Does anyone know if customising the report manager will become available in a later version??

View 1 Replies View Related

Report Parameters And Jump To Report

Jan 15, 2007

Greetings,

I have two reports, Report A and Report B.

Report A has two parameters defined as "Prompted", meaning the report input area is available for the user.

Report A parameters ---> StartDate, EndDate

When Report B invokes Report A using the Jump To Report Functionality and passing Report B's StartDate and EndDate parameters, Report A seems to think the parameters are implied and not needed and fails to drop down the parameter input area.

This is not desired because the user should be able to change report A's parameters.

Anyone know a workaround?

View 1 Replies View Related

Drillthrough

Mar 27, 2007

I am a confused newbie, grateful for some help. I need to select 10 rows from total profit of married people. How would I do that?

DRILLTHROUGH MAXROWS 10 SELECT
{[Measures].[Total Profit]} on 0, [customer].[Name]ON 1 ON columns
FROM from [Electronics] WHERE [Demo].[civilstatus-salary].[civilstatus].&[married]}
RETURN [Measures].[Total profit](as rows)

View 2 Replies View Related

Drillthrough (beginner)

Jan 5, 2007

I have created two reports. One links to the other with a drillthrough. The linking works fine, but no values show up in the fields besides the group titles and column titles. Why is this happening?

The user is given a list of Counties with values. The Counties(in a matrix) are clickable for a drillthrough of Ages and Genders in the Counties. Looks something like this:

Years

Counties Total Crashes Fatalities

Cook 85 98

Manchester 2850 258

Sagamon 987 526

So when a user clicks a county, such as "Cook", this is displayed

Years

Age Gender Total Crashes Fatalities

0-8 Female 25 8

Male 55 15

9-15 Female 850 258

Male 185 35

16-22 Female 87 526

Male 10 35

But I am getting this in :

Years

Age Gender Total Crashes Fatalities

0-8 Female

Male

9-15 Female

Male

16-22 Female

Male

Whats going on? Can anyone make any suggestions? Just to let you know its based off of an Analysis Services Cube and not relational tables.

View 2 Replies View Related

Can You Have A Drillthrough If Your Using An AS Cube

Jan 11, 2007

Trying to drillthrough one report to another. But im not getting the correct values. I dont know why its not working. I created the parameters and linked them in the properties of the clickable field. What am i missing? or is it more complex in a cube to drillthrough then relational tables?

View 3 Replies View Related

Report Parameters

Oct 15, 2007

hi there

I am using Reporting Services 2005.

I have 3 report parameters: startdate, enddate, callstatus

My problem is that once I added callstatus to the parameter list my dates were ignored?

What do I need to do to correct it?

My select code is as below:

SELECT Ticket.TicketNumber, Application.ApplicationName, Status.StatusName, Ticket.LastModifiedBy, CONVERT(datetime, Ticket.CreatedDate),
Company.CompanyName
FROM Ticket INNER JOIN
Application ON Ticket.ApplicationID = Application.ApplicationID INNER JOIN
Status ON Ticket.StatusID = Status.StatusID INNER JOIN
Company ON Application.CompanyID = Company.CompanyID
WHERE (CONVERT(datetime, Ticket.CreatedDate) >= @StartDate) AND (CONVERT(datetime, Ticket.CreatedDate) <= @EndDate) AND
(Status.StatusName IN (@CallStatus)) OR
('SELECT ALL' IN (@CallStatus))

My report Parameters have the values listed in the Non-queried part on report parameters

thanks
Dianne

View 3 Replies View Related

Report Parameters BUG!

Sep 19, 2007

Why is it that EVERY TIME you make any change at all to a data set or parameter, RS automatically changes your parameters from single value to Multi-value????

This is VERY annoying.

View 3 Replies View Related

Report Parameters

Jun 7, 2007

Is there a way to force report designer overlook parameter dependencies, so that a report could be displayed by either of the two parameters although one parameter accepts but not requires the other?

For Example:

In my report I have two parameters, DeptID and ProjectID. The two drop downs display Departments and Projects respectively but only if the department is selected, the Projects list becomes active as its expecting a DepartmentID in the stored proc but accepts a null value as well. So, what I would like to achieve is display ALL projects in the Projects list, even if no department is selected. Any ideas how to do that?

Thanks.

View 2 Replies View Related

MDX Report Parameters

Jan 15, 2008

Hello,

I have an mdx report that uses 7 parameters.
How do I stop the parameters from being dependent on one another and cascading?
When a user changes a parameter value, the flashing and repopulating of the other parameter boxes takes longer than the actual report to run.

I've tried removing the dependencies from the parameter dataset mdx code as well as edititng the parameter datasets and removing the dependencies.

Is cascading parameter relationships a default by design?

Any insight would be appreciated.

Thank you.

View 5 Replies View Related

How To Set The Following Report Parameters?

Aug 8, 2007

Hi,
I have a report and the parameters Passed to the report are Cusip and PeriodId through a stored Procedure.

i want to populate the cusip Parameters using a dataset thats got by a sproc called usp_getCusips.

and the PerioId using a dataset thats been got by another sproc called usp_Getperiods...

So in my report i have added 3 datasets one for the main report, one to get the values of the PeriodId and other to get the value of the cusip.

So in my Report parameters for the Parameter Cusip and i have checked the Available value option and selected its corresponding Dataset and value .

and i have also done the same thing for the PeriodId.. But when i run my sproc i am getting this Error.

[rsInvalidReportParameterDependency] The report parameter ��Cusip�� has a DefaultValue or a ValidValue that depends on the report parameter ��Cusip�?. Forward dependencies are not valid.

[rsInvalidReportParameterDependency] The report parameter ��PeriodId�� has a DefaultValue or a ValidValue that depends on the report parameter ��PeriodId�?. Forward dependencies are not valid.

Any Help will be appreciated.

Regards,
Karen

View 7 Replies View Related

Report Parameters

Feb 21, 2008

I've had a report working that uses a parameter that allows null values. So, of course, I have the "Allow Null Values" flag checked on the parameters dialog for the respective parameter. But recently I changed the "Available values" option for the parameter to "From Query" but then I lose the ability to allow a null value! Why is this happening? Why are they mutually exclusive?

View 1 Replies View Related

Permission Error On Drillthrough

Jun 27, 2007

I've published a matrix type report through report builder to my report server, based on the model I created. When I click the subtotals to drillthrough, I receive the following error:

"The permissions granted to user 'Domainuserid' are insufficient for performing this operation. (rsAccessDenied)"

If I explicitly specify another report to tie to the drillthrough property on the entity via the model property page in SSMS, the drillthrough stuff works fine. But if I just rely on Reporting services to auto generate ( see "Autogenerated" here ) the clickthrough report I get the error above. Can anyone help?

View 1 Replies View Related

How Can I Drillthrough To Reports In Another Project

May 2, 2007

I'm trying to use the drill-through feature to link to a report in the same solution, on the same server, but in a different project. Local help files say:

"The list of report names includes all reports in the current report server project. If the drillthrough report is on the report server but is not in the project, type the name of the report. The report name can contain a relative or absolute path to the report."

Can someone give an example of a relative or absolute path? Nothing I've tried has worked.

Thanks,

JL

View 5 Replies View Related

One Or More Parameters Required To Run The Report

May 12, 2008

I am doing report development against cube. I have a main report and a sub report in the main report. I am collecting the parameters in the main report and passing into sub report which has the same exact parameters. (I am assigning parameters to the sub report from the Fields collection. If I assign from the Parameter collection, it works fine, but I need to do based on Fields collection because I have my grouping like that)

I am getting the error above, what could I be doing wrong?

View 1 Replies View Related

Report Server Parameters

Nov 16, 2007

Hi all,

I'm writing a web interface and calling reports from report server. I first used the ReportViewer control. But it seemed to be impressively faster to directly call the report URL and link that directly in a frame.

This all works fine. But I want to dynamically add the parameter values that are used by the report in my URL string. To find out those, I have written a stored procedure:

CREATE PROCEDURE dbo.spIIMGetReportParameters
@sReportname varchar(255)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @xmlParameter xml
SELECT @xmlParameter =
(SELECT Parameter
FROM [catalog]
WHERE [Name] = @sReportname)
SELECT parameter.Name.value('.','nvarchar(50)') AS ParameterName
FROM @xmlParameter.nodes('/Parameters/Parameter/Name') as parameter(Name)
END

Then I loop through the result and add parameters to the Url string.
But sometimes I get parameters that are not needed.

Is there another way to find at runtime which parameters a report expects?

Thanks,
Jan

View 1 Replies View Related

SSRS Report Parameters

Aug 8, 2007

Hi,

I have kept two Report Parameters "StartDate" and "EndDate" and i have selected From Query and viewed the preview. I got the reults but when i am selecting the two dates it is not validating the condition.

I need the results between StartDate and EndDate. For this i have to set any where in the parameters or is there any other way

can you please help me in this

Thanks
Dinesh

View 15 Replies View Related

Linking The 2 Report Parameters

May 27, 2008

Hi,

How to link two report parameters of 2 different dimension in ssrs report,means how to write dataset mdx for that?

View 2 Replies View Related