Showing posts with label strange. Show all posts
Showing posts with label strange. Show all posts

Wednesday, March 28, 2012

Report Viewing and Vista

Hi

I am facing a strange problem while viewing a Windows Report in Windows Vista.

I have a machine which has Vista installed as the Operating system. I have two user id created to log into the system.

(Assumed user A and User B). Both the users have the same login credentials. However, the default user of the system is

User B.

I have a windows application, which uses Winreports for viewing the reports. I am creating the entire rdlc on - the - fly based on

the parameters specified from the User Interface. If I log into the system using user A and try to view the reports, the report is

perfectly generated and is being viewed properly without any error. However, if I log into the system using User B (the

default user of the system) and then try to view the same report (with all the parameters same) I am getting an Unauthorised

Access Violation error.

Please help with some of our valuable suggestions.

FYI: This happens only on PC having Windows Vista as the Operating System

Thanking you in advance,

Kind Regards,

PS

Hi Everybody,

Thank you very much to everybody who went through this issue.

Actually, the profile of user B had some issues. I deleted the account User B and re - created again, and it worked fine.

Thanking You once again,

Kind Regards,

Pratik

Monday, March 26, 2012

Report Viewer is printing a cached report

Hi All

I have a reporting viewer in a windows form that behaves very strange. When I open the form and run the report it shows up nicely in the report viewer. If I print the report it only prints one page. When i print the report a second time the whole report is printed. Next I'll change the report parameters and run the report, then it shows up nicely in the viewer, but when I print the report the first report is printed.

Does anyone know what to do with this problem?

Thanks in advance

I did some additional testing and the problem appears when im using a stored procedure with a parameter. Even if the parameter is changed and the correct result is displayed the old data is used when the report is printed.

Does anyone know why and where the data is cached?

|||Did you manage to solve this problem? I am having the same issue.
|||do you have repors set to cache in the report manager?|||No, all reports have the setting, Do Not cache temporary copies of this report.

Report Viewer is printing a cached report

Hi All

I have a reporting viewer in a windows form that behaves very strange. When I open the form and run the report it shows up nicely in the report viewer. If I print the report it only prints one page. When i print the report a second time the whole report is printed. Next I'll change the report parameters and run the report, then it shows up nicely in the viewer, but when I print the report the first report is printed.

Does anyone know what to do with this problem?

Thanks in advance

I did some additional testing and the problem appears when im using a stored procedure with a parameter. Even if the parameter is changed and the correct result is displayed the old data is used when the report is printed.

Does anyone know why and where the data is cached?

|||Did you manage to solve this problem? I am having the same issue.|||do you have repors set to cache in the report manager?|||No, all reports have the setting, Do Not cache temporary copies of this report.sql

Wednesday, March 21, 2012

report via url with parameters: strange issue....

Hi all,

I'm testing my report via a url, with report parameters.
But i have a strange issue:

If I open a new browser, and I do:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False" (thus without parameters)
Then it takes the default values that are configured in the report.
This returns 3 records, which is OK

If I open a new browser, and I do:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False&STAmonth=6"
This returns 5 records, which is OK

If I open a new browser, and I do:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False&STAmonth=5"
This returns 0 records, which is OK

BUT HERE COMES THE STRANGE THING:
If i try to go to two url's after eachother in the same browser, it gives bad result....
thus:
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False&STAmonth=5"
this returns 0 records, this is OK
but if I do hereafter (in the same browser)
"http://localhost/reportserver?/r1/Report_R1&rs:Command=Render&rc:Toolbar=False" (thus without parameters)
it still returns 0 records, while it should return 3 records.

Anyone experienced this also?
What can I do or what am I doing wrong?

Thanks

Hi sttke,

This looks to be a by-product of keeping the session open and caching information. You can add rs:ClearSession=true to the url and it should clear the parameters.

|||that does the job !!!
thanks a lot, Brad !!!

Friday, March 9, 2012

Report Server website - button presses ignored

I'm seeing a strange problem on my production Reportng Services (SQL 2000)
server.
Some of the website buttons, like OK & CANCEL when attempting to create a
new site-wide Schedule, don't function. No error reported when you press
them, they're just ignored, it's as if the installation failed to complete
properly.
My development server, also running SQL 2000 and Reporting Services, doesn't
have the issue.Have you got activeX disabled?
Are you running sp2?
SimonN wrote:
> I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> server.
> Some of the website buttons, like OK & CANCEL when attempting to create a
> new site-wide Schedule, don't function. No error reported when you press
> them, they're just ignored, it's as if the installation failed to complete
> properly.
> My development server, also running SQL 2000 and Reporting Services, doesn't
> have the issue.|||HI. Tks for the reply.
No ActiveX is not disabled, and client PC is running SP2.
Browsing the two installations from the same client, so i can bring up two
IEs one pointing to an RS website that works and the other to the one that is
faulty.
"SmartbizAustralia" wrote:
> Have you got activeX disabled?
> Are you running sp2?
> SimonN wrote:
> > I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> > server.
> >
> > Some of the website buttons, like OK & CANCEL when attempting to create a
> > new site-wide Schedule, don't function. No error reported when you press
> > them, they're just ignored, it's as if the installation failed to complete
> > properly.
> >
> > My development server, also running SQL 2000 and Reporting Services, doesn't
> > have the issue.
>|||Simon,
Look in the Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config file for a <ReportServerURL>
and <ReportServerExternalURL> config values. Many times these reference the
machine name instead of the URL used to access the reporting services. I've
found if these these entries don't match the domain name in the URL used to
access report manager, many of the buttons simply don't do anything when
clicked.
- Chris
"SimonN" <SimonN@.discussions.microsoft.com> wrote in message
news:63A63397-D966-4A70-8D5A-24AD9054E50B@.microsoft.com...
> I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> server.
> Some of the website buttons, like OK & CANCEL when attempting to create a
> new site-wide Schedule, don't function. No error reported when you press
> them, they're just ignored, it's as if the installation failed to complete
> properly.
> My development server, also running SQL 2000 and Reporting Services,
> doesn't
> have the issue.|||Chris,
Thanks for the reply.
I checked the value of ReportServerURL in the RSWebApplication.config, it's
set to the correct name of the server. I have a DNS alias that user will use
to run reports, but for all administration I'll stick to using the actual
server in the URL.
I don't have an entry for ReportServerExternalURL, but it sounds like this
is a 2005 feature when accessing the Report Server through a firewall. I'm
only running the 2000 version.
Unfortunately, I'm still seeing the same issue even when I browse with the
serve name identified by the ReportServerURL config element.
"Chris Walls" wrote:
> Simon,
> Look in the Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config file for a <ReportServerURL>
> and <ReportServerExternalURL> config values. Many times these reference the
> machine name instead of the URL used to access the reporting services. I've
> found if these these entries don't match the domain name in the URL used to
> access report manager, many of the buttons simply don't do anything when
> clicked.
> - Chris
> "SimonN" <SimonN@.discussions.microsoft.com> wrote in message
> news:63A63397-D966-4A70-8D5A-24AD9054E50B@.microsoft.com...
> > I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> > server.
> >
> > Some of the website buttons, like OK & CANCEL when attempting to create a
> > new site-wide Schedule, don't function. No error reported when you press
> > them, they're just ignored, it's as if the installation failed to complete
> > properly.
> >
> > My development server, also running SQL 2000 and Reporting Services,
> > doesn't
> > have the issue.
>
>