Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limiting query parameter to first n chars of report parameter

Status
Not open for further replies.
alexjones

alexjones

Programmer
Jul 27, 2001
132
US
I have a multi-select report parameter which, if "Select All" is chosen, could exceed 8000 characters in length. This report parameter is also a query parameter for one of my datasets (appearing as =Parameters!MyList.Value on the dataset dialog Parameters tab). I have not been able to define an expression based on Parameters!MyList.Value that I could use as the query parameter.

Any suggestions would be greatly appreciated.
 
Status
Not open for further replies.

Similar threads

how2trainyourdragon
  • Locked
  • Question
SSRS export report as JSON
Replies
1
Views
795
PeterDimitrov
PeterDimitrov
Ashajohn2021
  • Locked
  • Question
Report to give Average # of cases > than 6, 7, 8 days
Replies
0
Views
632
Ashajohn2021
Ashajohn2021
Theresajn
  • Locked
  • Question
Collapse all Datasets in Report Data Pane
Replies
0
Views
663
Theresajn
Theresajn
dbsql
  • Locked
  • Question
SSRS2019 not able to connect Oracle19
Replies
0
Views
658
dbsql
dbsql
Spunny
  • Locked
  • Question
SSRS Shared Dataset - send parameter values from actual report not working
Replies
0
Views
666
Spunny
Spunny

Part and Inventory Search

Sponsor

Back
Top