Prev: ole db connection
Next: Question about Subreport
From: greenmtnsun on 15 Jan 2010 17:52
Before I say this... I make mistakes. I get that, but in this case...

> If I had to guess I would say it is the parameter that is dependent on two
> parameters that is causing the issue.

I can't understand how it could be a circular parameter. It works fabulous
on the web. If there was anything wrong with the logic, it wouldn't work on
the web, right?

"Bruce L-C [MVP]" wrote:

> I've seen this sort of thing before in RS 2005. A little different. In my
> case the parameters would start flashing. Like you, they worked from the web
> but not from the IDE.
>
> If I had to guess I would say it is the parameter that is dependent on two
> parameters that is causing the issue.
>
> You have a work around and although a pain I don't think you should run into
> this very often.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "greenmtnsun" <greenmtnsun(a)discussions.microsoft.com> wrote in message
> news:FB1C601F-3CF5-4E9A-ACC2-1DE25BF88A73(a)microsoft.com...
> > FYI: SSRS 2008 on SQL 2008, VS 2008, BIDS 2008.
> >
> > I have a RDL that is very basic with a cascading parameter. At this
> > stage,
> > it is only parameters because the actual intense data gathering wasn't
> > programmed because of the cascading problem.
> >
> > This problem seems to be different than the other 3rd parameter problem
> > that
> > was recently fixed in a cumulative update for SQL 2008. I ran this on a
> > server that has SQL Server 2008 cumulative update 1 and it did not work.
> > Reading through the bug fix seemed to indicate this is a different bug.
> >
> > The first Parameter just gets the data that is available to it and
> > displays
> > the drop down.
> > -- It Works
> > The second Parameter just gets data based in part on the choice from the
> > first parameter.
> > -- It Works.
> > The third Parameter just gets data based in part on the choice from the
> > first and second parameter.
> > -- It starts to work, but then breaks.
> > -- First it displays the choices of data.
> > -- Then you select the data just fine -- for a millisecond.
> > -- Then IMMEDIETLY after you select the data, it unselects it and
> > shows "Select a value".
> > -- When you post this report to the web, it works great! The bug
> > seems to be in VS BIDS.
> > The fourth Parameter just gets data based in part on the choice from the
> > first, second and third parameter.
> > -- It works when the report is executed on the web.
> > -- When the report is run in VS (BIDS) it never makes it to the
> > parameter.
> >
> > The report works great on my SSRS website which has SP1 (no cumulative
> > updates) for SQL 2008.
> >
> > Why I even bothered to post it to my server is beyond me because the two
> > have never acted differently in this regard, but the hunch turned out to
> > show
> > the problem in VS BIDS.
> >
> > Any ideas? I'd be glad to send someone a RDL, but I don't get free tech
> > support from MS.
> >
> > Thanks,
> > Keith
>
> .
>
 | 
Pages: 1
Prev: ole db connection
Next: Question about Subreport