View Complete Post
I have 4 paramters that are cascading(the last parameter depends on the one before that and that one depends on the one beofore that etc.) The are all multivalue with a select all option.
When I click 2 options in my first parameter all values in the list below that get checked. This is good. Now when I click an extra value in my first parameter in the parameter under this the new values show up but they do not get selected. Is there a way
to always select all in all parameter lists?
I have created an SSRS in BIDS 2008 with OLEDB Provider so as to access MS Access 2010 DB. My report is working fine. But the only problem is when am sending multiple parameter it raises error. I have enabled AllowMultiple Value checkbox.
ERROR : "Cannot add multi value parameter '@parametername" for DataSetName because it is not supported by the data extension".
My query is "SELECT * FROM tablename WHERE ([columnname] in (@parametername))"
Thanks in advance
I have a dataset which is getting data from oracle datasource and my Dataset query expression is
="select To_Char(Time_Stamp,'Month') as Month, Node_Name as Device,Connection,MSNAME,Monitor,Avg as Average,Max as Maximum FROM OracleDataVW where ((monitor='X' and msname in ('Y')) or (MONITOR = 'CPU Utilization' AND MSNAME = 'utilization')) and TO_Char(Time_Stamp,'Mon
YYYY') in ('"+ Join(Parameters!Parameter1.Value,",") +"')"
My parameter is multiValued parameter. The above query is working good if i select one value,however if select more than one value or all it is not giving me the data. I tried to put Ltrim and Rtrim in Join but it is giving me another syntax error.
Please help me with this
I have a Report, that I want to run ad-hoc from a Stored Procedure.
I want to render this report to PDF format, and save it to a drive.
The difference between this post and most threads I've seen is I don't want to run a stored proc within the report and send parameters to the stored proc.
I DO want to call a report FROM the stored proc, and send parameters TO the report.
How can I do this?
I am using SSRS 2005 with Enesys Add on Tool for reports.
I have used date format as "dd-MMM-yyyy" in the application and used the same in the report.
Issue : 1
I want to convert this format into a format where i can sort the date fields as and when exported to excel sheets.
Issue : 2
Some of the values are null and when exported to excel cant see the null values. I am using Format function in the conversion so that if the value is nothing, show nothing or show the value.
Need to resolve this as when the report is exported to excel i can see null values or squares in the columns when applying filters.
Issue : 3
The input paremeters are refreshed everytime i select a new value in other parameters. There is no dependency on the input parameters.
Please help me out in resolving these issues ASAP.
Need to submit these today EOD.
Thanks in Advance.
i am trying to call an SSRS report (in VS 2005) from my asp.net (web application) implemented in VS 2008 (don't ask me why, i am kind of confused by this weird arrangement too). report has been deployed to report server and it contains a multi-value parameter.
when i call report from asp.net app, i set the value for this multi-value parameter as a string and all selected values are separated by comma. i.e. i have 5 options (a, b, c, d, e), and i selected first two, the string is then "a,b".
the multi-value parameter on the report side is defined as: Multi-value selected, Allow blank selected, Avaliable values are from query (a dataset that contains a, b, c, d, e) Value field and Label field are both mapped to dataset filed (there is only one field in the dataset). the default values are from query too (same dataset). value field is mapped also.
i have two problems:
1: it looks to me that all available values are selected on the report side, regardless what i really selected and passed over (when i turn on paramters).
2: when i turn off parameters, i need to display what values being selected as a string, the join statement, join(Parameters!TeamLead.Value), gives a list of all available values for the multi-value parameter, however, i only need selected values. h
Is it possible to declare separate report parameters in SSRS 2005 as Date and Time?
I want the user to be able to enter a date and a time.
When I declare the parameters in my stored procedure as datetime, in SSRS the parameter just shows as a Date only.
I am trying to design a report that has a parameter named Time Period which, essentially, has the following available values: Last 24 hours, Last 7 days, Last Month, etc. I have two other datetime parameters named Start Date and End Date which are
going to specify the date ranges for which the report will select the data.
The Time period parameter is needed so that if the user specifies "Last Month", for example, the Start Date and End Date parameters automatically refresh to show the date ranges for the last month. More so, the user can still be able to specify a different
date range that they can pick from the calendar picker.
I have encountered several issues in trying to make this work:
I found a work around for this issue by creating an intermediate parameter and every time I change the time period option it will refresh the parameter since it has a stored procedure assigned