Solved

PDF reports from asp.net (VB) uisng Visual Web Developer 2005 Express

Posted on 2008-06-10
3
624 Views
Last Modified: 2008-08-09
Hey EE,
I have an SQL database driven web app. The input/search/screen display part is complete and now I am down to the last part. I want to take the data that has been entered into the database and generate a pdf report for the user to print/save/transfer/etc. I want the report to ONLY be available to the user as a pdf file (ie: I want them to click "PDF BUTTON" on an aspx page and a pdf will be opened in a new window for them to review/save/print)

Here is a link to what the form will look like (without the data fields filled in):
http://www.mediafire.com/?d0xwlzyry3z

If there are more violations, the form may go to another page on the pdf report. How should I do this? I would like it to be as efficient as possible...

Remember, I am using vb!
0
Comment
Question by:dswett2
  • 2
3 Comments
 
LVL 11

Expert Comment

by:anuragal
ID: 21756531
The best way i can think of to your problem is through sql server reporting services.

What you need to do is to create a report through sql server reporting services. the report will be same as your aspx page is looking.

When the user will click on show pdf you can open a popup and from this popup you need to call the reporting service web service requesting to run the report. Now reporting service will convert that report output in pdf format by setting some parameters.
You need to save that pdf on your webserver . then again read it from that location & show it in browser.

This is bit complex to implement but it will solve your problem.

Anurag
0
 

Author Comment

by:dswett2
ID: 21782775
Where can I get SQL Server Reporting services? Is it open source? Do I get it with SQL server?

Also, I don't really want to save a copy of the pdf to the server... there will be tens of thousands of them and they are pretty much useless to store. I want them to be generated on the fly and downloadable.

Solution suggestions from others are still welcome...
0
 
LVL 11

Accepted Solution

by:
anuragal earned 500 total points
ID: 21828934
you will get the SQL Reporting Services along with sql server.

You will get a memory stream from reporting web services. Now it is up to you what way you want to show to the user.

Anurag
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now