Solved

print of reports

Posted on 2001-06-11
4
174 Views
Last Modified: 2010-03-05
hi all...
am working on a project and once of the modules is report printing...

the reports that i need to print is pretty large.. ie ten of thousands records with some calculations to be done...

i know using pages (ie displaying a number of records per page) is one of the method... but how should i go abt doing it?? also, is there any other methods to to it??

thanxs in advance..

regards,
popster
0
Comment
Question by:popster
  • 2
  • 2
4 Comments
 
LVL 3

Expert Comment

by:rag2000
ID: 6176456
displaying a fixed number of records per page is the best way, I feel, with next and previous buttons to navigate, even page numbers to directly jump to particular pages.

What is the database backend that you are using?
0
 

Author Comment

by:popster
ID: 6201248
the database i'm is sybase... does it matter wat kind of database i'm using??

hope to hear from u soon...

thanxs and regards,
popster
0
 
LVL 3

Accepted Solution

by:
rag2000 earned 100 total points
ID: 6201367
I use Perl and MySQL, and this is how I do it...

The sql statement that is use goes like this
select * from ........... limit $offset, $showmax
where $offset is set to 0 and $showmax to 5, that's starting from the first record and five records only

once the first page is displayed, a hidden form field on the page counting the page number is set to 1

again this same cgi is called and the value of page number read, it is multiplied by 5 for each next button

hope you understand... I am not sure whether limit works in sybase or not
0
 

Author Comment

by:popster
ID: 6217474
hi rag2000...

got wat u mean... will work on tat... thanxs.. .

regards,
popster
0

Featured Post

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

Email validation in proper way is  very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…
In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

809 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