.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

SSRS Migration and Client impact

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
 
We currently have SSRS 2005 and will be migrating to SSRS 2008 (not R2) very soon. Most of our applications are VS2005 ASP.NET Web applications. We do not have any plans to upgrade the applications in the near future. The applications use different methodologies to access the SSRS reports. Some use the URL Access method - build a url with all parameter data (and PDF rendering extension) and open the url. Some use a report viewer control working in the Server mode (Remote mode) to display the server reports. Some use the ReportingService2005.asmx web service to render reports as pdf/excel How the clients could be impacted in each of these scenarios, if we just upgrade the SSRS from 2005 to 2008?


View Complete Post


More Related Resource Links

SSRS Client Access

  
Hi, I have evaluating SSRS, and somehow I am quite confused. Please tell me if I am wrong in the basic understanding. To create a new report by the user, the client has to be installed with the Report Builder software, and must have access to the database server directly? Is there no thin client, say a web page available to allow the users to create a report (choosing of fields) like that of the Report Builder Software? Please help to answer this fundamental questions. Thank you.

Migration of DSN use for SQL Server access from Windows SP-3 clients to Windows 7 64 bit client

  
We have numerous apps which use a named DSN using SQLSRV32.dll for an ODBC connection from our Windows XP-Pro SP3 32 bit machines client access to remote windows 2003 based SQL servers (mix of 2005 and 2008).  On migrating to Windows 7, this dll will not allow the apps to use the newly constructed DSN (using SQLSRV32.dll with ODBC), even though a test connection is sucessful (abbeit much slower than seen on the XP-Pro machines).  What must I use on the Windows 7 64 bit machine to allow a DSN to be used by the migrated apps?  - I have descerned through Google that WDAC is now the tool to use, but I am cluless how to use it. - The expectations from the app on the Windows XP-Pro and on the Windows 7 64 bit machines is to use a DSN to connect to SQL servers on Windows 2003. I would appreciate any advice, and thanks!

2008 SSRS (R2) Oracle Client issue

  

Hi,

We have installed SSRS 2008 R2 on 64 bit windows 2003 server, and the 64 bit oracle client to connect to oracle databases.  The tnsping, and SQL plus are working from the server.  But when we trying to access the same database from report manager using new Datasource, we will get the below error.

"Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed."

We have installed only the 64 bit oracle client, and the Oracle folders are given with proper permissions to access it for SQL serving account which is used to run SSRS.

Any help greatly apprciated.  Thank you.


SSRS 2005 to 2008R2 custom code migration issue

  

We have an SSRS 2005 report that we upgraded to 2008R2 with custom code in the report properties code tab that no longer works.  We checked permission setting in the report server config files, checked if the data set was passig nulls and it is not, looked to see if we ignored the error if the report would render the correct value anyway despite the error and it did not, tried different code variations and referencing different system libraries without luck....we are truly baffled.  The only thing that does work is setting the total to 0 and removing the loop through the jsColl to compute the total.  Here is the code that used to work on 2005.  Any ideas why it does not work on 2008R2?  We call it in an expression =Code.getTotal()

Public

 

jsColl As Microsoft.VisualBasic.Collection

 

Looking for guidance: Integrated SharePoint SSRS migration and upgrade from 2007 to 2010

  

Our existing prod farm is MOSS 07 with an integrated SSRS instance using SQL Server 2008, both on Windows Server 2003 64bit boxes. SharePoint databases are on a different SQL Server 2008 server.

I have built a new SharePoint 2010 farm on Windows Server 2008 R2 boxes, using a single SQL Server 2008 R2 Enterprise server as the backend for both SharePoint databases and Reporting Services (installed in Integrated mode). We are going to be using the database-attach method of upgrading our SharePoint farm.

Is there any specific guidance out there on exactly how to migrate/upgrade Reporting Services in this scenario? I've read through some of the MSDN content (How To: Migrate a Reporting Services Installation) but nothing seems to deal specifically with doing this when in Integrated mode with SharePoint. Our business heavily relies on SSRS reports in SharePoint and also shared and custom report subscriptions via email.

We do have a dev SharePoint 2010 farm in a similar configuration that I can test migration/upgrade steps. Thanks.


Can a table name impact generating the service client when creating Service Reference?

  

I have a new WCF service I'm writing under VS2010 and IIS 7.5.  The service includes a table named Client.

When I built my test class and added the service reference, the first test was confirming the creation of the client.

My service reference did not generate any client that I could call .Open on!!!! I was wondering if it is due to that table name???

 Edited to add that I tested the service through the browser and it brings up the page and XAML fine.

