My tip for converting Access reports into Reporting Services: rewrite them from scratch. Unless your reports are really simple, you'll spend so much time rejigging parameters and Access functions and...

The ToggleItem propoerty doesn't allow an expression so I guess it's either on or off for every row. However you could calculate for each class whether there's a range of...

the trick is to get the data-driven query, i.e. the one that supplies the email addresses for the subcription, NOT to return a row where there is no data. I...

This is neat, but couldn;t you have the report call itself? Then there's be no need for an SR1 AND an SR2. I do this for a couple of reports...

have you re-queried the data source in report designer and checked the data source parameters tab to make sure it is listed?

Here it is in detail:

ALTER procedure [dbo].[sp_proc] (@MultiParamList varchar(1000))

AS

SELECT *

FROM TableName

WHERE (charindex(','...

This works in a stored procedure and avoids using a function:

(charindex(',' + dbfield + ',',',' + @MulitParamList + ',')>0

I've done this by basing the subscription query on a table that gets updated by the stored procedure on which the report is based.

why don't you just email the link to the file?

you could try refering to your stored procedure, suitably amended, under the default section of the parameter setup - if there's only one row that would be the default, otherwise NULL.

I use the following to put the incoming parameter list into a table I can join against:

set

@nextcomma = charindex(

you might find this useful:

http://www.sqlservercentral.com/columnists/jspink/areporttodisplayandedituserrights.asp

Well, I wasn't convinced at first, but I've just tried it and it does work! Many thanks, I'm sure that would have taken ages to track down.

What would be even...

There's a postcript to all of this...

Just as one engineer was checking out the Dell software for managing this sort of scenario, another was grappling with a server making an...

It's not a pagination/margins problem, just a matter of separating groups onto different pages. I don't want this to leave me with a blank last page.