RS not stable?

Hi there,
I made several reports using RS with SP1, they worked well untill I
made a change: There are two parameters for every report - Network and
Region, which were independent. I changed them to related, i.e whenever
I choose a Network, then only show Regions under this Network.
I made changes on 2 development machines - A and B. After I made this
change, there are lot of errors/issues happened on each machine:
1) On machine A, after deployment, I have to click twice on "View
Report" to view a report in IE.
2) On machine B, besides "click twice problem" in IE. There are tons of
problems when I try to "preview" the report:
a) I use "All" as default value for Network parameter, When I click on
Network drill down button to pick up one Network, sometimes it works,
sometimes it doesn't - always show "All".
b) My test data should have 8 pages for one report, but sometimes show
page 13? sometimes show page 22? If I try to check every page, on page
3 I always got error "Generic error in GDI+", then move to page 5' If
I refresh, it works well.
c) I knew in my DB, Network is 8 or 13, not null. But sometimes I got "
Network is null" error' After I refresh, sometimes it works, sometimes
it doesn't.
For machine B, the RS seems not stable at all, it always sometimes
works, sometimes doesn't work. Seems something messed up.
Anybody got any idea about this? Thanks in advance.
HenryI've used RS for 13 months now and SP1 as soon as it came out, whilst
it isn't perfect I've found it to be quite stable. I think you've some
more fundamental issues, especially the GDI+ error. I can't help you
I'm afraid, but just to let you know, your problems are not normal.
Chris
fanh@.tycoelectronics.com wrote:
> Hi there,
> I made several reports using RS with SP1, they worked well untill I
> made a change: There are two parameters for every report - Network and
> Region, which were independent. I changed them to related, i.e
> whenever I choose a Network, then only show Regions under this
> Network.
> I made changes on 2 development machines - A and B. After I made this
> change, there are lot of errors/issues happened on each machine:
> 1) On machine A, after deployment, I have to click twice on "View
> Report" to view a report in IE.
> 2) On machine B, besides "click twice problem" in IE. There are tons
> of problems when I try to "preview" the report:
> a) I use "All" as default value for Network parameter, When I click on
> Network drill down button to pick up one Network, sometimes it works,
> sometimes it doesn't - always show "All".
> b) My test data should have 8 pages for one report, but sometimes show
> page 13? sometimes show page 22? If I try to check every page, on page
> 3 I always got error "Generic error in GDI+", then move to page 5' If
> I refresh, it works well.
> c) I knew in my DB, Network is 8 or 13, not null. But sometimes I got
> " Network is null" error' After I refresh, sometimes it works,
> sometimes it doesn't.
> For machine B, the RS seems not stable at all, it always sometimes
> works, sometimes doesn't work. Seems something messed up.
> Anybody got any idea about this? Thanks in advance.
> Henry|||I'll echo that (stable, and I use it extensively).
If this is for all reports then I suggest re-installing. If it is for a
specific few reports then you can try looking at the code for the RDL. I
have seen a few times where things got out of wack. For instance I deleted a
group but the group didn't get deleted from the RDL. Given the changes you
have made that is a possibility. In Visual Studio open up your report and
then do a view code and look through the xml and see if anything doesn't
look right.
The other thing I wonder is how you are getting this information, what are
you querying. Could something have changed there?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:%23bnuJX8IFHA.2736@.TK2MSFTNGP09.phx.gbl...
> I've used RS for 13 months now and SP1 as soon as it came out, whilst
> it isn't perfect I've found it to be quite stable. I think you've some
> more fundamental issues, especially the GDI+ error. I can't help you
> I'm afraid, but just to let you know, your problems are not normal.
> Chris
> fanh@.tycoelectronics.com wrote:
> > Hi there,
> >
> > I made several reports using RS with SP1, they worked well untill I
> > made a change: There are two parameters for every report - Network and
> > Region, which were independent. I changed them to related, i.e
> > whenever I choose a Network, then only show Regions under this
> > Network.
> >
> > I made changes on 2 development machines - A and B. After I made this
> > change, there are lot of errors/issues happened on each machine:
> > 1) On machine A, after deployment, I have to click twice on "View
> > Report" to view a report in IE.
> > 2) On machine B, besides "click twice problem" in IE. There are tons
> > of problems when I try to "preview" the report:
> > a) I use "All" as default value for Network parameter, When I click on
> > Network drill down button to pick up one Network, sometimes it works,
> > sometimes it doesn't - always show "All".
> > b) My test data should have 8 pages for one report, but sometimes show
> > page 13? sometimes show page 22? If I try to check every page, on page
> > 3 I always got error "Generic error in GDI+", then move to page 5' If
> > I refresh, it works well.
> > c) I knew in my DB, Network is 8 or 13, not null. But sometimes I got
> > " Network is null" error' After I refresh, sometimes it works,
> > sometimes it doesn't.
> >
> > For machine B, the RS seems not stable at all, it always sometimes
> > works, sometimes doesn't work. Seems something messed up.
> >
> > Anybody got any idea about this? Thanks in advance.
> >
> > Henry
>