Solved

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

Posted on 2008-06-10
3
619 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
This video discusses moving either the default database or any database to a new volume.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

708 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

13 Experts available now in Live!

Get 1:1 Help Now