Added: August/08/2005 at 3:40pm | IP Logged

I'm really struggling to get some intelligent grouping in my reporting. I have a three pronged heirarchy, thus:

Added: August/14/2005 at 6:05am | IP Logged

Sorry again, I just assumed that being on PowerASP and Classic ASP - General it was obvious I code in ASP and use SQL DBs.

Basically I have been told in the past to use one recordset for each group level. So in this example I'd need three recordsets. One for Business Area, one for Process and one for Procedure. This is all well and good, but how do I get the Process recordset to only display those values required using the Business Area ID as a filter...?

So, back to my original question, how do I get groupings in reporting?

In case you've dropped off since the start of this post, I code in ASP and use SQL DBs...

Thanks.

Added: August/30/2005 at 3:38pm | IP Logged

What a disappointment.

I thought there would be enough knowledge out there to tap into, yet it seems something that is too easy to do in MSAccess can't be done in ASP.

Does anyone want to explain to me the benefits of ASP then, if it can't do something simple like grouping?

Added: August/30/2005 at 3:59pm | IP Logged

You have no clue what you are talking about.
The TWO things have jack sh*t to do with each other.

How is that for an answer !