473,573 Members | 2,671 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Reports from the web

Hello,

This probably isn't the best group to post this in, but i'm not too sure
where would be better (any ideas appreciated).

What I would like to be able to do is use the ASP or ASP.NET system to
generate reports from a database. I know this can be done quite simply by
creating a recordset and then creating code to display the data, but I would
like to have a report that is formatted for a printer
(headers/footers/etc.). I currently do this by creating a service that
checks a database table looking for requests and then calls Access to
generate a snapshot report to post back to the user. This works fine but I
don't realy want to be using Access on my server.

The ideal solution would be a way of creating a report that is formatted for
the client's printer but I guess this isn't possible, so a method of
producing a report formatted for a generic printer would be the next best
thing.

Are there any suggested reporting techniques for web applications or thrid
party report generation tools that might suit?

Cheers,

<M>ike

Jul 19 '05 #1
7 1917
In news:ed******** ********@TK2MSF TNGP10.phx.gbl,
Mike Dinnis <mike dot dinnis at abraxas-uk dot com> typed:
: Hello,
:
: This probably isn't the best group to post this in, but i'm not too
: sure where would be better (any ideas appreciated).
:
: What I would like to be able to do is use the ASP or ASP.NET system to
: generate reports from a database. I know this can be done quite
: simply by creating a recordset and then creating code to display the
: data, but I would like to have a report that is formatted for a
: printer (headers/footers/etc.). I currently do this by creating a
: service that checks a database table looking for requests and then
: calls Access to generate a snapshot report to post back to the user.
: This works fine but I don't realy want to be using Access on my
: server.
:
: The ideal solution would be a way of creating a report that is
: formatted for the client's printer but I guess this isn't possible,
: so a method of producing a report formatted for a generic printer
: would be the next best thing.
:
: Are there any suggested reporting techniques for web applications or
: thrid party report generation tools that might suit?

If you need formatted printed output, the best solution I have found is to
create a PDF file. Otherwise you're left with the browser formatting, which
as we all know, isn't pretty.

Don


: Cheers,
:
: <M>ike
Jul 19 '05 #2
But in what would you compile the report prior to creating
the PDF? I'm trying to get away from Access (or at least
get it off the server) as I belive it's improper to have
it on the web server. Is there a way to create a report
directly as a PDF? I understood it acted as a printer to
output an existing document/file/report.

Cheers,

<m>ike
-----Original Message-----
In news:ed******** ********@TK2MSF TNGP10.phx.gbl,
Mike Dinnis <mike dot dinnis at abraxas-uk dot com> typed:
: Hello,
:
: This probably isn't the best group to post this in, but i'm not too: sure where would be better (any ideas appreciated).
:
: What I would like to be able to do is use the ASP or ASP.NET system to: generate reports from a database. I know this can be done quite: simply by creating a recordset and then creating code to display the: data, but I would like to have a report that is formatted for a: printer (headers/footers/etc.). I currently do this by creating a: service that checks a database table looking for requests and then: calls Access to generate a snapshot report to post back to the user.: This works fine but I don't realy want to be using Access on my: server.
:
: The ideal solution would be a way of creating a report that is: formatted for the client's printer but I guess this isn't possible,: so a method of producing a report formatted for a generic printer: would be the next best thing.
:
: Are there any suggested reporting techniques for web applications or: thrid party report generation tools that might suit?

If you need formatted printed output, the best solution I have found is tocreate a PDF file. Otherwise you're left with the browser formatting, whichas we all know, isn't pretty.

Don


: Cheers,
:
: <M>ike
.

Jul 19 '05 #3
On Thu, 2 Oct 2003 05:00:05 -0700, "Mike"
<mikedotdinnis@ abraxas-ukdotcom> wrote:
But in what would you compile the report prior to creating
the PDF? I'm trying to get away from Access (or at least
get it off the server) as I belive it's improper to have
it on the web server. Is there a way to create a report
directly as a PDF? I understood it acted as a printer to
output an existing document/file/report.


That is one way of doing it. However, when you purchase Adobe Acrobat,
you get an API that can be used to generate the PDF files as well. One
last option would be to pick up a reporting component such as
ActiveReports where you can generate the report using their methods
and the stream the report out as a PDF file.

