Databases
StackOverflow2013
Postsdbo
POReporting Services Cscading Parameter refresh
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReporting Services Cscading Parameter refresh
    primarykey
    data
    text
    <p>I have googled it a lot and found that usually it cannot be done. I came across one of the hacks here:</p> <p><a href="http://www.bp-msbi.com/2011/04/ssrs-cascading-parameters-refresh-solved/" rel="noreferrer">http://www.bp-msbi.com/2011/04/ssrs-cascading-parameters-refresh-solved/</a></p> <p>But its not working for me in ssrs 2005. Just wondering if anyone else tried it in 2005. Or is there any other hacks that can be tried.</p> <p>As per this article the dependent parameter gets refreshed only when its values are invalidated by the selection in the first parameter. If we can invalidate the dependent parameter every time a parameter changes we will enforce a complete refresh. An easy way to do this is to attach a value such as a GUID obtained with the NEWID() T-SQL function.</p> <p>So basically we want to introduce a fake parameter in between two real parameters. This fake parameter is supposed to return new values everytime as the storedproc behind it will add a guid to the resultset everytime that proc is called. So it forces complete refresh of the other parameters.</p> <p>Now the main issue I am facing is :</p> <p>Setting the default value of this fake parameter. For the available values the storedproc behind the fake param runs and it returns data in the format say : result1,result2_GUIDFROMSQL</p> <p>Now it looks like the same storedproc is called again to set the defult value if i ask it to get the default value from query. But as the storedproc is run again new guid comes and so the old value cannot be found so its not being set as desired. </p> <p>I just need to figure out a mechanism to pass this guid from introduced param to the next param.</p> <p>Thats where I am failing.</p> <p>My issue can simply be replicated by creating a param whose datasource is this querystring. </p> <pre><code>select getdate() id, @name nid </code></pre> <p>So in this case how to set a default value for this param.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAbbi
    1. USAbbi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POReporting Services Cscading Parameter refresh
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POReporting Services Cscading Parameter refresh
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POReporting Services Cscading Parameter refresh
      1. USIan Preston
      1. VTFavorite
    1. COCould you elaborate a bit more on the exact problem you're trying to solve, and perhaps also quote the relevant bits from your link so that if the link dies this question will still make sense on its own?
      singulars
      1. POReporting Services Cscading Parameter refresh
      1. USJeroen
    2. COThanks Jeroen for looking at it. I have a edited the question based on your comments. Hope its clearer now.
      singulars
      1. POReporting Services Cscading Parameter refresh
      1. USAbbi
    3. COThanks for the update, that should help. I must admit the question's still a bit hard to read, and I'm not quite understanding the the issue, but maybe someone else can offer a helping hand?
      singulars
      1. POReporting Services Cscading Parameter refresh
      1. USJeroen
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload