Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

print of reports

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
popster
Asked:
popster
  • 2
  • 2
1 Solution
 
rag2000Commented:
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
 
popsterAuthor Commented:
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
 
rag2000Commented:
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
 
popsterAuthor Commented:
hi rag2000...

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

regards,
popster
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now