SSRS Report Builder Part 11.1 - Drop Down List Parameters

[@georgerevell5643]

Your voice is so perfectly clear, you've got the perfect voice for a top techpert teacher!

[@WiseOwlTutorials]

Ah thanks so much! Happy to hear that you enjoyed it, thanks for taking the time to comment!

[@nicolasriviere4408]

Your videos are amazing! Thank you!

[@WiseOwlTutorials]

Thanks for watching, Nicolas!

[@nicolasriviere4408]

@@WiseOwlTutorials I have a some questions for you. Do you have some tutorials for settings SQL Reporting web page such as automatic printing, set standard folder and standard name of file? Thanks again

[@WiseOwlTutorials]

@@nicolasriviere4408 Hi Nicolas! Sorry no, we don't have any videos on those topics.

[@nicolasriviere4408]

@@WiseOwlTutorials thanks for your answer and thanks again for your videos. In the coming weeks, I will continue to watch your videos on Report Builder and add comments for your referencing. Have a nice week

[@WiseOwlTutorials]

@@nicolasriviere4408 Thanks Nicolas, have a nice week too!

[@keiKei001]

Hi, thank you so much for these videos, they are really helpful. 25:42 I have a question, how can I add to that droplist of (in this case) genres a check for multiple values and an option to show all values? I tried but I can't seem to find the solution. If you could help me that would be great.

[@WiseOwlTutorials]

Hi! Check out the next few videos in the playlist, Part 11.3 should help you kzbin.info/aero/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU

[@NSLABTUTORIAIS]

Muito bom!!! Very good. Congratulations!!! Thank you for the tips.

[@WiseOwlTutorials]

Happy to hear you enjoyed it, thanks for watching!

[@AnsarBasha-ew3pg]

How Dax expression work when we are using the data set from Power BI data set(excel).

[@phillipk9891]

Which videos will show of setting a parameter that allows the user to hide a column? Thanks!

[@WiseOwlTutorials]

Hi Phillip! We don't have a video on that but you can reference parameter values in any expression in SSRS, including those which control the Hidden property of report items. How exactly would you like your example to work? Are you aiming to choose the name of a field from your dataset to hide or do you have some other criteria which determines whether a column should be visible?

[@PhillipLearnTeach]

@@WiseOwlTutorials there is a column comments that can be turned off when the report runs like a parameter which has a On/Off selectable in crystal reports among other parameters

[@marcinjakubek1854]

Hi. How to create a drop down list where I can select columns? For example, instead of "Release Date" and "Oscar Wins" there is a list in which you can choose only one of them.

[@WiseOwlTutorials]

That's a little tricky but one way is to use an expression to set the value displayed in a column based on the choice made in a drop down list. You can get the idea of the technique from this video kzbin.info/www/bejne/maGThmpmi8uDfdEfeature=shared So, you could create a parameter called ColumnNameSelected with a drop down list populated with the field names you want to select. In a cell in your table you could write an expression like: =Fields(Parameters!ColumnNameSelected.Value).Value I hope it helps!

[@MonikaEliashvili]

Can we add "Search" for parameter with long list (like "Director") ?

[@WiseOwlTutorials]

Not easily! You could have a text parameter into which you enter your search string and use this to filter the dataset which populates the Director drop down list. Check out the video on Cascading Parameters in this playlist for the basic idea kzbin.info/aero/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU&feature=shared I hope it helps!

[@forgivensinner9135]

Help, How to keep this drop down list pinned? My list is hiding after changing screens, and I need to click a button to show it. I feel like I searched all the options but I missed something And i mean the raport in the browser. In preview view in the vidual studio this drop down list is pinned.

[@ericsos101]

I have a drop-down list in a parameter and all is one of them so when all is selected no data is displaying.. how can i fix it that issue

[@WiseOwlTutorials]

Hi Eric! I'd check out videos 10.4, 10.4b and 10.5 in this playlist kzbin.info/aero/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU I hope it helps!

[@hussienbadi571]

Can we post back the report when we choose an item from the drop down list??????

[@WiseOwlTutorials]

Hi there, sorry I don't know!

[@mamtagothwal]

Can you please help , I want to know how to add a parameter which will show next90days data from today date in report We have only date field in dataset with next 90 days data in it

[@WiseOwlTutorials]