Jul 19 '05 #4
Mike Dinnis wrote:
What I would like to be able to do is use the ASP or ASP.NET system to
generate reports from a database. I know this can be done quite simply by
creating a recordset and then creating code to display the data, but I would
like to have a report that is formatted for a printer
(headers/footers/etc.). I currently do this by creating a service that
checks a database table looking for requests and then calls Access to
generate a snapshot report to post back to the user. This works fine but I
don't realy want to be using Access on my server.
The ideal solution would be a way of creating a report that is formatted for
the client's printer but I guess this isn't possible, so a method of
producing a report formatted for a generic printer would be the next best
thing.
Are there any suggested reporting techniques for web applications or thrid
party report generation tools that might suit?


You could use SQL Server to store your databse and then denote the
tables involved as "linked external tables" to Access. This would allow
you to
- store the tables in SQL Server,
- use Access's snapshot viewer capabilities to generate reports.

Or you could generate RTF documents that will load either Word or
WordPad when sent to the client browser. RTF has a number of different
versions, but it mostly works. For details see:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q270906

Good Luck,
Michael D. Kersey

Jul 19 '05 #5
Mike Dinnis wrote:
This probably isn't the best group to post this in, but i'm not too sure
where would be better (any ideas appreciated).
What I would like to be able to do is use the ASP or ASP.NET system to
generate reports from a database. I know this can be done quite simply by
creating a recordset and then creating code to display the data, but I would
like to have a report that is formatted for a printer
(headers/footers/etc.). I currently do this by creating a service that
checks a database table looking for requests and then calls Access to
generate a snapshot report to post back to the user. This works fine but I
don't realy want to be using Access on my server.
The ideal solution would be a way of creating a report that is formatted for
the client's printer but I guess this isn't possible, so a method of
producing a report formatted for a generic printer would be the next best
thing.
Are there any suggested reporting techniques for web applications or thrid
party report generation tools that might suit?


You could use SQL Server to store your databse and then denote the
tables involved as "linked external tables" to Access. This would allow
you to
- store the tables in SQL Server,
- use Access's snapshot viewer capabilities to generate reports.

Or you could generate RTF documents that will load either Word or
WordPad when sent to the client browser. RTF has a number of different
versions, but it mostly works. For details see:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q270906

Good Luck,
Michael D. Kersey

Jul 19 '05 #6
Thanks for the suggestions.

I think this sounds like a good idea, I'll just have to go and investigate.

Cheers,

<M>ike
"Dan Brussee" <db******@NOSPA Mnc.rr.com> wrote in message
news:ao******** *************** *********@4ax.c om...
On Thu, 2 Oct 2003 05:00:05 -0700, "Mike"
<mikedotdinnis@ abraxas-ukdotcom> wrote:
But in what would you compile the report prior to creating
the PDF? I'm trying to get away from Access (or at least
get it off the server) as I belive it's improper to have
it on the web server. Is there a way to create a report
directly as a PDF? I understood it acted as a printer to
output an existing document/file/report.


That is one way of doing it. However, when you purchase Adobe Acrobat,
you get an API that can be used to generate the PDF files as well. One
last option would be to pick up a reporting component such as
ActiveReports where you can generate the report using their methods
and the stream the report out as a PDF file.

Jul 19 '05 #7
Mike,

Sounds like you are using our product (www.rptsoftware.com) or
developed something in-house very similiar? You should use PDF over
snapshot format.

It usually comes down to:
- What tool can I easily use to develop reports that produces the kind of
output needed?

Low end web-based reporting tools:
- RPT software www.rptsoftware.com (uses Access as report tool)
- Crystal
- ActiveReports
- coding to straight ASP, ASP.NET, or some kind of XML/display of
information

High end tools (usually just more scalable):
- Business Objects
- Microstrategy
- Cognos
- Other OLAP specific vendors (ProClarity etc...)
- Many others

I do recommend doing everything in SQL Server and just use Access with
pass-thru
queries running stored procedures or SQL Server syntax SQL at runtime.

HTH,
Mark

"Michael D. Kersey" <md******@hal-pc.org> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
Mike Dinnis wrote:
This probably isn't the best group to post this in, but i'm not too sure
where would be better (any ideas appreciated).
What I would like to be able to do is use the ASP or ASP.NET system to
generate reports from a database. I know this can be done quite simply by creating a recordset and then creating code to display the data, but I would like to have a report that is formatted for a printer
(headers/footers/etc.). I currently do this by creating a service that
checks a database table looking for requests and then calls Access to
generate a snapshot report to post back to the user. This works fine but I don't realy want to be using Access on my server.
The ideal solution would be a way of creating a report that is formatted for the client's printer but I guess this isn't possible, so a method of
producing a report formatted for a generic printer would be the next best thing.
Are there any suggested reporting techniques for web applications or thrid party report generation tools that might suit?


You could use SQL Server to store your databse and then denote the
tables involved as "linked external tables" to Access. This would allow
you to
- store the tables in SQL Server,
- use Access's snapshot viewer capabilities to generate reports.

Or you could generate RTF documents that will load either Word or
WordPad when sent to the client browser. RTF has a number of different
versions, but it mostly works. For details see:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q270906

Good Luck,
Michael D. Kersey

Jul 19 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
3007
by: BStorm | last post by:
I have a transaction log file where the DataSet table's Description column is actually delimited into "subcolumns" based upon the transaction id. I would like to parse these into separate fields for reporting purposes and am wondering if anyone knows if this is easily accomplished using the .NET version of Crystal Reports? For example, the...
2
5760
by: Andrew | last post by:
Hi there: I can successfully control a report's GroupLevel ControlSource property by using: ..Reports!rptEESTMT_A.GroupLevel(i).ControlSource = "CorpName" where rptEESTMT_A is the actual name of the Access Report. However, I have about 75 reports to process. Each report has its own unique
0
2254
by: Ian | last post by:
(Sorry if I have repeated this, it did not appear the first time) I have the following code on a button. The idea is that when this button is clicked it prints several reports automatically then loops through several other reports and prints them. These reports are not sent to a printer but sent to a program called Fine Print PDF Factory...
3
6901
by: Gheaci Maschl | last post by:
Hi all! I would like to have your opinion about my problem and my proposal how to solve it: Ingredients: - BTriev database - Crystal Reports - maybe MS Access - Liinos6 (small ERP software)
1
2135
by: KEVIN97810 | last post by:
Hello to all, I am trying to fill all my reports in a listbox but I may not need to show other reports. How do you modify this function to do that. I have losts of reports but don't want to show all of them. I need to exculed certain reports from the list box. Public Function EnumReports(fld As Control, id As Variant, row As Variant,...
2
3254
by: B.Newman | last post by:
I've got some VB.NET code that *should* get a list of reports from an Access MDB and populate a list box with them. It doesn't detect any of the reports at all. oAccess.Reports.Count comes up as 0. There are four reports in the MDB. They are not hidden. They don't have special characters in their names. There is no security on the MDB and...
3
8911
by: VMI | last post by:
I know this may not be the best NG for this, but I feel you guys know more about this than any of the other NGs. I need to build several simple reports (over 50 of them and they get their data from sql server) and I was wondering whish of these is the better tool .. We're still not sure if they'll be loaded from an existing VB6 application...
12
2516
by: Tony Ciconte | last post by:
We are evaluating the prospect of integrating and/or using Crystal Reports with some of our current products. Some of these are still in Access 97 and are running well. Since we cannot include the report wizard in a runtime environment, we are looking at ad hoc report writers like Crystal. Can we include Crystal with our runtimes and/or is...
16
6500
by: JoeW | last post by:
I'm utilizing a database that I created within MS Access within a program I've created in VB.NET. I am using the VB front end to navigate the information, but want to be able to print a report, that I've also created within MS Access. I've attempted using the Access.Application instance, but I get errors when it tries to load the ...
3
5120
by: joelpollock | last post by:
I'm having trouble continuously page numbering a large report in MS Access. The report is made up of three separate Access reports which I join together at the end. In the past I have opened the reports and viewed them to see how long they are then go in and manually type the page number and total page number. I am aware of the and ...
0
7664
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7982
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8175
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7732
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6353
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5553
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5255
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
1268
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
989
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.