Hi, please explain when have you chosen "Use a dataset embedded in my report" in Dataset Properties ? In current tutorial on 3:22. Thanks a lot for tutorials.
Thanks for sharing these videos. I'm using a ds to populate a drop down list and only getting the first value in the list on my report. What if you have several values in your parameter (select all has over 50 values)?
Any idea why I get the following error please? An error occurred during local report proccessing. The definition of the report is invalid. The report parameter (name) has a DefaultValue or a ValidValue that depends on the report parameter 'umlocationid'. Forward dependencies are not valid.
Hi Henri, my guess would be that you've set the Default Value of the Name parameter rather than the Available Values. Check the Parameter Properties for the name parameter first. I hope that helps!
Hi, just wondering is it possible to populate the drop down list using query from the dataset and an additional parameter apart from the dataset. If so, how can I do it? Appreciate your response. Thanks
This is an important episode. I am sure lot of customers may ask such feature. Is there any way we can include icons next to dropdown list displayed values. For example director Steven and icon of his image? I enjoyed the video. Thanks a lot
I built report without parameter which is working fine and same report when i put parameters - i'm getting unable to connect to database. underlying database is teradata. my question is this parameters only works for SQL serever ?
hi, i have a situation, i have a multi select drop down list. I would like to create a filter on multiple columns using a single dropdown list. eg :- Column A or Column B ( Search on column A value or Column B Value) how can i do it ?
Thankd for sharing these useful videos.I was successful in creating the MonthName Column but not able to get the DayName colum.I have used the expression (=WeekdayName(Fields!Day.Value) in calculated field.Although i am getting day names for only few days.Could you please help?
I'm unable to successfully preview my report with the second data-set as described in your video. It errors with a message similar to ... "When the report contains multiple datasets..." Please advise.
I have a quick question regarding the drop down list parameters: I want to put lets say site as my drop down parameter but each site has multiple customers and by following your instructions here, I am able to get the drop down site parameter but the issue that I am having is the site is redundant in my drop down list. Lets say, I have 2 sites (A, B). Site A has 3 customers and Site B has 2 customers. Now my drop down list is A,A,A,B,B. What do I need to do here to get just A, B in dropdown list
I have a dropdown list that have multiple values. When it contains values it's fine. When there is no value, it's blank, is it possible to print a message saying 'there is no result ?'
I have a report that start on page two, how do I turn that off so it starts on page one? It is probably a Page Break added somewhere, but I cannot locate a tickbox that makes it work as I want.
Hi there, I think you'll have to hunt through the properties of whichever report items are sitting at the top of page 2 of your report. You can also find page break settings in Group Properties so check the Grouping pane at the bottom of the design window as well. I hope that helps!
Okay, this was embarrising. I overlooked the tickbox for the Page Break I alreade mentioned my self. Now there are no empty page 1 and this part works fine. Thanks for input
These tutorials are really useful. In the first example I typed in all the days of the week for the parameter and used =WeekdayName(Weekday(Fields!FilmReleaseDate.Value)) for my Day field. However, when I select a day from the list at runtime I get the previous day. So, selecting Sunday gives me Saturday releases, Saturday gives Friday, and so on. What am I doing wrong?
***** Thank you so much for replying so quickly. I'd figured it was something to do with the start of the week, but your expression is what I was trying to get. It now works for me. Thanks.
gwynhwfar thank you so much for sharing the =weekdayname(weekday(Fields!FilmReleaseDate.Value)) Ive been messing with each and every item in common functions fr a couple of hours... May Allah bless you and Andrew
Hi there, we don't have a video on this but it's surprisingly simple to do! When you create a new dataset in a report, on the Dataset Properties dialog choose Stored Procedure as the dataset type and then select the procedure which defines the parameters you want to use. When you click OK, any parameters in the procedure will automatically create a corresponding report parameter. This is on my list of videos to create but it may take some time to get round to it.
I'm having trouble adding these fields to the header of my report. I need to show which (for example) Legislative District the data is for where Legislative District is one of the report parameters.
Thank you for your useful video, I want to connect dropdown list parameter with RDLC report using reportviewer in (asp.net+c#) please,I follow your video , but I do not know how to display the preview tab, can you help me please
When I try to add new dataset in same data source I get error msg 'you have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credentials type. To use the values in the connection string,you must configure the unattended report processing account for the report server ' how can I handle this
This is an important episode. I am sure lot of customers may ask such feature. Is there any way we can include icons next to dropdown list displayed values. For example director Steven and icon of his image? I enjoyed the video. Thanks a lot
enjoy watching these videos.
Happy to hear that you're enjoying the videos, thank you for watching!
Excellent tutorial. The multiple items from a dataset section saved my bacon. Thanks so much.
This is an important episode. I am sure lot of customers may ask such feature.
I enjoyed the video.
Thanks a lot
Excellent videos..........
Thank you so much for preparing and posting all these videos.......
so straight forward, and clear explanation. so helpful
Great video... very comprehensive.. you saved me atleast a day's reading.. Thanks
wonderful videos. the presenter is a super master
Please update more videos !!! you are rock!! i don't have word to say thanks
You my friend....you are amazing!!!!!!!
Subscribed!
Thank you for posting these tutorials, they are great.
Great Video.. Thanks for explaining it very deeply
Perfect ideas
Thanks from Egypt
Great Tutorial Andrew, Thanks a lot!
Hi, please explain when have you chosen "Use a dataset embedded in my report" in Dataset Properties ? In current tutorial on 3:22. Thanks a lot for tutorials.
You are amazing, sir !
Amazing!! So helpful.
Very helpful! Thanks!
Thanks for sharing these videos. I'm using a ds to populate a drop down list and only getting the first value in the list on my report. What if you have several values in your parameter (select all has over 50 values)?
Thanks man you are great!
Any idea why I get the following error please? An error occurred during local report proccessing. The definition of the report is invalid. The report parameter (name) has a DefaultValue or a ValidValue that depends on the report parameter 'umlocationid'. Forward dependencies are not valid.
Hi Henri, my guess would be that you've set the Default Value of the Name parameter rather than the Available Values. Check the Parameter Properties for the name parameter first.
I hope that helps!
After Specifying values in Parameters like Monday, Tuesday why you went to adjust Filters. Though We can select that without it.
Hi, just wondering is it possible to populate the drop down list using query from the dataset and an additional parameter apart from the dataset. If so, how can I do it?
Appreciate your response.
Thanks
Thanks. It is very helpful
This is an important episode. I am sure lot of customers may ask such feature.
Is there any way we can include icons next to dropdown list displayed values. For example director Steven and icon of his image?
I enjoyed the video.
Thanks a lot
great and loyal man to globe
I built report without parameter which is working fine and same report when i put parameters - i'm getting unable to connect to database.
underlying database is teradata. my question is this parameters only works for SQL serever ?
hi, i have a situation, i have a multi select drop down list. I would like to create a filter on multiple columns using a single dropdown list. eg :- Column A or Column B ( Search on column A value or Column B Value) how can i do it ?
Which visual studio are you using? Because my report viewer doesn't have option to filter directly...
Thankd for sharing these useful videos.I was successful in creating the MonthName Column but not able to get the DayName colum.I have used the expression (=WeekdayName(Fields!Day.Value) in calculated field.Although i am getting day names for only few days.Could you please help?
That certainly helps...
Thanks a lot
Really appreiciated
I'm unable to successfully preview my report with the second data-set as described in your video. It errors with a message similar to ... "When the report contains multiple datasets..." Please advise.
i have also the same issue
Useful! Thank you! :)
I have a quick question regarding the drop down list parameters: I want to put lets say site as my drop down parameter but each site has multiple customers and by following your instructions here, I am able to get the drop down site parameter but the issue that I am having is the site is redundant in my drop down list. Lets say, I have 2 sites (A, B). Site A has 3 customers and Site B has 2 customers. Now my drop down list is A,A,A,B,B. What do I need to do here to get just A, B in dropdown list
I have the same problem
I have a dropdown list that have multiple values. When it contains values it's fine. When there is no value, it's blank, is it possible to print a message saying 'there is no result ?'
Amazing tutorials...thank you so much.
I have a report that start on page two, how do I turn that off so it starts on page one? It is probably a Page Break added somewhere, but I cannot locate a tickbox that makes it work as I want.
Hi there, I think you'll have to hunt through the properties of whichever report items are sitting at the top of page 2 of your report. You can also find page break settings in Group Properties so check the Grouping pane at the bottom of the design window as well.
I hope that helps!
Okay, this was embarrising. I overlooked the tickbox for the Page Break I alreade mentioned my self. Now there are no empty page 1 and this part works fine. Thanks for input
@@narakdk 😀 we've all been there! Happy to hear that you found the answer!
These tutorials are really useful. In the first example I typed in all the days of the week for the parameter and used =WeekdayName(Weekday(Fields!FilmReleaseDate.Value)) for my Day field. However, when I select a day from the list at runtime I get the previous day. So, selecting Sunday gives me Saturday releases, Saturday gives Friday, and so on. What am I doing wrong?
***** Thank you so much for replying so quickly. I'd figured it was something to do with the start of the week, but your expression is what I was trying to get. It now works for me. Thanks.
gwynhwfar thank you so much for sharing the =weekdayname(weekday(Fields!FilmReleaseDate.Value)) Ive been messing with each and every item in common functions fr a couple of hours... May Allah bless you and Andrew
Good tutorial and thanks for making in available for free. Do u have a vus aviyt passing parameters from ssrs to a stored procedure?
Hi there, we don't have a video on this but it's surprisingly simple to do! When you create a new dataset in a report, on the Dataset Properties dialog choose Stored Procedure as the dataset type and then select the procedure which defines the parameters you want to use. When you click OK, any parameters in the procedure will automatically create a corresponding report parameter.
This is on my list of videos to create but it may take some time to get round to it.
@@WiseOwlTutorials u are star..thank u
Secondly Sir,where we do need to go Management studio to pull out the diagram to see the relationship
when i click on add dataset in the dataset properties it doesnt guve me the query option. theres only a general tab. im using VS2012
I'm having trouble adding these fields to the header of my report. I need to show which (for example) Legislative District the data is for where Legislative District is one of the report parameters.
Awesome! Thank you!!!
Thank you for your useful video, I want to connect dropdown list parameter with RDLC report using reportviewer in (asp.net+c#) please,I follow your video , but I do not know how to display the preview tab, can you help me please
Hi. Thanks for video. I just want to load all rows when we run it and do not choose any filter. Is it possible?
I am also facing same issue. If you have got answer plz share here
When I try to add new dataset in same data source I get error msg 'you have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credentials type. To use the values in the connection string,you must configure the unattended report processing account for the report server ' how can I handle this
Sudip, do you still have this error? I have the same today
In the dataset properties only show me the General Tab
And how to make the report show the Default value of "(Select All)" ?
You can set the default value of a multi value parameter using the same dataset that you use to populate its available values.
I hope that helps!
I cant see the desing and preview tabs im using VS 2012
how to sort Parameter items (items in parameters )in ascending order
i followed your steps but could not succeed
Good
This is an important episode. I am sure lot of customers may ask such feature.
Is there any way we can include icons next to dropdown list displayed values. For example director Steven and icon of his image?
I enjoyed the video.
Thanks a lot