Hi! You can use the DATEADD function to calculate a future date - you can do this either in the SQL query like so SELECT * FROM MyTable WHERE MyTable.DateField BETWEEN GETDATE() AND DATEADD(DD, 90, GETDATE()) Or as a filter in the dataset properties or tablix properties. Add a filter to the object using the Between operator - set the start date using the Today() function and the end date using DateAdd(DateInterval.Day, 90, Today()) I hope it helps!

[@mamtagothwal]

@@WiseOwlTutorials thankyou for the suggestion. I will try this... Can you please make a video on how we can use calculated field as parameter and also explain the scenario, if that parameter shows duplicate option, thn how to remove those. Thankyou for the solution and making such informational videos.

[@abdullahquhtani4247]

I always feel 😔 when I see video timer indicator goes to the end of your videos.

[@WiseOwlTutorials]

Don't worry Abdullah, more videos are on the way!

[@davidfullstone]

Great tutorial. One thing though nearly always the client wants what you have shown but they also want the ability to select multiple values for comparison. When you select allow multiple selections SSRS comes back stating that NULLS are not allowed for multiple selections. Been searching for ages for a work around but no joy.

[@WiseOwlTutorials]

Hi David! You might find video 11.4 in this playlist useful kzbin.info/aero/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU I hope it helps!

[@nuhzakir8896]

Do you think cover new tutorial series ? (Html,CSS etc.)

[@WiseOwlTutorials]

Hi, I think the most likely candidates for new series will be DAX, Power BI, an update to SSIS and perhaps one other. We don't have plans for Html or CSS at the moment, sorry!

[@nuhzakir8896]

@@WiseOwlTutorials No problem.Thank you.

[@kartickchakraborty9135]

Or beloved Sir, Andrew, there are lots of topics in VBA (like regular expression, User Defined Dynamic Spilled Array Functions) I want to learn from you. I've been eagerly waiting for your videos for more than 2 months. When will you start uploading videos on these topics? Please upload videos🙏🙏🙏🙏🙏❤️❤️❤️❤️

[@WiseOwlTutorials]

Hi Kartick, the Regular Expressions topic is on my list but I can't give you an estimate of when I'll be uploading videos on this topic I'm afraid. The list of videos to create is very long and the time I have to do it is very short! I think I recall providing you with some links regarding the Dynamic Spilled Array functions - I think it's unlikely that we'll have videos on this topic. I'm sorry that I can't be more helpful at the moment!

[@kartickchakraborty9135]

@@WiseOwlTutorials I understand you, but the problem is, we are habituated in learning from your videos. No one can replace you. So, no other can make us understand better than you. When you're free, please make videos on these topics. We're waiting for your videos. Take my gratitude.

[@WiseOwlTutorials]

@@kartickchakraborty9135 Thank you Kartick, you will be the first to know when those videos appear!

[@Yorumcu63]

Great video like other VBA Videos. I want learn, about protect our VBA codes.For example I was write a VBA program and I was sell to any customer .How can protect for copy for another users Because my one customer can sell to other persons . For example my algoritym .If I read installed computer's harddisk serial number (if possiable other hardware ID numbers) it give me a long codes and user send to me these and I can send replace characters and my vba code check my reply with same algoritym.(for example I can reply for last character to first characters reply) Summary How work my VBA codes work only my installed computer?

[@WiseOwlTutorials]

That's a good question and complex subject. Can I point you to a couple of discussions of the topic here: vbacompiler.com/best-way-protect-vba-code/ ratexcel.wordpress.com/2017/03/22/how-to-really-protect-your-code-making-vba-project-unviewable/#:~:text=You%20may%20think%20it's%20easy,OK%20and%20save%20your%20file. I think the easiest option is to use a third-party tool such as this vbacompiler.com/ (I haven't used this program myself so this isn't a recommendation, just a suggestion!). An alternative, and more complicated option, is to develop your app as a VSTO addin or an Office Web addin using Visual Studio docs.microsoft.com/en-us/visualstudio/vsto/create-vsto-add-ins-for-office-by-using-visual-studio?view=vs-2019 docs.microsoft.com/en-us/office/dev/add-ins/develop/develop-add-ins-visual-studio

[@AnsarBasha-ew3pg]

How Dax expression work when we are using the data source from Power BI data set(excel).