print of reports

Posted on 2001-06-11
Medium Priority
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..

Question by:popster
  • 2
  • 2

Expert Comment

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?

Author Comment

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,

Accepted Solution

rag2000 earned 300 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

Author Comment

ID: 6217474
hi rag2000...

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


Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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…
Six Sigma Control Plans

624 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