ADO - Recordset

[Michael]

I was wondering if anyone can help me. I've converting an already existing system (designed in Access which produces reports for the accounts dept) over to a web based system. The Access atabase has been transfered to a SQL database and I've designed a number of stored procedures to extract information from the database for reports. I have created a web application with a logon page to gain access to the system and a main page with a form on it to pass in parameters and run the stored procedures. When I click on the submit buttons on the main page it redirects to a seperate page for each report and the results are coming back in a html table

I've had a lot of help from you guys and I've managed to get on well so far (thank you all so much). My final problems remaining are using the results-set to Sum the contents of certain fields, group by and order fields etc. I need to do things similar to what is done in Access when you go to design a report

To give you an idea of how the results come back you can run this table in a browser:
I need to be able to only select certain fields and sum them up, group them by Paper Name etc. Does anyone know how I can do this with my record set. Or should I try and group by, order by and make calculations as part of my stored procedure before I access it
Thank you very much for any help you may be able to give me

<table border=1 width="100%"><tr><td>Belfast Telegraph</td><td>0.375</td><td>75</td><td>7</td><td>64</td><td>1/4/2004</td><td>3</td><td>24</td><td>1</td><td>95506N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Belfast Telegraph</td><td>0.375</td><td>71</td><td>7</td><td>64</td><td>1/4/2004</td><td>3</td><td>24</td><td>1</td><td>95506N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Sunday Life</td><td>0.31</td><td>18</td><td>0</td><td>18</td><td>1/4/2004</td><td>7</td><td>5.58</td><td>1</td><td>96601N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>City</td></tr><tr><td>Belfast Telegraph</td><td>0.3313</td><td>325</td><td>116</td><td>209</td><td>1/4/2004</td><td>5</td><td>69.2417</td><td>1</td><td>96120N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>NorthWest</td></tr><tr><td>Adds for Free</td><td>0.375</td><td>100</td><td>63</td><td>37</td><td>1/4/2004</td><td>4</td><td>13.875</td><td>1</td><td>95105N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Belfast Telegraph</td><td>0.375</td><td>9</td><td>0</td><td>9</td><td>1/4/2004</td><td>4</td><td>3.375</td><td>1</td><td>94406N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr></table><table border=1 width="100%"><tr><td>Belfast Telegraph</td><td>0.375</td><td>75</td><td>7</td><td>64</td><td>1/4/2004</td><td>3</td><td>24</td><td>1</td><td>95506N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Belfast Telegraph</td><td>0.375</td><td>71</td><td>7</td><td>64</td><td>1/4/2004</td><td>3</td><td>24</td><td>1</td><td>95506N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Sunday Life</td><td>0.31</td><td>18</td><td>0</td><td>18</td><td>1/4/2004</td><td>7</td><td>5.58</td><td>1</td><td>96601N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>City</td></tr><tr><td>Belfast Telegraph</td><td>0.3313</td><td>325</td><td>116</td><td>209</td><td>1/4/2004</td><td>5</td><td>69.2417</td><td>1</td><td>96120N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>NorthWest</td></tr><tr><td>Adds for Free</td><td>0.375</td><td>100</td><td>63</td><td>37</td><td>1/4/2004</td><td>4</td><td>13.875</td><td>1</td><td>95105N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr><tr><td>Belfast Telegraph</td><td>0.375</td><td>9</td><td>0</td><td>9</td><td>1/4/2004</td><td>4</td><td>3.375</td><td>1</td><td>94406N</td><td>1/5/2004 12:07:30 PM</td><td>1/12/2004 12:25:15 PM</td><td>Final</td></tr></table>

[Bob Barrows]

Michael wrote:

> To give you an idea of how the results come back you can run this
> table in a browser:
> I need to be able to only select certain fields and sum them up,
> group them by Paper Name etc. Does anyone know how I can do this
> with my record set. Or should I try and group by, order by and make
> calculations as part of my stored procedure before I access it.
> Thank you very much for any help you may be able to give me.

You may want to look into using Crystal Reports. if this is an option for
you, I don't want to take a lot of time describing how to use asp to do what
you want. So I await your reply.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Stephen Cairns]

I'll not be able to use Crystal reports as its not an option for me here on my placement. Sorry its taken so long to reply but I finish work at 5pm UK time. I would really appreciate it if you could help him complete this task in ASP