I am stuck with one reporting issue and need your help on that.
The source of the report is SSAS Cube.
I have 3 parameters
View Complete Post
I have a main report that has two parameters (RptMonth, Reports). RptMonth which the user selects from a calendar, and Reports which is a dropdown list. Produces main report correctly.
I want to goto a second report (Detail) based on clicking a textbox named KPI. I configured the textbox to Go To Report, added this parameter named ID value [ID] that is in the dataset of the query. Parameter settings - Name=ID, datatype=Integer, parameter
Get values from query=Dataset1, value field=ID, label field=KPI. Using always refresh. This is all configured in the main report. In the detail report I have one parameter named ID, type Integer, visibility=hidden.
Security for both reports use embedded connection, type SQL server. When I run the main report and click on the KPI textbox it passes the ID and I get the correct detail report. When I deploy it to the server I get
I'm running SSRS 2008, and I'm wondering if it is possible to change a report parameter property based on user input in another report parameter. What I need to do is to make report parameter #2 a required parameter if a specific value is selected
in parameter #1. Parameter #2 should be optional under all other scenario.
Thanks in advance.
I have created a report model in 2008 R2. Now, when I am trying to create a report from the report model, I having trouble in sorting the parameter value in multiselect dropdown list.
I have tried setting Attribute Property Sort Direction as Descending , but it always comes up as Ascending.
Any suggestion would be highly appreciated.
How can we sort the parameter list in report created using report model in ssrs 2008 r2? Do I need to change some property in Model or elsewhere?
I have a project develop with Visual Studio 2003, when i convert the project to Visual Studio 2005 is work well. But when i convert to Visual Studio 2008, the crystal report when have pass parameter will prompt the parameter field to re-type then show the report.
But in this converted project i create a new report and pass the parameter is ok. That means i wan re-do all report @.@??
Does someone can help me solve this problem??
I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend. Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint. The upgrade went fine, no errors that i could
find. The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.
I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application
however when i do click the new report builder report it kicks me over to
http://company.com/ReportServer_MossEnt which itemizes out each individual sharepoint site in the farm.
Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work? did i install the wrong version of the report builder add in? The above is the only problem i am having now.
all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu