"kjward" <kevon.ward@ftb.ca.gov> wrote in message
news:1163017356.112322.69560@m7g2000cwm.googlegroups.com...
> we have a number of reports which are visually identical, but draw data
> from different tables via different stored procedures. each procedure
> works fine. in order to consolidate a number of these reports, i have
> given the users a drop-down selection of the report type they want to
> see.
>
> in the query definition i have the expression:
> = "reports_dev.pkg_Reports_test.usp_Income_" & Parameters!type.Value
> where the type may be "Posting", or "Deposit", etc.
>
> each sproc's name corresponds to the above concatenated string. the
> preview runs fine, but only the data from the first time it runs
> continues to be displayed. no errors, it seems to like it alright. i
> have echoed the sproc name in a text box for verification, and it
> changes per the user's choice. but the data won't change accordingly,
> even when i click the view report button or the refresh button.
>
> is there a buffer that needs to be flushed between views, or something.
>
>
> (btw, we are running oracle 9i, which hasn't in itself caused any
> heartaches otherwise...in fact, all of these reports run perfectly if
> the sproc named is hard-coded in the query definition without the
> immediate iif statement)
>
> thanks in advance
>

"Joe" <hortoristic@gmail dot com> wrote in message
news:OVOoD43AHHA.204@TK2MSFTNGP04.phx.gbl...
> ...Or pass in a GUID that is ignored to ensure the cache won't pick it up.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
> news:esa8wu3AHHA.2140@TK2MSFTNGP02.phx.gbl...
>> You are seeing the development environment. It caches the data unless you
>> change the parameter. Using an expression like that it might not think it
>> needs to delete the cache. Look in your development directory for
>> .rdl.data file and delete it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "kjward" <kevon.ward@ftb.ca.gov> wrote in message
>> news:1163017356.112322.69560@m7g2000cwm.googlegroups.com...
>>> we have a number of reports which are visually identical, but draw data
>>> from different tables via different stored procedures. each procedure
>>> works fine. in order to consolidate a number of these reports, i have
>>> given the users a drop-down selection of the report type they want to
>>> see.
>>>
>>> in the query definition i have the expression:
>>> = "reports_dev.pkg_Reports_test.usp_Income_" & Parameters!type.Value
>>> where the type may be "Posting", or "Deposit", etc.
>>>
>>> each sproc's name corresponds to the above concatenated string. the
>>> preview runs fine, but only the data from the first time it runs
>>> continues to be displayed. no errors, it seems to like it alright. i
>>> have echoed the sproc name in a text box for verification, and it
>>> changes per the user's choice. but the data won't change accordingly,
>>> even when i click the view report button or the refresh button.
>>>
>>> is there a buffer that needs to be flushed between views, or something.
>>>
>>>
>>> (btw, we are running oracle 9i, which hasn't in itself caused any
>>> heartaches otherwise...in fact, all of these reports run perfectly if
>>> the sproc named is hard-coded in the query definition without the
>>> immediate iif statement)
>>>
>>> thanks in advance
>>>
>>
>>
>