I'm creating a Asp.net website application in visual studio 2012 using vb through which users will select options from a dropdown menu and checkbox to then produce a report/document based on their choices.
So basically, they will click "Pizza and chips" (for example) and I will need the info under "Pizza and chips" in the database that's linked to the website to display the information in a report (preferably pdf) which they can save online or download.
Is there any way to do this?
I'm using a MySQL database! Any help would be greatly appreciated!
Thanks,
Polly
for changing the pdf when you change the dropbox, you will need to store the location of the pdf in your database. Then store the ID of the location in the 'value' of the dropbox.
from there you should be golden. on change trigger an event that hits the database for the location of the pdf. When you get the location use the code in that link to display the pdf
There are many ways to achieve this.. Some of them are:
1>Crystal Reports
2>SSRS
3>Adobe Forms
4>itextsharp
5>Convert your HTML page to pdf
6>export from dataset/datatable to pdf
7>export from gridview/datalist/repeater to pdf
8>Telerik Reporting Services
Please Choose a option and let me know how do you want to proceed..
Thank You.
<div>
Hello Vishal,
I would like to use Crystal reports. I have downloaded it, so any help would be greatly appreciated! Just to remind you, i'm using asp.net in vb and a mysql database.
Just to remind you, i'm using asp.net in vb and a mysql database.
Sorry for the delay ... Here are the links you could refer..
Hi Vishal,
Thank you very much for the help! Do you have any knowledge on the following issue?
- When someone selects an option from a parameter I have created, is there any way to display all the information that is contained in the rest of the row of that option in the database? Or will they have to manually select each piece of data in that row
for it to be displayed in the report?
Polly123
0 Points
6 Posts
Creating automatic reports?
Jan 04, 2013 05:21 PM|LINK
Hi guys,
I'm creating a Asp.net website application in visual studio 2012 using vb through which users will select options from a dropdown menu and checkbox to then produce a report/document based on their choices.
So basically, they will click "Pizza and chips" (for example) and I will need the info under "Pizza and chips" in the database that's linked to the website to display the information in a report (preferably pdf) which they can save online or download.
Is there any way to do this?
I'm using a MySQL database! Any help would be greatly appreciated!
Thanks,
Polly
nealruggles1
Member
18 Points
9 Posts
Re: Creating automatic reports?
Jan 04, 2013 05:38 PM|LINK
As for displaying the pdf check here:
http://stackoverflow.com/questions/9647551/display-pdf-in-web-application
for changing the pdf when you change the dropbox, you will need to store the location of the pdf in your database. Then store the ID of the location in the 'value' of the dropbox.
from there you should be golden. on change trigger an event that hits the database for the location of the pdf. When you get the location use the code in that link to display the pdf
geniusvishal
Star
14076 Points
2794 Posts
Re: Creating automatic reports?
Jan 05, 2013 06:10 AM|LINK
There are many ways to achieve this.. Some of them are:
1>Crystal Reports
2>SSRS
3>Adobe Forms
4>itextsharp
5>Convert your HTML page to pdf
6>export from dataset/datatable to pdf
7>export from gridview/datalist/repeater to pdf
8>Telerik Reporting Services
Please Choose a option and let me know how do you want to proceed..
Thank You.
My Website
www.dotnetvishal.com
Polly123
0 Points
6 Posts
Re: Creating automatic reports?
Jan 05, 2013 05:07 PM|LINK
Polly123
0 Points
6 Posts
Re: Creating automatic reports?
Jan 05, 2013 05:08 PM|LINK
.
Polly123
0 Points
6 Posts
Re: Creating automatic reports?
Jan 06, 2013 02:48 PM|LINK
Hello Vishal,
I would like to use Crystal reports. I have downloaded it, so any help would be greatly appreciated! Just to remind you, i'm using asp.net in vb and a mysql database.
Thanks
</div>geniusvishal
Star
14076 Points
2794 Posts
Re: Creating automatic reports?
Jan 07, 2013 04:12 AM|LINK
Sorry for the delay ... Here are the links you could refer..
http://vb.net-informations.com/crystal-report/vb.net_crystal_reports_tutorials.htm
http://www.dotnetking.com/ArticleDetails.aspx?ArticleID=44
http://msdn.microsoft.com/en-us/library/ms227881%28v=vs.80%29.aspx
My Website
www.dotnetvishal.com
Polly123
0 Points
6 Posts
Re: Creating automatic reports?
Jan 08, 2013 08:01 PM|LINK
Hi Vishal,
Thank you very much for the help! Do you have any knowledge on the following issue?
- When someone selects an option from a parameter I have created, is there any way to display all the information that is contained in the rest of the row of that option in the database? Or will they have to manually select each piece of data in that row for it to be displayed in the report?
Thanks
Pengzhen Son...
Star
8189 Points
842 Posts
Microsoft
Re: Creating automatic reports?
Jan 11, 2013 05:03 AM|LINK
Hi,
In my opinion, you can use a parameterized expression to modify a dataset so that it returns a different set of columns.
And you can refer to this : http://sqlserverbiblog.wordpress.com/2010/03/11/dynamically-adding-and-removing-columns-to-a-query-and-report-2/ .
Hope it can help you.
Feedback to us
Develop and promote your apps in Windows Store
ManikandanUl...
Participant
850 Points
253 Posts
Re: Creating automatic reports?
Jan 11, 2013 05:26 AM|LINK
Hi
try to crystel report. if want code i will place.....
Click "…Mark As Answer" if my reply helpful....