report to be generated acc to output in the recordset

[pna3]

For my project the front end is Vb and back end SQL.

I have to generate a report which shows how many records were entered for a particular day or a particular month.
For this i have written an SQL statement. I use a recordset to open this sql statement. this output needs to be shown on the screen in the form of a table which has the required columns showing all details of each record.
I cannot create a fixed table structure on the screen since the output in the recordset would keep varying. It could either be 5 or 10 records depending on the date selected by the user.
How do i get the desired output?

Please help this is very urgent.

 

[johnwm]

Set your table up based on the rst.Fields() collection or the Fields.Count property (depending on how you're doing your table)

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[pna3]

I mean what option can i use in VB which will help me develop reports?

 

[johnwm]

Sorry I thought you wanted a Screen table, not a report.

If you want the VB built-in Datareport:

Project|Add DataReport

You could also use Crystal (free old version on I think CD3)

You could also 'brew your own' with the Printer object or with the Word object model (assuming Word will be on your target machine)

Also read all of faq222-2244 to get better answers

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[pna3]

I did select the Add Report option from the Project Menu. I get the design of the data report. if not wrong i need to grag the command object from the Data Environment onto the Data Report.
However, I am unable to do so.

Kindly help

 

[johnwm]

I notice that you haven't yet read and taken any notice of faq222-2244, as you've asked 8 questions and haven't acknowledged any of the answers given, nor thanked anyone for their answers. Remember that this is a peer-to-peer forum and not a helpdesk.

As far as this problem is concerned, just go to the properties page for the DataReport (use F4 if you can't see the properties page). Set the DataSource property to the name of your DataEnvironment, and the DataMember property to the name of the Command

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'