If anyone is interested in this, I eventually went to the database and modified the "Subscriptions" table directly

Does anyone have a solution for this? I have a bunch of different reports sent out to the same person via email and they all show in the list as...

Excellent, now I've learnt something as well

Tracy,

I havent used it myself, but try:

RunningValue(Fields!Cost.Value, Sum, Nothing)

HTH

Did anyone find a way to bypass the save file dialog box?

Just so I'm sure I've got this straight.

You have 2 fields displayed in the one text box? And you want the colour of the second to be dynamic (and therefore...

The Color property of your textbox should have

=IIF(Fields.Whenever.value > 0, "RED", "BLACK")

While the Value property will be

=Fields!whatever.value

The expression you posted may have been failing because of the missing comma...

G'day Mike,

Don't know if it helps, but I had heaps of problems with dates and in the end wrote a function that formats the date and returns a string for display...

Probably a silly question, but you dont have a group header and/or a group footer line, do you?

Dataset for Major Codes assuming that each Manager has their own Codes

="Select MajorCode From MajorCodes where Manager='" & Parameters!ManagerParam.Value & "'"

Assumes that the Manager Parameter is called ManagerParam.

Is this what...

data source=OracleConnect

Then it depends on the credentials you supply.

HTH

There's a pretty good walkthrough in the books online (Walkthrough - Using a Dynamic Query in a Report). Hope it helps

Are you talking about the order or the actual layout? I'm not sure about layout, but the order seems to be determined by the parameter order in the .rdl file

well, I didn't find the cause of the problem, but i did find a solution. I replaced my non-query defaults that i was generating with code in the report with query default...

Hi,

I don't know if this is any help but I had a similar problem when I first started using RS. My problem was with outdated drivers on the server.