Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Sep 18, 2008 09:57 AM by johnjalani
Sep 18, 2008 09:57 AM|LINK
Hi., Please help me to enlighten my mind on how to work on this project.
1st the database, this database is simple, the table looks like this
field1 field2 field3.......field.....
A 1 KJH
A 2 JKP
A 5 123
A 7 1K3
D 99 Y8S
E 36 QWE
E 8 65P
so if you would look, its a simple database where the "field1" is like a group field and the rest are details of this group...
2nd is the aspx page. it is not like an ordinary gridview control which the data is line up accordingly in each field, it will have its own personalize look, like some vertical texts, etc. and more importantly, the page should be printed as is and fitted
to a 8in x 13in (long bond paper) landscaped. or which is much better if a button beside the table will initiate the printing but not as much needed to have that button anyways.
3rd is the display of the data in the table.there will be a dropdown that displays distinctively the group field which is in this example is field1. the table should only show of about 25 records (which is estimated to fit in a 8in x 13in or long bond
paper) of details about the selected group, the rest should be paged behind. i know this process can be done in the gridview control. but this is the hard part, in the footer of the table is the total or sum per field and per PAGE, this mean that in the footer,
it will only show the sum of the displayed 25 records, if you would go to the next page, it will compute again for the sum of the succeding 25 records which is definitely different in terms of data content.
this is how should it look like
Gridview Initial display or page 1
if group A is selected in the dropdownlist and has about 100 records of details so it has 4 pages, this is the 1st page
field1 field2 field........
up to 25 .........
Gridview 2nd page
field1 field2 field.......
up to page 4 to its 100th record
actually my only question is the summing up of records per page, i just state the whole story just to give you an insight of how this page works, i know someone there can help me, so please, help me, thanks alot in advance, if you have any question please