Thank you for clear explanation, It helped me resolve an urgent request. I needed to run run a report where 3 were mandatory inputs and with 6 optional dropdown lists.
Thank you for another great video of this series. I think there is an easier solution to sort Genre list without adding an extra column simply by adding space before Any genre is sql statement so it looks like this N’ Any genre’ In that way it will be at the top of the list since space sorted before any character (Numbers and letter) That goes for directors list as well or any other similar list. Thank you.
Thanks Abdullah! I almost included that tip in the video - I was going to add (Any Genre) enclosed in parentheses in the list which has the same effect as preceding it with a space. In the end I decided against it as I didn't like the inconsistency! It's a good tip though and thank you for sharing it!
Thankyou for the clear explanation. Can I please know how can I add "Any" option when i use filter function in the tablix properties when I have varchar values to filter.
Thanks a lot!. In a SSRS report. The database has 1,2,3 as Good, Fair and Poor. But the parameter show during runtime as 0 - All conditions then 1,2,3. How do you create a parameter 0 as being All? Thanks
Hi Gyan Carlo. We already have a C# series! You can see the playlist here th-cam.com/play/PLNIs-AWhQzckxhclAO-4SsUWoHDxKKiFj.html It didn't prove to be very popular so we stopped adding videos on the topic after a while.
Hi! I don't quite understand what you're trying to do. Do you have a Yes/No parameter that you want to include in the Excel export? You can't export parameter functionality to Excel but you could always just use Excel features like the Autofilter instead.
@@WiseOwlTutorials yes I have parameter with yes/no that i need to apply for column as drop down and it should work after export also, I know it is not possible in report functionality, do you have any idea to do this.
@@h1permonth723 Hi! I'd just use Excel's Autofilter on the exported table. If you want to use a separate drop down control you'll need to use VBA form controls or ActiveX controls and add some VBA code to apply filters.
Hi Zarena, SSRS (SQL Server Reporting Services) Report Builder allows you to create paginated reports. You can see some simple examples here docs.microsoft.com/en-us/sql/reporting-services/report-builder/report-builder-in-sql-server-2016?view=sql-server-ver15 You can connect to an Excel data source although it's a little fiddly and isn't typically how you would use Report Builder. Normally, you'd be connecting to a SQL Server database or a SQL Server Analysis Services data model. Interestingly, there is a Power BI version of Report Builder which you can download here www.microsoft.com/en-us/download/details.aspx?id=58158 The Power BI version of Report Builder allows you to connect to a Power BI dataset which you have created or uploaded to the Power BI service. So, for example, you could create a report in Power BI Desktop using an Excel file as the source data. You can then publish this Power BI report to the Power BI service (which also publishes the dataset). In Power BI Report Builder you can connect to the published Power BI dataset in the Power BI service!
Thank you for clear explanation, It helped me resolve an urgent request. I needed to run run a report where 3 were mandatory inputs and with 6 optional dropdown lists.
Thanks Shahid, happy to hear that the video helped!
Thank you for another great video of this series. I think there is an easier solution to sort Genre list without adding an extra column simply by adding space before Any genre is sql statement so it looks like this
N’ Any genre’
In that way it will be at the top of the list since space sorted before any character (Numbers and letter)
That goes for directors list as well or any other similar list.
Thank you.
Thanks Abdullah! I almost included that tip in the video - I was going to add (Any Genre) enclosed in parentheses in the list which has the same effect as preceding it with a space. In the end I decided against it as I didn't like the inconsistency!
It's a good tip though and thank you for sharing it!
@@WiseOwlTutorials 👍🏼🌹
Thankyou for the clear explanation. Can I please know how can I add "Any" option when i use filter function in the tablix properties when I have varchar values to filter.
Thanks a lot!. In a SSRS report. The database has 1,2,3 as Good, Fair and Poor. But the parameter show during runtime as 0 - All conditions then 1,2,3. How do you create a parameter 0 as being All? Thanks
Hi Phillip! That technique is covered in the video.
It is possible to add a local filtering to drop down? when I have large data set?
Hello sir, are you planning for a csharp tutorial in the near future?
Hi Gyan Carlo. We already have a C# series! You can see the playlist here th-cam.com/play/PLNIs-AWhQzckxhclAO-4SsUWoHDxKKiFj.html
It didn't prove to be very popular so we stopped adding videos on the topic after a while.
I have a list being brought over dynamically from the DB how can i place a "Select any" value to the drop down, so I can display all items ?
Hi! That technique is covered in the video.
Is it possible to add option to select yes or no in report body after exporting as an excel
Hi! I don't quite understand what you're trying to do. Do you have a Yes/No parameter that you want to include in the Excel export? You can't export parameter functionality to Excel but you could always just use Excel features like the Autofilter instead.
@@WiseOwlTutorials yes I have parameter with yes/no that i need to apply for column as drop down and it should work after export also, I know it is not possible in report functionality, do you have any idea to do this.
@@h1permonth723 Hi! I'd just use Excel's Autofilter on the exported table.
If you want to use a separate drop down control you'll need to use VBA form controls or ActiveX controls and add some VBA code to apply filters.
Hi, what is SSRS Report Builder? Is it connecting to Excel?
Hi Zarena, SSRS (SQL Server Reporting Services) Report Builder allows you to create paginated reports. You can see some simple examples here docs.microsoft.com/en-us/sql/reporting-services/report-builder/report-builder-in-sql-server-2016?view=sql-server-ver15
You can connect to an Excel data source although it's a little fiddly and isn't typically how you would use Report Builder. Normally, you'd be connecting to a SQL Server database or a SQL Server Analysis Services data model.
Interestingly, there is a Power BI version of Report Builder which you can download here www.microsoft.com/en-us/download/details.aspx?id=58158
The Power BI version of Report Builder allows you to connect to a Power BI dataset which you have created or uploaded to the Power BI service. So, for example, you could create a report in Power BI Desktop using an Excel file as the source data. You can then publish this Power BI report to the Power BI service (which also publishes the dataset). In Power BI Report Builder you can connect to the published Power BI dataset in the Power BI service!
@@WiseOwlTutorials Thank you I downloaded both the SSRS builder and PowerBI SSRS and will venture into this new tool...... :)
@@zzzzzzzaaaaaaaaaaaaaaa2218 You're welcome, have fun!