Thanks for any assistance!


Old school Client/Server migration to Sharepoint

  

I am an old school Client/Server developer and the creator of a 10year old business application (PowerBuilder/SQL Server) that is still used today by about 100 users. The application has about 100 tables, the largest table contains about 1,000,000 records.  I am looking for a platform by which I can upgrade this application to a more feature rich, technologically current environment. It seems like Sharepoint has some features that out of the box would add value to the users.

My Questions/Problems are:

1) Is Sharepoint a viable platform that can be used to replace a legacy Client/Server application.

2) I have tried to get handle on how I can get up to speed with Sharepoint development, but all I see are details, no big picture or how to get started. (A Wiki, Blog, Announcement, Calendar, Task or 5 column list of 100 items don't really constitute the components of a business app)

3) Should I be starting with Infopath first to replace the data entry forms from the legacy app?

4) What is the best path for transitioning from a Client/Server Developer to the Sharepoint Developer?

5) Are there any online examples of a business application on a Sharepoint platform

 

Any help, direction or comments would be appreciated.


Orace Report to SSRS migration.

  

Oracle reports has RDF format, we can convert it to xml. 

Maybe somebody  knows any convertors from RDF to RDL files?


SSRS Print problem on client machines

  

Hi

Initially after deploying SSRS 2005 report on server, the client machine could not avail print functionality because of the error "Unable to load client print control". Inspite of allowing ActiveX installation, the print functionality was not working.

Googling on this issue I found that rsclientprint.dll needs to be registered in C:\Windows\system32.

After successfully registering this dll, print functionality started working on some machines. However on some machines it started giving the error 'Error loading resource library.(0x8007007E)'.

Now I am stuck as to what needs to be done. Any help is appreciated.


SQL Server 2005 cluster install with SSRS and SSIS - best approach for installs and migration?

  

I just installed SQLServer 2005 STD edition SP3 on an active/passive 2 node cluster, Intended to replace a SQLServer 2005 sp3 EE install (not clustered) that is in production now using SSIS and SSRS.  I would need to migrate the databases, reporting, and Integration Services over to the new server cluster.  

 

1.    Does it make sense to run on a SQL Server 2005 on a cluster if SSIS and SSRS are not cluster aware? This is my 1st time adm

SSRS 2008 migration issue

  

After migrating reports from SSRS 2005 report to SSRS 2008  using visual studio 2008 report designer we lost filter conditions for reports. In tablix property window we are able to see only one filter condition out of 8 filters defined in orginal source file. 

When we check RDL file the filters exists and when we deploy the report to sql server 2008 it works good.

When we try to edit report in 2008 report designer and save it it removes all the filters.  When we deploy the report after editing in report designer it shows partial data.  We are using filters to satisfy in condition

 


Use jQuery and ASP.NET AJAX to build a client side Repeater

  
By sending only data to the client, you can profoundly reduce the size of what you send and see a substantial increase in performance. You also allow yourself the ability to easily add features like light-weight sorting and paging on the client. This can not only improve your users' experience, but reduce server load and bandwidth requirements.

Client Side Gridview Pagination using JQuery

  
I would like to show how to use Client Side Gridview Pagination using Jquery Table Pagination Plugin by using Ryan Zielke.

Use jQuery and ASP.NET AJAX to build a client side Repeater

  
By sending only data to the client, you can profoundly reduce the size of what you send and see a substantial increase in performance. You also allow yourself the ability to easily add features like light-weight sorting and paging on the client. This can not only improve your users' experience, but reduce server load and bandwidth requirements.

To that end, I'm going to walk you through these four steps to effectively implementing a client side Repeater, using ASP.NET AJAX and jQuery:

Practical Multithreading for Client Apps

  
Writing applications that use multiple threads is often considered an advanced programming task, prone to errors. In this month's column, I'll focus on a practical application of multithreading in Windows® Forms applications with some real benefits, while attempting to keep things simple. My goal is to present multithreading in an approachable way that addresses a very common need: writing applications with a user interface that remain responsive to the user.

Use jQuery and ASP.NET AJAX to build a client side Repeater

  
By sending only data to the client, you can profoundly reduce the size of what you send and see a substantial increase in performance. You also allow yourself the ability to easily add features like light-weight sorting and paging on the client. This can not only improve your users' experience, but reduce server load and bandwidth requirements.

SharePoint document migration challenges when migrating files and folders

  
There are several challenges when migrating documents to Microsoft SharePoint. While these challenges can be overcome, they are a real pain if the migration source, content and file systems are not SharePoint friendly.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend