View Complete Post
I have been doing performance analysis for SSRS 2008 for some really huge reports that return between 1 to 5 million records (with single user) and
reports that return 100K to 200K records with multiple users. I have observed lot of issues which made me to think that may be SSRS 2008 is not good enough for such a huge reports even less good if there is a multiple users scenario for those big reports(though
I wanted to use it). Please go through my points and share your views on this.
Before putting up the points I would like to mention my configuration, Windows Server 2003 Enterprise Edition R2 SP2 64 bit (totally dedicated to
SSRS reports as the data source for these reports was SQL Server 2005 Enterprise Edition), Microsoft Reporting Services 2008 R2 64 bit, 8 CPU, 8 GB RAM and the reports are simple tabular reports which are fetching the data from a single table (no joins)
I have a task where i need to create dynamic report using SQL Server 2005 Reporting Server.
Client will be given a page where there are drop down will be provided from which he can select columns and in 2nd drop down can select where conditions and on button click will generate report using sql reporting server.
Pls advise architecture how can i proceed with this project
hi, i'm a new user of mvc 2, so, i need to use crystal reports on mvc 2, actually, i'm developing on visual studio 2008, but i canÃÂ´t run my reports. it's posible run my reports???
thank you very much.
Having a very wierd problem. I have an application that uses Crystal Reports and it uses what I have found to be a common scenario (I am not a CR expert in any way). I have an ASPX page that gathers options for the report, and then it goes and gets the data and if there is some, a button appears for them to launch the report. On clicking that button, the code sets some values in the HttpResponse.Context area, then performs a Server.Transfer to another ASPX page that is our Report Template. This page contains the CR stuff and it generates a PDF version of the report. It then does the following code:
With HttpContext.Current.Response .ClearContent() .ClearHeaders() .ContentType = "application/pdf" .AddHeader("Content-Disposition", "inline; filename=Report.pdf") .BinaryWrite(s.ToArray) .End() E
I wonder how to add a project template called Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?
I opened my reports in Business Intelligent Development Studio 2005. I want to edit reports.
I m newbie to these reports. Is it the right way to Open in Business Intelligent Development Studio 2005.
How can I edit the reports after that.? Can anyone help me from beginning.
I my application i have generated dynamic rows that contains some textbox values, i need to take those values and display in
reports. I am storing that dynamically added values in another table. please help me.
I need to develop 3 pages.
On the first page user defines atmost 7 column names to be displayed on the report. I'm saving these names in a Sql DB table 'Columns' with Column_Nm and Column_ID as Table columns.
On the second page I'm retrieving column_Nm from the table and displaying them on the page so that the user enters the data. This data is saved in another table 'Summary' with the Columns column1 through column7.
on the 3rd page I need to show a report of 'Summary' table.
How do I dynamically replace column1 through column7 names with that of 'Column_Nm' on the report?
Any help/suggestions would be appreciated.
I am new to .Net and And I have absoutely no idea about crystal reports. Can anyone please let me know a step by step process of how to design and generate a crystal report in vs2005
I need to ask for start date and endate.. when selected .. i should genarte a report using the existing stiored procedure and the connection string in my web config file..
Your help willbe very much appreciated..
A common software-development task is generating a graph from a set of test-related data. But if you're doing it by hand and the underlying data changes frequently, this particular task can become quite tedious. James McCaffrey shows you how to automate the process using Windows Presentation Foundation technology.
MSDN Magazine June 2010
This article describes how to generate documents that contain data stored in SharePoint lists. The example demonstrates how OpenXML content controls can be defined to capture list data in a Word document and how LINQ to XML can be used to query the lists. The documents are generated from a SharePoint Web Part.
MSDN Magazine October 2009
Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both WindowsÃÂ® Forms and Web-based applications.
MSDN Magazine June 2006
The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.
MSDN Magazine March 2006
SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.
John C. Hancock
MSDN Magazine August 2004
MSDN Magazine February 2003
MSDN Magazine January 2003