I enjoyed watching this video and recommend others. Host seem to be an EXPERT in SSRS. Thanks for educating the community and appreciate your volunteership. Please keep posting on newr versions of SSRS. Thanks a bunch
Hey Andrew, just moved our conversation from the a different video to this one, because we were talking about this video there. :) Question regarding the drill down (DD) functionality: 1. click the section of the pie to drill down- a report opens. 2. what If this report had a pie - should i create another report for DD functionality and so and so forth. I am trying to create a hierarchy of Goal details based on user's click - 4 layers and multiple options to choose from on each layer. does it mean 4 different reports? Or how can i achieve this with minimum report creation. Thank you in advance :) Cheers!
Hi, thanks for the video but I think what you have show here is a drill through report. Linked report is different. Its created directly in report manager.
Hi WiseOwl these are the best tutorials. I learned SSRS with the help of your tutorials. But i have question please help me to solve this. I have developed SSRS report with summary report which is linked to six sub reports. i have provided eight parameters in summary report to make it user friendly. But when linked to sub reports it is working fine, but i want to provide back to summary button(link) in other sub reports.And it should be in a such a way that when i linked back to summary report from sub reports i need not to set all parameters again .(i.e Parameter selected should not change in summary report). Waiting for your reply. Thank you,
These videos are so helpful. Thanks WiseOwl! I've got a report published on Sharepoint and I'm trying to get a linked report to open on a new window. Any suggestions on how to go about that, while still having report parameters to pass through?
Question: How many reports can be nested or cascaded? I mean Report 2 is opened from Report1 Report 3 is opened from Report2 Report 4 is opened from Report3 and so on
Is there a good book on SSRS that's a more in-depth than Brian Larson's but not absurdly hard? Or should I just stick to the online tutorials? (If you had a page where you sequenced the lessons, it would be awesome!) Awesome tutorials! Unless I'm being completely daft, they're easy to follow.
What about Linking Charts that appear on the SAME report? Is this possible? So you can select an element in a graph that will populate a secondary graph. More of a dashboard view.
How would this work with totals? For example if you had a total on the end of each country on your last example, lets say we clicked on France's total. Would that show you all certificates for France? How about the other way around, If you clicked on the total of 12A, would that show you all countries with just 12 rated movies?
I watch your videos over and over again as they are very helpful. One question, do you know if it's possible to link a parameter in the main report to another parameter in the linked report? Or does the parameter in the linked report have to be linked to a field in the main report?
Great tutorial, I have set up similar reports a matrix and a raw data report and I have linked my reports. In my matrix I have a count value if I click 10 it will only show me 9 results in my linked report. Is a cache problem?
Hi Andrew, I have a question, how do you parse multiple values through a param to the sub report? For example I have a count of IDs calculated in main report and when I pass this value into sub-report, its always the first ID that gets through. I have mod the sub-r param properties to allow multiple values and changed the where clause in sub-report to include list of vals for prm, but for some reason it only passes one of the ID's across from the original ID count. Any ideas?
This is very useful. But I have a problem. Although I create a parameter in 2nd report. When I try to make an action in my main report(while adding parameter after choosing the report) an error occurs, called: An attempt was made to set a report parameter 'parameter' that is not defined in this report (rsUnknownReportParameter). Could you help me about this?
Part 17 was very good. However, no one seems to show how to setup linkage between 2 charts that reside in the same report. Do you have anything that shows this?
if I create an exploded Map Report (say of the USA, to keep it simple), can I make each state clickable and use that to open a child/filtered report (say of cities in that state)?
Hi Wise owl what do you do when the parameter value for the parent report is empty or null, and no value can be passed to the link report. How can that be handled.
I am trying to build an expression for my link to send a parameter to one of two different reports, depending on the value of that parameter. So if the value of the parameter = A, the link goes to reportA and if the parameter = B, the link opens reportB. What would be the formula for the expression? Thanks.
I am not able to download linked reports. I am getting this error message The operation you are attempting on item 'LinkedReport' is not allowed for this item type. (rsWrongItemType) Get Online Help Can some help please?
![Yeat & Quavo - 5BRAZY [Official Music Video]](http://i.ytimg.com/vi/4XxnTAwyxus/mqdefault.jpg)
I can't appreciate enough to say thank you so much for your time and effort of putting this tutorial together. Thank you!!
You're very welcome, thanks for watching and taking the time to leave a comment!
I enjoyed watching this video and recommend others.
Host seem to be an EXPERT in SSRS.
Thanks for educating the community and appreciate your volunteership.
Please keep posting on newr versions of SSRS.
Thanks a bunch
Thanks for your quick response.
FYI I am eager to watch SSRS 2016 videos and love to give you feedback.
You guys are awesome.
Thanks a bunch
These are the very best tutorials on SSRS I've seen. Thank you so much.
I guess it is kinda off topic but do anyone know a good place to watch newly released tv shows online ?
You rock. This is my favourite SSRS tutorial series. Thank you for making this!
I have found all of your tutorials to be tremendously helpful. Thanks so much!
You are the best!!!!!!!!! damn really your video are simple and its just what most of users are looking for :) thanks again
***** Its a husky :)
evisited
I enjoyed watching this video and recommend to others.
Lot of good functionalities explained step by step.
Thanks a lot
Thank, much WiseOwl!!!!!! You really super
0:49 What are linked reports
1:54 Creating report parameters
2:58 Applying filters
4:03 Assigning actions to a table
6:21 Creating Links using Charts
This is good one too. Thanks a bunch.
Thanks you so much for helping us,,,
Good Work
Thank you
Hey Andrew, just moved our conversation from the a different video to this one, because we were talking about this video there. :)
Question regarding the drill down (DD) functionality:
1. click the section of the pie to drill down- a report opens.
2. what If this report had a pie - should i create another report for DD functionality and so and so forth.
I am trying to create a hierarchy of Goal details based on user's click - 4 layers and multiple options to choose from on each layer. does it mean 4 different reports? Or how can i achieve this with minimum report creation.
Thank you in advance :)
Cheers!
Hi, thanks for the video but I think what you have show here is a drill through report. Linked report is different. Its created directly in report manager.
Hi WiseOwl these are the best tutorials. I learned SSRS with the help of your tutorials. But i have question please help me to solve this.
I have developed SSRS report with summary report which is linked to six sub reports. i have provided eight parameters in summary report to make it user friendly. But when linked to sub reports it is working fine, but i want to provide back to summary button(link) in other sub reports.And it should be in a such a way that when i linked back to summary report from sub reports i need not to set all parameters again .(i.e Parameter selected should not change in summary report). Waiting for your reply. Thank you,
These videos are so helpful. Thanks WiseOwl! I've got a report published on Sharepoint and I'm trying to get a linked report to open on a new window. Any suggestions on how to go about that, while still having report parameters to pass through?
Question: How many reports can be nested or cascaded?
I mean
Report 2 is opened from Report1
Report 3 is opened from Report2
Report 4 is opened from Report3
and so on
Is there a good book on SSRS that's a more in-depth than Brian Larson's but not absurdly hard? Or should I just stick to the online tutorials? (If you had a page where you sequenced the lessons, it would be awesome!)
Awesome tutorials! Unless I'm being completely daft, they're easy to follow.
What about Linking Charts that appear on the SAME report? Is this possible? So you can select an element in a graph that will populate a secondary graph. More of a dashboard view.
How would this work with totals? For example if you had a total on the end of each country on your last example, lets say we clicked on France's total. Would that show you all certificates for France? How about the other way around, If you clicked on the total of 12A, would that show you all countries with just 12 rated movies?
I watch your videos over and over again as they are very helpful. One question, do you know if it's possible to link a parameter in the main report to another parameter in the linked report? Or does the parameter in the linked report have to be linked to a field in the main report?
you can do ither
thank you!
Great tutorial,
I have set up similar reports a matrix and a raw data report and I have linked my reports. In my matrix I have a count value if I click 10 it will only show me 9 results in my linked report. Is a cache problem?
Hi Andrew,
I have a question, how do you parse multiple values through a param to the sub report? For example I have a count of IDs calculated in main report and when I pass this value into sub-report, its always the first ID that gets through. I have mod the sub-r param properties to allow multiple values and changed the where clause in sub-report to include list of vals for prm, but for some reason it only passes one of the ID's across from the original ID count. Any ideas?
This is very useful. But I have a problem. Although I create a parameter in 2nd report. When I try to make an action in my main report(while adding parameter after choosing the report) an error occurs, called: An attempt was made to set a report parameter 'parameter' that is not defined in this report (rsUnknownReportParameter). Could you help me about this?
Part 17 was very good. However, no one seems to show how to setup linkage between 2 charts that reside in the same report. Do you have anything that shows this?
Is there any possibility to link more than one report in Report Builder??
if I create an exploded Map Report (say of the USA, to keep it simple), can I make each state clickable and use that to open a child/filtered report (say of cities in that state)?
Hi Wise owl what do you do when the parameter value for the parent report is empty or null, and no value can be passed to the link report. How can that be handled.
I am trying to build an expression for my link to send a parameter to one of two different reports, depending on the value of that parameter. So if the value of the parameter = A, the link goes to reportA and if the parameter = B, the link opens reportB. What would be the formula for the expression? Thanks.
Nevermind, figured it out. Had a typo in my expression :).
=IIF((Fields!ItemID.Value="A"),"/My Reports/ReportA","/My Reports/ReportB")
How can we export main reports and subreports into excel , as subreports links do not work in excel .
I am not able to download linked reports. I am getting this error message The operation you are attempting on item 'LinkedReport' is not allowed for this item type. (rsWrongItemType) Get Online Help
Can some help please?
Nevermind... I thought I remembered all the stuff in this video, but apparently not. (Sharp as a marble today!)