SSRS Report Builder Part 12.1 - Drill Through Reports using Tables

[@aperxmim]

Bravo Mr. Wise Owl, I have gone through so far 60+ videos in this training and other playlists, and your teachings cover basically every task that a user would perform at work. Also, the workarounds and troubleshooting that I have never used or seen anywhere.

[@WiseOwlTutorials]

Ah thank you so much! You must be as bored of creating a connection to the Movies database as I am by now 😀 I'm really happy to hear that you've found the Report Builder videos useful! We have some more on the way over the next couple of weeks covering things like Indicators, Gauges and Databars. I hope that you enjoy those ones as well!

[@lancy1212]

I can't believe no one commented on this yet but I definitely laughed out loud when I saw that the Twilight films were under your "Awful" genre. Great video as always :)

[@WiseOwlTutorials]

:D Thanks!

[@RohithKK-uh7pp]

Sir very nice explaining and very informative. Thank you.

[@WiseOwlTutorials]

Thank you so much Rohith!

[@sheetalbhasin9233]

Just excellent. Thank you very much for all your efforts. I have a request if you can create tutorial on creating tabs containing parent and child reports. If we have multiple reports how can we place them in different tabs and manage the same efficiently, thanks

[@WiseOwlTutorials]

Thank you! We will have a video on subreports (where one report is nested inside another). I don't know of any native features in SSRS to create tabs within a report although I can think of a way to simulate it using actions and parameters. Perhaps we'll have a video on that at some point in the future!

[@vishal_parajuli]

How do you create that table folder, actually I am in the ODBS sys DSN connection were I cant able to see database overview etc on the query builder

[@bttucks]

Great videos,i have learn alot from these , i am hoping some one can help ,my report drill through was working great then it stopped working and have an error saying cannot be found(rstemnotfound) any ideas? Thanks

[@WiseOwlTutorials]

Hi! You might find some of the suggestions here useful www.codeproject.com/Questions/674919/The-item-Report-cannot-be-found-rsItemNotFound I hope it helps!

[@lumsihelgah9370]

How do I know the tables that were used on a report and replicate the same report on another database? On datasets, I can see the tables, but when I go to sql environment I don't see the matching tables. How do I figure out these tables?

[@rontinnin]

Back to Parent button missing -- When I run the code in Visual Studio the back to parent button is visible. When the report is deployed and we run it the back to parent button is not there, we are running VS2017. Do you have a work around or a way for me to enable the back to parent button?

[@WiseOwlTutorials]

Hi Ron! I haven't encountered this issue but perhaps this will help? www.sqlservercentral.com/forums/topic/ssrs-2008-r2-jump-back-to-parent-button-missing

[@edwindcdgm9501]

Do you have a tutorial about Reporting Services instalation?

[@WiseOwlTutorials]

Hi Edwin, yes we do! You can search for videos on the channel from the homepage, look for the magnifying glass icon below the Join and Subscribe buttons underneath the main channel banner kzbin.infosearch?query=install%20ssrs

[@edwindcdgm9501]

@@WiseOwlTutorials Thank you very much!

[@meenam7167]

Hi, is it possible to create a custom report with different width and also with multiple rows nested in a single column?

[@WiseOwlTutorials]

HI meena! Yes, you can change the report width either by clicking and dragging the edge of the report page in design view, or by using report properties. You can create multiple rows in one column of a table in a variety of ways. You can insert multiple rows across all columns of a table and then merge cells in some columns. You can insert a Rectangle in a cell and then add multiple Textboxes into the rectangle. You can even insert a Table inside a cell in another table.

[@venkateshthammisetty7845]

Hi Sir,currently not showing "Go to report" option under Action tab of Power BI Report bulider, do i need to select anything to show there that particular option or is it missing from Microsoft?

[@WiseOwlTutorials]

Hi! This video is using SQL Server Report Builder. Power BI Report Builder is very similar but does not currently have the "Go to report" option. I hope it helps!

[@Mrandyol]

@@WiseOwlTutorials Sort of helps? Can we create a relative link by writing an expression, or publish to OneDrive and use a url? My issue is in Windows Explorer, I can't even find the SQL2016Training folder. Is it hidden?