Parameter dependency on other params

Hi,
I have a param in my report which depends on the other two parameters. So
every time I change either Param1 or Param2 the list for Param3 is
automatically refreshed. While this works fine in one of the reports, I am
having following problems in the another report -
1. A "Tab" after modifying the Param1, brings me back to Param1 box ?
2. Even a mouse-click in the Param2 box, half of the time, takes the cursor
to Param1 box. A very "cautious" click prevent it from going back to Param1
box :-)
3. The report "hangs" at time in the "Preview" mode and it adds 3-4 blank
pages at the end of the report although I know that the report should not
exceed 1 page.
4. I get "Object reference not set to an instance of an object" and "A
generic error occured in GDI+" randomly.
Param1 and Param2 are of type datetime and are not related. Param3 is of
type string and comes from a query based on the values for Param1 and Param2.
Has anybody else faced this ? Any solutions.
RegardsYou might be seeing a problem in preview in the report designer. Try
deploying it and see if the same problem happens. I have seen other issues
in the designer with cascading parameters.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dude" <Dude@.discussions.microsoft.com> wrote in message
news:5DA4AA93-DE58-486A-9E01-76EED48324BC@.microsoft.com...
> Hi,
> I have a param in my report which depends on the other two parameters. So
> every time I change either Param1 or Param2 the list for Param3 is
> automatically refreshed. While this works fine in one of the reports, I am
> having following problems in the another report -
> 1. A "Tab" after modifying the Param1, brings me back to Param1 box ?
> 2. Even a mouse-click in the Param2 box, half of the time, takes the
cursor
> to Param1 box. A very "cautious" click prevent it from going back to
Param1
> box :-)
> 3. The report "hangs" at time in the "Preview" mode and it adds 3-4 blank
> pages at the end of the report although I know that the report should not
> exceed 1 page.
> 4. I get "Object reference not set to an instance of an object" and "A
> generic error occured in GDI+" randomly.
> Param1 and Param2 are of type datetime and are not related. Param3 is of
> type string and comes from a query based on the values for Param1 and
Param2.
> Has anybody else faced this ? Any solutions.
> Regards|||I don't see the report hang but the "Available List" is not refreshed when I
modify the Param1 or Param2. Only after I click on "View Report" is the list
modified.
I found the sam thing happening in the other report which I thought was
working. The only difference is that it has another string Param (Param0)
which is used as an Input param for the Param3. Param0 is populated by a
query. So what I am seeing is -
1. On change of Param0 (a drop down list), Param3 is refreshed automatically
2. On change of Param1 and Param2, Param3 is not refreshed
3. Param3 is refreshed, once I click "View Report".
Is this the expected behaviour ? anything to do with the type (datetime) ?
"Bruce L-C [MVP]" wrote:
> You might be seeing a problem in preview in the report designer. Try
> deploying it and see if the same problem happens. I have seen other issues
> in the designer with cascading parameters.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dude" <Dude@.discussions.microsoft.com> wrote in message
> news:5DA4AA93-DE58-486A-9E01-76EED48324BC@.microsoft.com...
> > Hi,
> > I have a param in my report which depends on the other two parameters. So
> > every time I change either Param1 or Param2 the list for Param3 is
> > automatically refreshed. While this works fine in one of the reports, I am
> > having following problems in the another report -
> > 1. A "Tab" after modifying the Param1, brings me back to Param1 box ?
> > 2. Even a mouse-click in the Param2 box, half of the time, takes the
> cursor
> > to Param1 box. A very "cautious" click prevent it from going back to
> Param1
> > box :-)
> > 3. The report "hangs" at time in the "Preview" mode and it adds 3-4 blank
> > pages at the end of the report although I know that the report should not
> > exceed 1 page.
> > 4. I get "Object reference not set to an instance of an object" and "A
> > generic error occured in GDI+" randomly.
> >
> > Param1 and Param2 are of type datetime and are not related. Param3 is of
> > type string and comes from a query based on the values for Param1 and
> Param2.
> >
> > Has anybody else faced this ? Any solutions.
> >
> > Regards
>
>|||I think you are seeing a bug in Report Designer. If you deploy it and test
it I bet you will see it is OK. I tracked down something similar for someone
else awhile back.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dude" <Dude@.discussions.microsoft.com> wrote in message
news:2FF737A5-D781-4FA1-A205-7BFE7533EEA5@.microsoft.com...
> I don't see the report hang but the "Available List" is not refreshed when
I
> modify the Param1 or Param2. Only after I click on "View Report" is the
list
> modified.
> I found the sam thing happening in the other report which I thought was
> working. The only difference is that it has another string Param (Param0)
> which is used as an Input param for the Param3. Param0 is populated by a
> query. So what I am seeing is -
> 1. On change of Param0 (a drop down list), Param3 is refreshed
automatically
> 2. On change of Param1 and Param2, Param3 is not refreshed
> 3. Param3 is refreshed, once I click "View Report".
> Is this the expected behaviour ? anything to do with the type (datetime) ?
> "Bruce L-C [MVP]" wrote:
> > You might be seeing a problem in preview in the report designer. Try
> > deploying it and see if the same problem happens. I have seen other
issues
> > in the designer with cascading parameters.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Dude" <Dude@.discussions.microsoft.com> wrote in message
> > news:5DA4AA93-DE58-486A-9E01-76EED48324BC@.microsoft.com...
> > > Hi,
> > > I have a param in my report which depends on the other two parameters.
So
> > > every time I change either Param1 or Param2 the list for Param3 is
> > > automatically refreshed. While this works fine in one of the reports,
I am
> > > having following problems in the another report -
> > > 1. A "Tab" after modifying the Param1, brings me back to Param1 box ?
> > > 2. Even a mouse-click in the Param2 box, half of the time, takes the
> > cursor
> > > to Param1 box. A very "cautious" click prevent it from going back to
> > Param1
> > > box :-)
> > > 3. The report "hangs" at time in the "Preview" mode and it adds 3-4
blank
> > > pages at the end of the report although I know that the report should
not
> > > exceed 1 page.
> > > 4. I get "Object reference not set to an instance of an object" and "A
> > > generic error occured in GDI+" randomly.
> > >
> > > Param1 and Param2 are of type datetime and are not related. Param3 is
of
> > > type string and comes from a query based on the values for Param1 and
> > Param2.
> > >
> > > Has anybody else faced this ? Any solutions.
> > >
> > > Regards
> >
> >
> >|||I think it was just a bit slow and I was a bit impatient :-)) Though I did
test it in the deployed version, I was seeing the problem as I didn't wait
enough for it to refresh the params. Thanks.
"Bruce L-C [MVP]" wrote:
> I think you are seeing a bug in Report Designer. If you deploy it and test
> it I bet you will see it is OK. I tracked down something similar for someone
> else awhile back.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dude" <Dude@.discussions.microsoft.com> wrote in message
> news:2FF737A5-D781-4FA1-A205-7BFE7533EEA5@.microsoft.com...
> > I don't see the report hang but the "Available List" is not refreshed when
> I
> > modify the Param1 or Param2. Only after I click on "View Report" is the
> list
> > modified.
> >
> > I found the sam thing happening in the other report which I thought was
> > working. The only difference is that it has another string Param (Param0)
> > which is used as an Input param for the Param3. Param0 is populated by a
> > query. So what I am seeing is -
> > 1. On change of Param0 (a drop down list), Param3 is refreshed
> automatically
> > 2. On change of Param1 and Param2, Param3 is not refreshed
> > 3. Param3 is refreshed, once I click "View Report".
> >
> > Is this the expected behaviour ? anything to do with the type (datetime) ?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > You might be seeing a problem in preview in the report designer. Try
> > > deploying it and see if the same problem happens. I have seen other
> issues
> > > in the designer with cascading parameters.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Dude" <Dude@.discussions.microsoft.com> wrote in message
> > > news:5DA4AA93-DE58-486A-9E01-76EED48324BC@.microsoft.com...
> > > > Hi,
> > > > I have a param in my report which depends on the other two parameters.
> So
> > > > every time I change either Param1 or Param2 the list for Param3 is
> > > > automatically refreshed. While this works fine in one of the reports,
> I am
> > > > having following problems in the another report -
> > > > 1. A "Tab" after modifying the Param1, brings me back to Param1 box ?
> > > > 2. Even a mouse-click in the Param2 box, half of the time, takes the
> > > cursor
> > > > to Param1 box. A very "cautious" click prevent it from going back to
> > > Param1
> > > > box :-)
> > > > 3. The report "hangs" at time in the "Preview" mode and it adds 3-4
> blank
> > > > pages at the end of the report although I know that the report should
> not
> > > > exceed 1 page.
> > > > 4. I get "Object reference not set to an instance of an object" and "A
> > > > generic error occured in GDI+" randomly.
> > > >
> > > > Param1 and Param2 are of type datetime and are not related. Param3 is
> of
> > > > type string and comes from a query based on the values for Param1 and
> > > Param2.
> > > >
> > > > Has anybody else faced this ? Any solutions.
> > > >
> > > > Regards
> > >
> > >
> > >
>
>