I enjoyed watching this video and recommend others. Question: When you could make the same report without Dynamic Sql then why want to struggle with Dynamic S?ql. Some times Dynamic Sql leads to SQL Injection Thanks for educating the community and appreciate your volunteership. Thanks a bunch
Sorry to be so offtopic but does someone know a way to log back into an instagram account? I was dumb forgot the password. I would appreciate any help you can offer me
@Dustin Demetrius Thanks so much for your reply. I found the site thru google and Im waiting for the hacking stuff now. Seems to take a while so I will reply here later with my results.
Hey, i always enjoy your video. They are so helpful. Thank you. But we can have multiple parameters selected in SSRS using checkbox in parameter field, right .
Thank you for your video, very helpful. However, I am running into a situation where there is comma in the middle of a single value of the parameter. and when i implement above solution, it is replacing the comma in the middle of value with (',') as well and hence, the report is not returning required dataset. How would you handle such situation, where there is comma in the middle of a single value?
works fine when the number of values passed to the parameter is small. but when I input a parameter string longer than 8,000 characters using ssrs only the first 8,000 characters are recognized the rest are ignored. is there a better way to do this that will allow me to pass more than the varchar(max) limit?
hey I tried to write the user defined function but that doesn't work when I put it in the where clause. I copied and pasted t he values that the function returns in the where clause IN statement then it works but I cant use that. I want avoid using dynamic sql if possible. please let me know else I will have to rely on dsql
Hi! your materials really helped me, but I am having problems with SP and refreshing fields. this is my case. My SP consists of multiple query. if @Report = 'report1' begin QUERY1 return end if @Report = 'report2' begin QUERY2 return end fields of QUERY1 are different from QUERY2. when I refresh the fields. QUERY1's field are always shown. what should I do?
I have an issue with oracle while creating multi value parameter in ssrs. It shows "ORA-00907: missing right parenthesis in dataset2" while i run my query of dataset2 in db it works fine though!!! please help.
@@TechBrothersIT i have blank values but when i choose the select all check box in my parameter drop down it doesnt bring back data for the blank parameter value, it only brings the data for the blank value if i only select the blank check box in the drop down parameter.
I tried with dynamic sql as you suggested it worked fine for me. Thanks
I enjoyed watching this video and recommend others.
Question:
When you could make the same report without Dynamic Sql then why want to struggle with Dynamic S?ql. Some times Dynamic Sql leads to SQL Injection
Thanks for educating the community and appreciate your volunteership.
Thanks a bunch
Sorry to be so offtopic but does someone know a way to log back into an instagram account?
I was dumb forgot the password. I would appreciate any help you can offer me
@Christopher Onyx instablaster =)
@Dustin Demetrius Thanks so much for your reply. I found the site thru google and Im waiting for the hacking stuff now.
Seems to take a while so I will reply here later with my results.
@@christopheronyx4671 Good Luck
@Dustin Demetrius It did the trick and I now got access to my account again. I am so happy!
Thanks so much you saved my ass!
Hey, i always enjoy your video. They are so helpful. Thank you.
But we can have multiple parameters selected in SSRS using checkbox in parameter field, right .
the video is awesome! just have one question, why should we use dynamic SQL here?
Thanks for your video, it was really helpful
Thank you for your video, very helpful.
However, I am running into a situation where there is comma in the middle of a single value of the parameter. and when i implement above solution, it is replacing the comma in the middle of value with (',') as well and hence, the report is not returning required dataset.
How would you handle such situation, where there is comma in the middle of a single value?
works fine when the number of values passed to the parameter is small. but when I input a parameter string longer than 8,000 characters using ssrs only the first 8,000 characters are recognized the rest are ignored. is there a better way to do this that will allow me to pass more than the varchar(max) limit?
Great Job!
Thank you!
hey I tried to write the user defined function but that doesn't work when I put it in the where clause. I copied and pasted t he values that the function returns in the where clause IN statement then it works but I cant use that. I want avoid using dynamic sql if possible. please let me know else I will have to rely on dsql
This is very nice article. Thank you.
Hi! your materials really helped me, but I am having problems with SP and refreshing fields.
this is my case. My SP consists of multiple query.
if @Report = 'report1' begin QUERY1 return end
if @Report = 'report2' begin QUERY2 return end
fields of QUERY1 are different from QUERY2.
when I refresh the fields. QUERY1's field are always shown.
what should I do?
hi, I've tried your method by using ##temp and I still don't see any fields in SSRS. Any input?
Awesome sir..
I have an issue with oracle while creating multi value parameter in ssrs. It shows "ORA-00907: missing right parenthesis in dataset2" while i run my query of dataset2 in db it works fine though!!! please help.
What if need to pass multiple integer value with scenario please help me for this.
did you get an answer i can do with it thanks.
What if with multiple parameters including integer?
That should be fine too. you can have the intergers as multi value parameters.
Use
select values from string_split( @varregion)
what about if one of your parameter values is blank?
if there is no blank value in database then it should not return any value, not sure about what is your scenario.
@@TechBrothersIT i have blank values but when i choose the select all check box in my parameter drop down it doesnt bring back data for the blank parameter value, it only brings the data for the blank value if i only select the blank check box in the drop down parameter.
How about adding a “blank” value in parameter query and in data select query. Replace balnks to “blank” value to they match.
how to pass Encrypted Multi value parameter without dynamic sql
learn ti tipe !!