No announcements
Found 3154465 threads
-
0 VotesHow to set specific values to parameters in SSRS.
Hi , Try these links ...Answered | 4 Replies | 4308 Views | Created by Ajit Kumar KSingh - Wednesday, August 21, 2013 5:25 PM | Last reply by SathyanarrayananS - Monday, August 26, 2013 2:05 PM
-
0 Votes
SSRS: How to achieve default value on specific conditions in SSRS parameter?
Only one problem is when you set the dafault value to second parameter then when you change values in first parameter, second ...Answered | 2 Replies | 2524 Views | Created by Julie Elizebeth Sam - Wednesday, March 25, 2015 7:25 AM | Last reply by Prasad msbitips - Wednesday, March 25, 2015 8:47 AM -
1 Votes
How to automatically pass value to SSRS Parameter
Did you set the DefaultValue for the 2nd parameter.Answered | 6 Replies | 4296 Views | Created by TY0100 - Friday, May 31, 2013 9:28 PM | Last reply by FlexV - Tuesday, August 19, 2014 2:58 AM -
0 Votes
How to set default values for a multi value parameter in SSRS
FROM STRING_SPLIT(@EmpName,','))) Also mapping the @EmpName in the dataset properties ->parameterAnswered | 4 Replies | 691 Views | Created by Rajender Kalra - Wednesday, October 24, 2018 1:54 PM | Last reply by Rajender Kalra - Tuesday, October 30, 2018 5:27 PM -
1 Votes
How to set Output Parameter and get the value in SSRS(BIDS)?
Apply a UNION ALL to your result set, with all columns NULL expect for the appended value.Answered | 6 Replies | 11252 Views | Created by Colin.Fu88 - Monday, September 21, 2015 1:20 AM | Last reply by DJAnsc - Wednesday, September 30, 2015 2:46 PM -
0 Votes
Multi Value Parameter SSRS
Go to its proeprties window Enalbe "allow multiple values", in Available value select sub dataset i.e. user and its relavent value.Answered | 2 Replies | 2085 Views | Created by Farberri - Monday, June 10, 2013 6:38 PM | Last reply by Bhushan W Juare - Tuesday, June 11, 2013 10:32 AM -
0 Votes
Default values for parameters specific to each user in SSRS Reports
Hi Aravinda, We can create a parameter to get the UserID, and then use this UserID to get the default value in the table.Answered | 2 Replies | 5782 Views | Created by Aravind 18 - Wednesday, October 24, 2012 2:07 PM | Last reply by Charlie Liao - Thursday, October 25, 2012 2:01 AM -
1 Votes
Parameter with Multi Values not working in SSRS
Hi, GarinTiger, In SQL Server Reporting Services, multi-value parameters are passed to SQL stored procedures as a comma-delimited string of the values.Answered | 3 Replies | 13403 Views | Created by GarinTiger - Tuesday, February 14, 2017 2:34 AM | Last reply by GarinTiger - Saturday, February 25, 2017 2:24 PM -
0 Votes
show selected parameter with corresponding parameter values SSRS
Go to its proeprties window Enalbe "allow multiple values", in Available value select sub dataset i.e. user and its relavent value.Answered | 3 Replies | 3208 Views | Created by Bhupesh_Rajasekaran - Wednesday, June 19, 2013 2:42 PM | Last reply by Bhushan W Juare - Monday, June 24, 2013 5:57 AM -
0 Votes
parameters values configuration ssrs
I hope this will resolve your problem =formatdatetime(cdate("2005-03-03"),dateformat.ShortDate) so you can put something like ...Answered | 1 Replies | 2889 Views | Created by mabrouko - Tuesday, May 1, 2012 6:38 PM | Last reply by Syed Qazafi Anjum - Tuesday, May 1, 2012 9:48 PM -
0 Votes
How to do selections on Multi value parameters in SSRS
Then make the parameter get value from this query.Answered | 3 Replies | 1018 Views | Created by lucki2005 - Thursday, July 14, 2016 4:37 AM | Last reply by Xi Jin - Wednesday, July 20, 2016 8:11 AM -
0 Votes
how to sort via multi value parameter in ssrs
My challenge is to get the report to sort on that specific order. for example, 4800 would render first, then 4904would render second b/c it was the 2nd value entered ...Answered | 3 Replies | 7201 Views | Created by venku popuri - Friday, March 22, 2013 9:35 PM | Last reply by latingntman - Wednesday, January 22, 2014 9:06 PM -
0 Votes
SSRS parameters default or null value
For more information, please refer to this article: The "Select ALL" parameter option [SSRS].Answered | 6 Replies | 4301 Views | Created by Adil Shahzad - Tuesday, May 12, 2015 3:48 PM | Last reply by BharathRS - Wednesday, May 13, 2015 9:24 AM -
1 Votes
ssrs parameter default date value
Choose the Default Value as "NON Queried" and add the expression for "Start Date" as =DateAdd("d",-1,Today) and for ...Answered | 3 Replies | 1428 Views | Created by jazz_dog - Monday, March 24, 2014 2:24 PM | Last reply by Jiri Neoral - Monday, March 24, 2014 2:34 PM -
0 Votes
ssrs : passing expressions as parameter values
Hi Xavier Ruben Fernando, May I know how is your issue going currently?Answered | 4 Replies | 1489 Views | Created by Xavier Ruben Fernando - Tuesday, September 12, 2017 10:49 AM | Last reply by Henry Jiang - Wednesday, September 20, 2017 6:12 AM -
1 Votes
SSRS: Need to set a default string "Select values" in the parameter selection list
Then your Final Parameter will be ; <Select ALL> <Select any ...Answered | 14 Replies | 13229 Views | Created by Julie Elizebeth Sam - Friday, July 18, 2014 10:02 AM | Last reply by Julie Elizebeth Sam - Monday, July 21, 2014 10:00 AM -
0 Votes
Multi-value parameter is not working in SSRS
I am having a problem with the multi-value parameter in SSRS 2005.Answered | 1 Replies | 14961 Views | Created by Nikole Phillips - Thursday, June 5, 2008 11:09 PM | Last reply by Stan Kitsis - MSFT - Friday, June 6, 2008 12:25 AM -
0 Votes
Group Values in parameters for SSRS
or as a filter/parameter?Answered | 4 Replies | 8573 Views | Created by USU_ROY - Wednesday, December 15, 2010 2:11 AM | Last reply by gk1393 - Wednesday, December 15, 2010 10:53 PM -
0 Votes
How to set calendar for month and year in SSRS parameter
Another workaround is to create common parameter rather than date picker.Answered | 5 Replies | 9086 Views | Created by BikashBiswal - Monday, December 12, 2016 8:53 AM | Last reply by BikashBiswal - Tuesday, January 31, 2017 1:59 PM -
0 Votes
Help with multi-value parameter in SSRS
,sheet Parameters And write there: Name=@Datastores Value =join(Parameters!Answered | 11 Replies | 19121 Views | Created by Blairag1 - Friday, October 24, 2008 4:18 PM | Last reply by Artem from Zambia - Wednesday, November 25, 2009 9:51 AM - Items 1 to 20 of 3154465 Next ›
No announcements
