Go to textbox9 look at the expressions (action expression) and look for a red squiggly line. It is showing you the field that does not exist, modify your expression...

Looking at your original post I am not sure how Low, Med, high, relates to your row values. Your columns have a clear relationship to them, but how...

Ready. Set. Commence Week.

Nice, thanks.

Just like the one that works for columns but substitute

Fields!Cost_type.Value

for

LOW

Nope, using 2008.

Date stamp is built using date parts with GetDate() as the source.

Then date stamp variable is then used in another variable to build the SQL statements. Very...

Each date time stamp for each day is the same, how do you know which one is the last transaction of the day?

SQL_Nw (8/5/2011)

---

For each of the three columns I am using visibility /Hiddden condition as for instance for the LOW column :

=iif(Parameters!Cost_Type.Value="LOW", false, true)

When I choose 'LOW' in my report i...

mosquito

Not so much about MAX as it is about logic. Nice question. Thanks.

What do you mean by a 12 month date?

1 package,

1 datasource

1 database

5 different source tables

5 different destination tables (dynamically created)

6 variables scoped at the package level, 1 to return the date integer, 5 to create the dynamic sql...

SQL_Nw (8/4/2011)

---

Thanks.

I can (low, med, high) in one single column annd do the sorting but here I need to separate them in 3 columns because thats the way client wants...

Looks pretty good to me. Test it with a few dates other than Now() and you will probably find that you will get what you want.

In the textbox where your date is: right click and go to TextBox properties and choose the Number tab, then select Date, then select the format you want.