Displaying Data Reports

[PORRASTAR]

Hi
I have a database of clients and their information. I use a VB app to insert ,edit & delete the data. I then use a Data Report to display the data.
The problem theat I'm having is that I want to show each client os a seperate report so I can print out their details seperatelly. Does anyone know how I can do this?
Thanking you oin advance
PORRASTAR

[omodara]

Let Me start by sking U some question about your data.
1. Did your clients record has any identification No that is unique
if yes you can do something.

You can either use the command in your dataenvironment. In the general tab you go to sql builder and write a script like
select * from client where clientid = ? move to prameter tab and give a name to the ? like clent ID

You will now reference this in your form.


Another way. You will have a temporary table where you will select the records you want in to and bind the table to the datareport. Before you select into this table you will need to be deleting all the records in the temp table first.

These are the ways you can to it.

select * into temp from client where clientid = 1 for example.
This will copy the records toa new table and you acn now report from it.