Showing posts with label designed. Show all posts
Showing posts with label designed. Show all posts

Monday, March 19, 2012

How to use reportviewer control

Hi,

I have couple of reports designed and they are on the report server and those reports are driven using some strored procedures.

I am building a asp.net program and want to use the reportviewer control in it, and i was wondering if there is any way that i could reference the reports thats been created usiing BIDS and use them in report viewer, or do i have to build them from scratch.

Any ideas pls?

Regards

Karen

Yes, you can use those reports.

When you want to use local reports (RDLCs) you use ReportViewer.LocalReport but when you want to host reports rendered on a server you use ReportViewer.ServerReport, which has a ReportServerUrl property, etc.

Here is a good place to start. http://gotreportviewer.com/ -- you will find a demo of remote mode there...

>L<

|||

Thanks a lot Lisa for your answer, but i have a another question.

I have added a reportviewer control to my project, set the report processing mode to remote and have also specified the report server url and the report path. but when i build my project and run it, i get a error message saying the request failed with HTTP Status 401: unauthorized,

which tells me that i need to set the credentials. so u please tell me how can i set them.

Regards,

Karen

|||

Is ShowCredentialPrompts set true or false?

IOW: Do you see the prompts, and your values don't work, or are you not seeing the prompts?

If you want to impersonate a user programmatically (not with the prompts) here is a help topic with code showing you how:

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms.ireportservercredentials(vs.80).aspx

... if you put in the credentials, whether interactively or by code, and it does not work, you need to check whether the identity you're using has rights by configuring the report server instance...

>L<

|||

ShowCredentialsPrompts is set to true, and i dont any prompts at all, and i am getting the error messge The request failed on page load.

Regards

Karen

|||

Then I guess you should try setting the credentials in code, as shown in the help file... If that doesn't work it is something about how your report server is set up that should be independent of what we're discussing here...

>L<

|||

but i am using webforms and this is what i have specified

Dim cache As System.Net.CredentialCache = New System.Net.CredentialCache

'Dim cache As New ServerReport

cache.Add(New Uri("http://192.168.0.235/ReportServer"), "Negotiate", New System.Net.NetworkCredential("Administrator", "abc", "abc"))

ReportViewer2.ServerReport.ReportServerCredentials = cache

but when i try to run it i am getting the following error

Unable to cast object of type 'System.Net.CredentialCache' to type 'Microsoft.Reporting.WebForms.IReportServerCredentials'

Regards

Karen

|||

I'm terribly sorry, I seem to have gotten two threads confused here <s>. Yes, you are using webforms.

Your code doesn't look like what I see in this topic on specifying credentials: http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx

The error you're getting bears out what I'm saying, because the topic I'm pointing you to is the topic on the

IReportServerCredentials Interface <s>. So try to follow what it says there, and make any web.config changes you need to make (that topic will point you here http://msdn2.microsoft.com/en-us/library/ms251661(VS.80).aspx for web config stuff).

>L<

|||

Lisa,

Thanks a lot for your help, the report viewer control works fine.

Regards,

Karen

Wednesday, March 7, 2012

How to use cubes of 2000 in 2005

We have to create reports based on cubes, which were designed using SQL 2000. We have migrated to SQL 2005. We have the cubes (.cub files) and a database of SQL 2000. We need to design few sample reports based on these cubes (specifically some charts). We are quite new to Analysis Services.

Can anyone guide us or point to the right direction, what are the steps to be followed here, like do we need to import these cubes into a 2005 database or can these be just copied in a folder and referred directly. basically where and how to start from.

Any suggestion or help is appreciated.

It is not possible to re-use local cube files (.cub) that were created with Analysis Services 2000 in Analysis Services 2005.

You will have to ether Migrate your AS2000 server cubes to AS2005 or to create new cubes in AS2005 from scratch.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

hi Edward,

i also had similar queries and got a reply as follows

"

This Project REAL paper should give you some guidance:

http://www.microsoft.com/technet/prodtechnol/sql/2005/asmigrtn.mspx

>>

Analysis Services 2005 Migration

Published: August 19, 2005

SQL Server Technical Article
Applies To: SQL Server 2005

Summary: This paper guides you through the process of migrating to Analysis Services in SQL Server 2005. The Unified Dimensional Model (UDM) provides new design opportunities for cube developers. The UDM has brought together the relational reporting and OLAP reporting worlds to provide a unified forum for both data request environments. Understanding the new design options and how they affect your organization will optimize migration. The Migration Wizard is a fast and effective tool for moving your existing cubes to Analysis Services 2005. This paper introduces the wizard and helps you determine whether you should use it. In some cases it is better to redesign from scratch to ensure that you are properly leveraging the new features of Analysis Services 2005.

>>

"

please let me know if this is correct as i haven't tried out and i would also like to know how to try it out.

thanks,

|||

I think you would benefit from the information in the sources you mention.

I dont think what I mention above comes in any contradiction with the information you get from the papers you mention. Is there specific point you are not certain about?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.