No announcements
Found 4100176 threads
-
1 VotesReport Parameters -- binding parameter to query
In the Report Layout view, go to Report Parameters and then set the datatype for the parameter.Answered | 3 Replies | 4488 Views | Created by tcarnahan - Tuesday, March 2, 2010 10:24 PM | Last reply by MS-User00 - Wednesday, March 3, 2010 2:25 PM
-
0 Votes
Passing the query parameter to a report
I suggest that you could use different query for report, in this report refer to these textbox controls value as the date range.Answered | 3 Replies | 1927 Views | Created by agustinizq - Thursday, January 15, 2015 6:19 PM | Last reply by Ken Sheridan - Friday, January 16, 2015 6:09 PM -
1 Votes
What is the difference between query parameters and Report Parameters
You can set the query parameter to a different report parameter,you can set it to an expression (which means that if you want you can first ...Answered | 3 Replies | 21192 Views | Created by Sanam K M N - Friday, January 18, 2013 6:39 AM | Last reply by Fanny Liu - Thursday, January 24, 2013 2:17 AM -
1 Votes
How to use Query Criteria Parameter on a Report
Just make sure you use exactly the same spelling in the ControlSource like = [Enter The Date] Van DinhAnswered | 2 Replies | 507 Views | Created by MikeBailey - Thursday, February 6, 2014 3:20 PM | Last reply by Van Dinh - Thursday, February 6, 2014 8:49 PM -
0 Votes
Using IN Operator in Query Parameter querying an Oracle dataset
I don't want to bother with a stored procedure that creates a table, as I have two other multi-value parameters I need for this ...Answered | 4 Replies | 3725 Views | Created by Laurie Hughett - Thursday, January 16, 2014 3:11 PM | Last reply by Mark Wojciechowicz - Thursday, January 16, 2014 9:59 PM -
1 Votes
Search for report having parameter "Product"
There may be other easy way of getting this information, however method which I know is querying "ExecutionLog" and "Catalog" tables of ReportServer ...Answered | 1 Replies | 753 Views | Created by Royal Thomas - Wednesday, July 31, 2013 8:35 PM | Last reply by Samiullah Niazi - Wednesday, July 31, 2013 10:16 PM -
0 Votes
Query parameter or Report parameter - which one should i use for this scenario - please help!
I am not sure you can say using report parameters and not including the query parameters in the sproc is "faster".Answered | 6 Replies | 2184 Views | Created by Manesar - Wednesday, October 30, 2013 4:40 AM | Last reply by Michelle_SSRS - Wednesday, October 30, 2013 4:15 PM -
1 Votes
Can I use Sysdate in a report subscription parameter?
I like your idea numbatau but this report was created using report builder and not BIDS, so I'm not sure how to add the non-queried ...Answered | 3 Replies | 6537 Views | Created by SQLLQS - Thursday, May 7, 2009 7:38 AM | Last reply by SQLLQS - Thursday, May 7, 2009 8:05 AM -
0 Votes
SSAS query - Using Parameters
I will give it a try and get back to you.Answered | 3 Replies | 3749 Views | Created by Benthore - Sunday, January 24, 2010 4:18 PM | Last reply by Benthore - Tuesday, January 26, 2010 1:51 AM -
0 Votes
Using Parameter value in SQL Query
I would have used Stored procedure but the database I am querying I am not permitted to create a SP on it as it is a third ...Answered | 5 Replies | 2597 Views | Created by JMcCon - Tuesday, October 23, 2012 1:18 PM | Last reply by JMcCon - Thursday, October 25, 2012 8:18 AM -
0 Votes
Want to pass one report column values to another report as a parameter SSRS
This parameter will have available values and default values from first dataset (from query - tasknumber field).Answered | 10 Replies | 8430 Views | Created by BandSr - Monday, February 11, 2013 12:24 PM | Last reply by krootz - Monday, February 11, 2013 4:50 PM -
0 Votes
Parameter query pops up, but I have no parameter whatsoever
As it turns out, I didn't have the table in the Design View when I ran the query.Answered | 4 Replies | 325 Views | Created by ryguy72 - Thursday, July 23, 2015 2:57 AM | Last reply by ryguy72 - Thursday, July 23, 2015 2:35 PM -
1 Votes
SSRS - Optional Report Parameter -ISSUES with query
Hi Rookie_ChikisTrikis, According to your description, you added a parameter @prmID to the report, you want to configure it to Allow null value, then the ...Answered | 1 Replies | 721 Views | Created by Rookie_ChikisTrikis - Friday, December 19, 2014 3:38 PM | Last reply by Wendy Fu - Monday, December 22, 2014 2:11 AM -
0 Votes
Using (Select All) for report parameter
Hi KCBA, I have check the query you have provided the issue cause by the query " AND (item.Answered | 6 Replies | 2114 Views | Created by KCBA - Tuesday, March 31, 2015 7:04 AM | Last reply by Vicky_Liu - Wednesday, April 1, 2015 3:38 AM -
0 Votes
Can a dataset query be controlled by a Report Parameter?
if you are using text query, or stored proc for that matter, you can surely control it using if statement.Answered | 2 Replies | 2927 Views | Created by TheIdesOfDecember - Thursday, March 1, 2012 12:17 PM | Last reply by TheIdesOfDecember - Friday, March 2, 2012 12:01 PM -
0 Votes
(Subscription) using report parameter as filename
Hi HappyJung, From the description, I understand that you want to create subscriptions to delivery reports with dynamic file name.Answered | 2 Replies | 6960 Views | Created by happyJung - Thursday, October 10, 2013 5:47 AM | Last reply by Heidi-Duan - Wednesday, October 16, 2013 9:48 AM -
0 Votes
Generate a report on top of Parameter based Crosstab Query
You could avoid the multiple prompt problem by using text boxes on a form as parameters.Answered | 1 Replies | 456 Views | Created by KhurramKZ - Saturday, December 19, 2015 1:17 PM | Last reply by Hans Vogelaar MVP - Saturday, December 19, 2015 2:48 PM -
0 Votes
Combobox to use as parameter for query
Hi,Can you provide more help for the Scenario: I have a CUSTOMER editable grid screen, and need to enable the user to find: Customers that were ...Answered | 5 Replies | 4686 Views | Created by wimdevriendt - Monday, December 13, 2010 7:42 PM | Last reply by tsiakk - Friday, March 11, 2011 7:02 AM -
0 Votes
OPTION OF NOT HAVING A PARAMETER RUN WHEN YOU DONT WANT IT TO?
Now you want to show all records when you run this report, as if you didn’t set any parameter in it.Answered | 7 Replies | 905 Views | Created by KittyCat101 - Wednesday, May 7, 2014 10:43 PM | Last reply by KittyCat101 - Wednesday, May 14, 2014 3:59 PM -
9 Votes
defining oracle query parameters - Report Designer (SSRS)
There seems to be dichotomy between what the Microsoft Oracle query parser and the actual Oracle query intepreter expects from a query, and, sadly, you can't please both in ...Answered | 4 Replies | 31688 Views | Created by bmcgary - Friday, September 16, 2011 7:59 PM | Last reply by AlejandroBello - Thursday, November 5, 2015 2:52 PM - Items 1 to 20 of 4100176 Next ›
No announcements
