Great tutorial, I am writing a report for my employer and needed a way to connect the parameters to the field values and return the result or a message for empty sets. This video showed me everything.
Top-notch quality content @WiseOwl. Not exactly new to SSRS therefore Report Builder and/ or SQL. Nevertheless learning a ton. You have a new subscriber. Many thanks and Merry Xmas.
Hi, thank u for this playlist, this change work results. I have a problem when use list selector, because the column is from same dataset that report. How can i solve it ?
Have you ever tried filtering data out at the tablix/page level? I'm trying to filter out a list of string values that I'd like to have those rows excluded from that page's data.
Hi! You can add a filter to an individual tablix, sure. Part 5.5 of this playlist shows adding basic filters to a tablix. I hope it helps! ua-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html&feature=shared
Hey, Your videos are quite amazing, i'm having a problem. I started to learning this and i don't really know how to do next thing, i have 2 parameters, StartDate and EndDate, What should I do if I want to know the information of a specific day? I mean, if i put the same date on StartDate and EndDate, The report isn't showing anything but there is data on that date.
Very nice tutorial although im having a hard time finding how to do the NOT like operator... I tried building some expressions and what not but always get an error :/ would appreciate your help mate
It's easier to do with query parameters but if you want to do this with report parameters, first check out video 10.4b, especially the part on creating Boolean Filter Expressions ua-cam.com/video/dZ3TLo1Yplk/v-deo.html Then set your filter expression to this: =Not(Fields!Title.Value Like Parameters!ExcludeTitleText.Value) Hope it helps!
@@WiseOwlTutorials Thank you so much... you dont know how much that means haha. Im an intern and nobody in the team uses report builder so i was on my own. Trying to figure things out on my own and your videos are literal GOD SENT... Out of curiosity where have you learned to use report builder ? One thing s for sure, I ll watch all your stuff :)
@@AhmedBelamine-d8z You're very welcome! I learnt Report Builder as part of my role at Wise Owl - delivering training courses and providing consultancy to clients.
Hi Gyan Carlo, we do have a basic series on C# although it didn't gain the popularity of the VBA series but you can see it here if you like ua-cam.com/play/PLNIs-AWhQzckxhclAO-4SsUWoHDxKKiFj.html We don't have any immediate plans for VSTO or more C# videos at the moment.
Hi I trying to use the same method but unfortunately I keep received this (as per below) error for all my report. Appreciates if anyone can assists me on this The report parameter 'QuotaRefNo' has a DefaultValue or a ValidValue that depends on the report parameter "QuotaRefNo". Forward dependencies are not valid. ---------------------------- The definition of the report '' is invalid. ---------------------------- An error occurred during local report processing.
Hi! You normally see this error when you populate the Default Values or Available Values properties of a parameter using a dataset which refers to the value of another parameter. In this case, you must arrange your parameters in the correct order. I hope it helps!
I've already seen a lot of your videos. they are really great! However, I have a problem that I did not find in the videos. I have a table and two datasets. I display content via a lookup. now I want to filter the lookup using a parameter in the table after the second dataset. it is a value about open items. is an invoice paid, i.e. €0.00 or not paid. is it possible to filter by a lookup or are there other ways? many thanks for everything!
Hi Simon! You can add a filter to your table in the Tablix Properties dialog box. For the filter expression you can use the same Lookup function you used to return the value in the table. I hope that helps!
@@WiseOwlTutorials Hi! I thank you a lot! I found another way. I wrote a new query with a left join. So I could use my regular filters and parameters. but it is very good to know that a filter also works with lookup. Thank you very much for taking the time to answer my question! Best regards
Hi! Carry on watching the playlist and you'll get to the videos on optional parameters ua-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html&feature=shared I hope it helps!
Does this cover sorting the parameter list alphabetically? I have my parameters built, but the list is out of alphabetical order... sorry if this is a dumb question.
Hi Michael, you can sort the values within a parameter in a couple of ways but I don't know of a way to sort the parameters themselves. You can reposition parameters manually but this is tedious if you have lots of them.
- Firstly, I really appreciate your efforts, your videos are amazing, they help me a lot! Thank you! - In additional to that, I'm facing a problem: I want to calculate the difference of energy consumption between 2 particular months which are specified by PARAMETER. For instance, energy consumption in March is 30kWh and that in August is 50kWh so the result would be 50-30=20kWh. (I'm using stored procedure for data set) - If you're interested in this matter, could you please give me a hint for this issue? Thank you once again!
Hi! Happy to hear the videos have helped you so far! I think the video on stored procedure parameters might help you here ua-cam.com/video/gqL9z6_S9jE/v-deo.html I hope it's useful!
Great tutorial, I am writing a report for my employer and needed a way to connect the parameters to the field values and return the result or a message for empty sets. This video showed me everything.
Happy to hear that you found it useful Carlos! Thanks for taking the time to comment and for watching!
Best learning channel in UA-cam. Well done mate 👏 keep the up good work.
Thanks for the support!
Excellent. I like it a lot. The explanation is very clear and useful
Happy to hear you found it useful, thanks for watching!
Top-notch quality content @WiseOwl. Not exactly new to SSRS therefore Report Builder and/ or SQL. Nevertheless learning a ton. You have a new subscriber. Many thanks and Merry Xmas.
Thanks Mathieu! I'm happy to hear that you're finding the videos useful. Merry Xmas to you too!
You are great at teaching
Big Thanks
Thank you, very kind!
You are a blessing
Thank you for watching!
Brilliant, thank you!
You're welcome, Robin. Thanks for watching!
Thanks for this excellent video.
You're very welcome, Vincent! Thanks for watching!
The apology for The twilight movies being in the data @28:43 had me laughing.
:D thanks Brian!
Hi, thank u for this playlist, this change work results. I have a problem when use list selector, because the column is from same dataset that report. How can i solve it ?
Hi Everson! Try video 11.1 in this playlist ua-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html
I hope it helps!
thanks bro. excellent tutorial👌
Thanks!
@@WiseOwlTutorials may i ask how to deal with complex reports in ssrs that require some pre processing in code before sending data to the report
@@Microgen86 Hi, that's quite a broad question, do you have a specific case or problem in mind?
Have you ever tried filtering data out at the tablix/page level? I'm trying to filter out a list of string values that I'd like to have those rows excluded from that page's data.
Hi! You can add a filter to an individual tablix, sure. Part 5.5 of this playlist shows adding basic filters to a tablix. I hope it helps! ua-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html&feature=shared
brilliant!
Thanks for watching!
Hey, Your videos are quite amazing, i'm having a problem. I started to learning this and i don't really know how to do next thing, i have 2 parameters, StartDate and EndDate, What should I do if I want to know the information of a specific day? I mean, if i put the same date on StartDate and EndDate, The report isn't showing anything but there is data on that date.
Very nice tutorial although im having a hard time finding how to do the NOT like operator... I tried building some expressions and what not but always get an error :/ would appreciate your help mate
It's easier to do with query parameters but if you want to do this with report parameters, first check out video 10.4b, especially the part on creating Boolean Filter Expressions ua-cam.com/video/dZ3TLo1Yplk/v-deo.html
Then set your filter expression to this:
=Not(Fields!Title.Value Like Parameters!ExcludeTitleText.Value)
Hope it helps!
@@WiseOwlTutorials Thank you so much... you dont know how much that means haha. Im an intern and nobody in the team uses report builder so i was on my own. Trying to figure things out on my own and your videos are literal GOD SENT... Out of curiosity where have you learned to use report builder ? One thing s for sure, I ll watch all your stuff :)
@@AhmedBelamine-d8z You're very welcome! I learnt Report Builder as part of my role at Wise Owl - delivering training courses and providing consultancy to clients.
Amazing
Thanks Palé!
Thank you sir, are considering creating a tutorial for c# or VSTO in the near future like the one created for VBA ?
Hi Gyan Carlo, we do have a basic series on C# although it didn't gain the popularity of the VBA series but you can see it here if you like ua-cam.com/play/PLNIs-AWhQzckxhclAO-4SsUWoHDxKKiFj.html
We don't have any immediate plans for VSTO or more C# videos at the moment.
Hi I trying to use the same method but unfortunately I keep received this (as per below) error for all my report. Appreciates if anyone can assists me on this
The report parameter 'QuotaRefNo' has a DefaultValue or a ValidValue that depends on the report parameter "QuotaRefNo". Forward dependencies are not valid.
----------------------------
The definition of the report '' is invalid.
----------------------------
An error occurred during local report processing.
Hi! You normally see this error when you populate the Default Values or Available Values properties of a parameter using a dataset which refers to the value of another parameter. In this case, you must arrange your parameters in the correct order.
I hope it helps!
How to download RDL template form server and use in report builder??
How can we pass a parameter value from main report to sub report??????
Could you please help me with this
Hi! It's an older video but video 19 in this playlist covers Subreports ua-cam.com/play/PL7A29088C98E92D5F.html
I hope it helps!
I've already seen a lot of your videos. they are really great! However, I have a problem that I did not find in the videos. I have a table and two datasets. I display content via a lookup. now I want to filter the lookup using a parameter in the table after the second dataset. it is a value about open items. is an invoice paid, i.e. €0.00 or not paid. is it possible to filter by a lookup or are there other ways? many thanks for everything!
Hi Simon! You can add a filter to your table in the Tablix Properties dialog box. For the filter expression you can use the same Lookup function you used to return the value in the table.
I hope that helps!
@@WiseOwlTutorials Hi! I thank you a lot! I found another way. I wrote a new query with a left join. So I could use my regular filters and parameters. but it is very good to know that a filter also works with lookup. Thank you very much for taking the time to answer my question! Best regards
@@simonliebig1511 Happy to hear that you found a solution Simon!
if i want to see data without select pick start date and pick end date or not providing any default value for date is it Possible ?
Hi! Carry on watching the playlist and you'll get to the videos on optional parameters ua-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html&feature=shared
I hope it helps!
Great
Thanks!
Does this cover sorting the parameter list alphabetically? I have my parameters built, but the list is out of alphabetical order... sorry if this is a dumb question.
Hi Michael, you can sort the values within a parameter in a couple of ways but I don't know of a way to sort the parameters themselves. You can reposition parameters manually but this is tedious if you have lots of them.
- Firstly, I really appreciate your efforts, your videos are amazing, they help me a lot! Thank you!
- In additional to that, I'm facing a problem:
I want to calculate the difference of energy consumption between 2 particular months which are specified by PARAMETER. For instance, energy consumption in March is 30kWh and that in August is 50kWh so the result would be 50-30=20kWh. (I'm using stored procedure for data set)
- If you're interested in this matter, could you please give me a hint for this issue? Thank you once again!
Hi! Happy to hear the videos have helped you so far! I think the video on stored procedure parameters might help you here ua-cam.com/video/gqL9z6_S9jE/v-deo.html
I hope it's useful!
@@WiseOwlTutorials oh yes, i'll see that video. Thanks for your support!
@@broadenmymind5793 I hope it have you the answer!
3:13 parameter in filter
Only 5 minutes into your video and i just realised how much time i waste on other useless captions and vids.
Thanks Imi!