lbirdwell
|
| Posted: 07/15/2002, 2:01 PM |
|
After doing a search in something like the taskman example, I have a listing of records. I can click on a record and display the details. This works fine.
What I need to do is search for a group of records and then have a button to display details for all records in the search group. Sort of a report. i.e. someone searches for all tasks assigned to someone, finds the list and wants to print out a report with the details of all of the tasks.
Thanks for any input.
|
|
|
 |
Nicole
|
| Posted: 07/16/2002, 7:19 AM |
|
Hello,
I suppose you should do something like:
- pass ID field of each found record to another page where make select for all the records where id field value equals to passed ones.
- to do it I think you can build the parameters string that will look like:
?id=23+5+7+3
To do it create session var when the page is loading and add new value to it when found records are displayed on the Grid. E.g. in Before Show Row event:
ASP
Session("params") = Session("params") & "+" & <form_name>.<field_name>.Value
- on the detail page I think it will be possible to build sql query that displays the details. Of course it depends on tables structure, so I can provide only common approach.
Then you should catch the session value split it into separate values and create custom Where clause for the query. To totally replace generated Where with custom one create Before Execute Select event and use code:
<form_name>.Command.Where = "custom Where"
Hope, it helps.
|
|
|
|
Jovita
|
| Posted: 05/02/2003, 11:57 AM |
|
Nicole,
Can you please, help with code. Please, use the Bugs app as an example. I have the same need but I cannot understand and follow what you are saying in your response. Maybe a code example using the ASP pages and table names from the Bugs app will help me...
Thanks
|
|
|
|
|
