brilliant! Now tell me where did you find that out, in BOL? where is the full list of such properties and methods?

thanks.

I implemented this (in Access) by just creating a function which takes the operator, number parameter and data value as parameters and returns a true or false which can be...

Yes, you're right, though you can write your own print rendering extension (apparently). Other than that use the PDF export. The version coming with SQL Server 2005 may well have...

if the child group's visibility depends on an expression, can't you use the same expression? if not, what are you trying to do exactly? The group won't appear if there...

you don't need a web server to build reports, but it is necessary for distributing them in the way intended. Otherwise you would have to query the ReportServer database, but...

yes, we also store 'amended_by' and amended_date' on the main tables.

e.g.

the contact table has:

id (primary key), name, address, ..., entered_by, entry_date, amended_by, amended_date.

the updated_contact table has:

log_id (primary key), id,...

if you install the ADP at each client, isn't updating it a pain? I use an MDB for reporting which everyone here accesses and updating it just involves refreshing one...

When I last looked at Access Projects,  you couldn't have more than one user accessing it at the same time, which limits its usefulness.

while we're on the subject, if you create a report with subreports, the columns in Excel aren't consistent as you move down the rows: subreports which yield no rows only...

This URL achieves your purpose:

http://blue/ReportServer?/project_name/report_name&rs:Command=Render&rs:Format=CSV&rc:Encoding=ASCII

with 'project_name' and 'report_name' provided by you.

I'm just beginning with Reporting Services like yourself. So what's the quickest way of printing a report?

We tried this out to replace a whole set of tables setup to keep the results of each user's selections from the database. We constructed a single table to hold...

Solved - tracelog files are on server.

This is the subject of MS Knowledge Base article 842538; it is fixed in the latest version of Reporting Services.

When I had this problem in VB it was solved by adding

SET NOCOUNT ON

at the front of the sp.

Well, there's obviously more than one way to skin a cat (sorry cat lovers , like me); AJ was thinking along the lines I was, but Dave's must get first...