Thanks for your excellent SSRS tutorials. I am new to this at work and I am using it step by step and able to deliver the reports that staff are requesting no problem ! Most other tutorials go over my head, tend to assume I know more than I do, this is quite comprehensive and clear. Thank you !
+WiseOwlTutorials . You have given advice to use subtitle in one tutorial. I think it's better not to use that. By the way, there is no tutorial better than this playlist for SSRS.
Interesting episode. Parameter can be created from Parameters and DataSet but which would be good. If you could elaborate pros and cons on these to would may make sense. It's a suggestion. I enjoyed the video. Thanks, Kris
This video is great. Who would think that I would have to watch it again all these years later. My question is suppose you wanted the 2 date parameters to go gray when deselecting the Null (FilmRunTime parameter). How would you do that?
Question...is there a way to display/hide parameters based on the selection of the "main" parameter? For example, I would like the user to select whether to run the report based on a fiscal year or a date range. If fiscal year is selected, then the parameter to enter a fiscal year would be displayed. If date range is selected, then the start date and end date parameters would be displayed (and the fiscal year parameter hidden).
How to add query parameter when the data source is data bricks connected as ODBC in report builder, adding query parameter as “?” doesn’t work in sub query
Hi there, very newbie here... trying to do that date range parameter in VS2010 using Access DB 2007 but can't figure that out. Any suggestion will be of great help. I love your tutorials as it is intended for newbie like me that it's showing the step-by-step process.
***** I did not watch from part 1 that's why i didn't know that you're using SQL 2012. I am just opening directly the VS 2010 and the database i use is access 2007 maybe that's the reason why it's not working the way as it works on your tutorial.
I have been practicing as I go through these videos, which I think are great btw. I have run into a problem trying to use a date parameter on my report which is based off a database I had created. The problem is because I created my dates as strings rather than date/time objects. So when I first tried to run the filter, I got an error telling me it couldn't compare the 2 types. So I went back into the filter and changed the filter expression to a function expression where I converted the date string using the date conversion (=CDate(Fields!Date.Value)), and changed the data type in the drop down box to date/time. Now when I try to preview the report, it only says that it "Failed to evaluate the FilterExpression of the DataSet". I tried doing it as text only for "proof of concept" if you will, which "worked" but did not give correct results. Do you know how I could fix this (outside of changing my database)?
Does the movie database is copyrighted to WISEOWL Only? Can i use it for hosting it in Azure for my Showcase (not for business but for my job interviews). I just need to confirm this before hosting it for my personal showcase purpose. Thanks for your videos and am going to do this for my job hunt. Thanks for all your support WISEOWL. Cheers, Chandra.
Hi, Excellent tutorials for SSRS. Im really enjoying them. I have a problem I hope you can help me with? running a report with date parameters within Visual Studio runs lovely. however if I deploy the report, then attempt to run the report from the Reports URL, so in effect like a user would do so, I get a nasty error:An error occurred during reportprocessing. An attempt was made to set data set parameters '@startdate' that is not defined in this data set. (rsUnknownDataSetParameter)Can you help?
+WiseOwlTutorials thanks for your reply. Do you think it could be a security permission problem for example the location of the shared dataset users do not have access to? or does the report with parameters have to have an embedded dataset rather than a shared for report manager to run and pass through the parameters?
I know this is an older post, but did you check to make sure you used the same case when referencing your parameter in your dataset as it is setup with? I see in your error it is listed as @startdate. If your parameter's Name is StartDate instead of startdate, it can blow things up!
Hi, Got a custom code question for you. I am not sure how to write the custom code for this scenario.Sorry I gave a poor example of explaining the problem last time. Should have gone like this Example: depending on item code + Product = may have two different results. 24 (Item code) + 185 (product code ) = seadoo or 15 (item code) + 185 (product code )= Quad Cheers
Hi while practicing for docking and undocking the Solution 'MoviesProject'. I only see the below like MoviesProject and folders under. The top is gone. How can i bring it back. what did i do.
How can we count something, for example we have list of Cities and suburbs and we want to count the number of people who live in a particular suburb of a city.
how to display a box with null option, where we can check and check that null box. in report lik this invoice -------- drop down list then null () to check or uncheck. I have screen shot but its not accepting here.
Hi, Got a SSRS question for you. I am trying to figure out how to write in the wildcard , so when the user types in certain key points of a description field it filters down even more. description example → BALL SF7 3.438 .I wrote it : ="*"&Parameter!Desc.Value & "*", this works when you type in any one of those key point, but I want it to filter down even more when they type, ball, then SF whatever then say any size. Do you know how I could accomplish this ? I am fairly new to ssrs. Thanks in advance
***** Thank-you so much, I will try that out. Your video's have helped me learn SSRS and I am truly grateful for people like you in the world. I agree with you they have to much info in one field, it should be broken down into many fields. Just for curiosity, Is there anyway I could manipulate SSRS to create my own new fields based off a single field like the "Description" ? like a vlookup in excel.
Hi, Got a custom code question for you. I am not sure how to write the custom code for this scenario. I have to return a single result based on criteria that are in two separate columns. Example : all item code "2" = "dog" and all Product Code "3" = "Black'' = "Dog-Black" all item code "3" = "cat" and all Product Code "3" = "Black'' = "Cat-Black" *the result is dependent on the two codes. Item code Product code have custom code translate to 2 3 = Dog-Black 2 4 = Dog-White 2 5 = Dog-Green 2 6 = Dog-Purple 3 3 = Cat-Black 3 4 = Cat-White 3 5 = Cat-Green 3 6 = Cat-Purple I have written a custom code that look like this: very simple Function GetItemCode(Value AS String) AS String IF Value = "2" Then Return "Dog" IF Value = "3" Then Return "Cat" Return "Unknown" End Function I just don't know how to write to make it look at the two things and return a single result.Do you know how I could achieve this ? Thanks in advance
eleanor hwit Sorry I gave a poor example of explaining the problem.Should have gone like this Example: depending on item code + Product = may have two different results.24 Item code + 185 (product code ) = seadoo or 15 (item code) + 185 (product code )= Quad Cheers
Sir I must say I am very very grateful for your detailed explanation. I literally had a presentation on hold till i found your video. Thanks a bunch
Happy to hear that it helped, good luck with the presentation and thanks for watching!
I really appreciate taking your time to show me how to create parameters using Reporting Services
these are really helpful. just started a job where they use ssrs primarily, my background is with sap WEBI, so these vids are like GOLD for me.
Happy to hear that you're finding these useful, thank you for watching!
Thanks for your excellent SSRS tutorials. I am new to this at work and I am using it step by step and able to deliver the reports that staff are requesting no problem ! Most other tutorials go over my head, tend to assume I know more than I do, this is quite comprehensive and clear. Thank you !
I've recommended you to a friend who is also learning SSRS. You're videos are so useful!
Very good job Andrew . I had no idea about Reporting Services before at all and your tutorials were more than perfect to get me started . Thanks
you have such fantastically explained concepts. Thank you very much for such wonderful presentation!
Thank you, Nayeem!
Thank you WiseOwl for showing me how to write a wildcard on filtering parameters! XOXO
Again, thank you very much, this are really for far the best video tutorials on the web!
I cannot believe I have wasted so much time! The video was extremely helpful.
Best tutorial on youtube.
Ah, thanks Manasa! Happy to hear that you enjoyed it and thanks for the comment!
Your tutorials are excellent. Most helpful. Thank you!
Thank you for the video(s), you do a great job in explaining!
You are really awesome! Thank you a lot!
Thank you Dawit!
Very wisely Thank you very much
You're very welcome, thank you for the comment!
Great. Short to the point. Simple and easy to understand. But your subtitle drives me crazy and blows me up.
However, Thanks alot
+WiseOwlTutorials . You have given advice to use subtitle in one tutorial. I think it's better not to use that. By the way, there is no tutorial better than this playlist for SSRS.
This is useful. I am subscribing. Thanks for uploading.
Thanks, you saved my work day! :)
Very good, thanks for your help!
Great stuff man
Interesting episode.
Parameter can be created from Parameters and DataSet but which would be good. If you could elaborate pros and cons on these to would may make sense. It's a suggestion.
I enjoyed the video.
Thanks,
Kris
Thank you!! great tutorial
Great tutorial, thank you for posting it.
Helpful video. Thanks
This video is great. Who would think that I would have to watch it again all these years later. My question is suppose you wanted the 2 date parameters to go gray when deselecting the Null (FilmRunTime parameter). How would you do that?
Thank you for the reply. My creativity has been sparked. Great videos.
Question...is there a way to display/hide parameters based on the selection of the "main" parameter? For example, I would like the user to select whether to run the report based on a fiscal year or a date range. If fiscal year is selected, then the parameter to enter a fiscal year would be displayed. If date range is selected, then the start date and end date parameters would be displayed (and the fiscal year parameter hidden).
Thank you so much for such a good tutorials.. understood very well..God bless you..can you please upload qlikView and tableau tutorials???
Good job man . please do tutorials using SQL Builder
Great
Thanks!
How to add query parameter when the data source is data bricks connected as ODBC in report builder, adding query parameter as “?” doesn’t work in sub query
Thanks Alot !!
Hi there, very newbie here... trying to do that date range parameter in VS2010 using Access DB 2007 but can't figure that out. Any suggestion will be of great help. I love your tutorials as it is intended for newbie like me that it's showing the step-by-step process.
***** I did not watch from part 1 that's why i didn't know that you're using SQL 2012. I am just opening directly the VS 2010 and the database i use is access 2007 maybe that's the reason why it's not working the way as it works on your tutorial.
I have been practicing as I go through these videos, which I think are great btw. I have run into a problem trying to use a date parameter on my report which is based off a database I had created. The problem is because I created my dates as strings rather than date/time objects. So when I first tried to run the filter, I got an error telling me it couldn't compare the 2 types. So I went back into the filter and changed the filter expression to a function expression where I converted the date string using the date conversion (=CDate(Fields!Date.Value)), and changed the data type in the drop down box to date/time. Now when I try to preview the report, it only says that it "Failed to evaluate the FilterExpression of the DataSet". I tried doing it as text only for "proof of concept" if you will, which "worked" but did not give correct results. Do you know how I could fix this (outside of changing my database)?
Does the movie database is copyrighted to WISEOWL Only? Can i use it for hosting it in Azure for my Showcase (not for business but for my job interviews). I just need to confirm this before hosting it for my personal showcase purpose. Thanks for your videos and am going to do this for my job hunt. Thanks for all your support WISEOWL.
Cheers,
Chandra.
Hi, Excellent tutorials for SSRS. Im really enjoying them. I have a problem I hope you can help me with? running a report with date parameters within Visual Studio runs lovely. however if I deploy the report, then attempt to run the report from the Reports URL, so in effect like a user would do so, I get a nasty error:An error occurred during reportprocessing. An attempt was made to set data set parameters '@startdate' that is not defined in this data set. (rsUnknownDataSetParameter)Can you help?
+WiseOwlTutorials thanks for your reply. Do you think it could be a security permission problem for example the location of the shared dataset users do not have access to? or does the report with parameters have to have an embedded dataset rather than a shared for report manager to run and pass through the parameters?
I know this is an older post, but did you check to make sure you used the same case when referencing your parameter in your dataset as it is setup with? I see in your error it is listed as @startdate. If your parameter's Name is StartDate instead of startdate, it can blow things up!
Hi,
Got a custom code question for you. I am not sure how to write the custom code for this scenario.Sorry I gave a poor example of explaining the problem last time. Should have gone like this
Example: depending on item code + Product = may have two different results.
24 (Item code) + 185 (product code ) = seadoo or
15 (item code) + 185 (product code )=
Quad Cheers
Damn!!!! You are good
Hi while practicing for docking and undocking the Solution 'MoviesProject'. I only see the below like MoviesProject and folders under. The top is gone. How can i bring it back. what did i do.
Please how to pass a session as parameter in the report please
How can we count something, for example we have list of Cities and suburbs and we want to count the number of people who live in a particular suburb of a city.
Thanks, but I hit a snag- I want to count something once- even if it occurs in the report multiple times....
Hi, How can I pass multiple values to a call report parameters
how to display a box with null option, where we can check and check that null box.
in report lik this invoice -------- drop down list then null () to check or uncheck.
I have screen shot but its not accepting here.
great video. Sank you Andy( you might not get it if you dont live in America)
Awsome......
Hi,
Got a SSRS question for you. I am trying to figure out how to write in the wildcard , so when the user types in certain key points of a description field it filters down even more. description example → BALL SF7 3.438 .I wrote it : ="*"&Parameter!Desc.Value & "*", this works when you type in any one of those key point, but I want it to filter down even more when they type, ball, then SF whatever then say any size. Do you know how I could accomplish this ? I am fairly new to ssrs. Thanks in advance
***** Thank-you so much, I will try that out. Your video's have helped me learn SSRS and I am truly grateful for people like you in the world. I agree with you they have to much info in one field, it should be broken down into many fields. Just for curiosity, Is there anyway I could manipulate SSRS to create my own new fields based off a single field like the "Description" ? like a vlookup in excel.
***** Thanks , I did try the asterisk into your search phrase in between each independent criterion and it worked. Thanks again, Eleanor( Canada )
Nice !
friend ,
U can post a video how to see the icon of calendar in a crome?
I mean the container that holds the projects is disappeared. How can i see it.
Hi,
Got a custom code question for you. I am not sure how to write the custom code for this scenario. I have to return a single result based on criteria that are in two separate columns.
Example : all item code "2" = "dog" and all Product Code "3" = "Black'' = "Dog-Black"
all item code "3" = "cat" and all Product Code "3" = "Black'' = "Cat-Black"
*the result is dependent on the two codes.
Item code Product code have custom code translate to
2 3 = Dog-Black
2 4 = Dog-White
2 5 = Dog-Green
2 6 = Dog-Purple
3 3 = Cat-Black
3 4 = Cat-White
3 5 = Cat-Green
3 6 = Cat-Purple
I have written a custom code that look like this: very simple
Function GetItemCode(Value AS String) AS String
IF Value = "2" Then Return "Dog"
IF Value = "3" Then Return "Cat"
Return "Unknown"
End Function
I just don't know how to write to make it look at the two things and return a single result.Do you know how I could achieve this ?
Thanks in advance
***** Thanks so much I will give a try .
eleanor hwit Sorry I gave a poor example of explaining the problem.Should have gone like this Example: depending on item code + Product = may have two different results.24 Item code + 185 (product code ) = seadoo or 15 (item code) + 185 (product code )= Quad Cheers
how to pass image to report from form
how to increase parameter textbox size please help me any one
what is your next video after this.