SQL Reporting :: Obtain Information From Database Into Reports (Excel / Word / Powerpoint)
Feb 16, 2011
I am very new to asp.net and SQL server. I am helping out my team by researching the possibility for any user to download reports into Word and Excel from the SQL database by simply clicking a button.
There is difference when I view my report in report viewer 2010 and PDF/Excel/Word.In Report Viewer the alignment is correct which align left . But when i export into PDF/Excel/Word the alignment are justify . How to solve this problem?
I am using MVC 2 right out of the box, and the control gives the login and seems to work wonderfully. Now I am trying to find out the userId of the person who is logged in, so that i can retrieve information that is only needed for that one person. How do i find out how is logged in?
How can i display in web browser directly from the database varbinary Office Files (Word, Excel, PowerPoint, and many others like Images), like this example in PDF [URL] ....
My reports works fine in my local machine. But when i pushed it to development server to test, it displays the following error:
Failed to load database information. Error in File C:WINDOWSTEMPReportViewer {2E85E5E2-D118-438D-BD62-9B30F2E6E224}.rpt: Failed to load database information. what i need to configure in development server or make changes in my code.
Well it's finally time to stop ignoring my unit's need for reports. I keep coming to dead ends. I gave up the crystal reports idea, and ssrs seems a little easier. Now the problem is that I'm creating a report locally on my laptop, then will change the connection string, upload it to my server and have it run against an identical database on the server.
I'm using SQL Server Express locally, and when I try to create a dataset (using the wizard), I can see the tables, but when I try to add one, I get an error message "Could not retrieve schema information for table or view". I looked up this error and there isn't much useful info on it. I guess it some bug when trying to use SS Express? Is there a work around for this? Can I create the report programmatically? Should I use a different kind of reporting service?
Iam working on a banking web application developed in asp.net 3.5 and MS SQL Server 2008.My problem is to create reports including some pre-formatted reports,summary reports and some detail reports.I want to know what is the best technique to create these reports.I don't want to use third party reporting tools as they have to be configured on the web server and some times they takes lot of time in generating reports due to their complex structure.Since its a web application having large recordsets so i need a consistent solution keeping in mind the performance and complex nature of the reports which might be demanded by the banks.Can anyone help me please in this regard?
I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or something missing.