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

Report Viewer/Default Parameters

Is it possible for one report to have different default parameters, based on the user viewing the report, when the report is accessed via the Report Viewer?

Thanks.

accessed
acceded
accused
accedes
accursed
Edit...
Ignore all
Add to dictionary(No suggestions)
Edit...
Ignore all
Add to dictionary

accessed
acceded
accused
accedes
accursed
Edit...
Revert to "accesed"

Assuming you are asking for viewing report through report server: default values can be (1) constant, (2) expression-based, or (3) dataset based.

Regarding (2): you could determine the default value based on the current userid, e.g =iif(User!UserId="abc", "Default1", "Default2")

Regarding (3): you could use the current user information in the query commandtext or as parameter into a stored procedure to dynamically determine the default value.

-- Robert

|||

If you are using the ReportViewer control in ASP.NET, you can set the value of the parameter programatically based on the current user identity:

this.ReportViewer1.ServerReport.ReportPath = "/SampleReports/Employee Sales Summary";

ReportParameter p = new ReportParameter("EmpID", "20");

this.ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { p });

Report Server (MSSQLSERVER) cannot connect to the report server database.

I was viewing some reports, and it suddenly showed me that error, from Reporting Services Configruation I restarted the service but nothin, that s the error show on event log.

What else can I Do?

I also see this on the event log.

La configuración de permisos que depende de la aplicación no concede permiso de activación local para la aplicación de servidor COM con CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

al SID (S-1-5-20) de NT AUTHORITY\Servicio de red del usuario. Este permiso de seguridad se puede modificar mediante la herramienta administrativa Servicios de componentes.

Para obtener más información, vea el Centro de ayuda y soporte tcnico en http://go.microsoft.com/fwlink/events.asp.

|||Take a look at this previous post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=399539&SiteID=1

Report Refreshing Issue - Showing Old Data

Hello, Just wondering if anyone can provide a solution to the following:
You are viewing a published report and the underlying data changes. If you
click on the refresh button in Internet Explorer, the report still displays
the old / unchanged data (clicking on the RS refresh button returns the new
data).
Is there any way to force Internet Explorer to get a new copy of the report
with the new / changed data, when the IE refresh button is clicked. This is
important as the report is being executed from an application and the users
wonâ't have access to the RS refresh button. Thanks.Make sure, that on the report manager, clcik on the properties of the report,
and on the execution tab, make sure it is set to "Always run with most recent
data" and "Do not cache " option is checked.
Also try using the refresh button in the report managertool bar, and not the
IE refresh button. This refresh button is present next to to the export drop
down list. (Will be visible after you run the report).
Apart from this cant think of anything else. Hope that helps.
"Maple Tardis" wrote:
> Hello, Just wondering if anyone can provide a solution to the following:
> You are viewing a published report and the underlying data changes. If you
> click on the refresh button in Internet Explorer, the report still displays
> the old / unchanged data (clicking on the RS refresh button returns the new
> data).
> Is there any way to force Internet Explorer to get a new copy of the report
> with the new / changed data, when the IE refresh button is clicked. This is
> important as the report is being executed from an application and the users
> wonâ't have access to the RS refresh button. Thanks.