Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2008-06-10
3
625 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:Anurag Agarwal
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:
Anurag Agarwal 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Regex validation 2 28
Firing an ASP.NET event on selection of a JQuery datepicker 4 30
"Emulate" TAB key when press Enter Key 3 46
asp Google Map 2 27
Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

839 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