Yes. I did. Please see attachment.

Thanks

Frank

How to write a SQL query in SSRS expression?

Something like = Select * from ...

thanks

=code.AddTotal(ReportItems!textbox40.value)

Hi Geoff5.

Sorry to bother you again.

I appreciate your help one more time. I just want to combine several agency codes into one agency name in my report.

The following expression...

I understand now. Thank you very much.

Frank

Hi Geoff5,

I am just learning SSRS and wish you could help me.

If activity code is between 50 and 65, I will count unique applicationNumber

However, The following expression does not work.

=CountDistinct((IIF(Fields!ActivityCode.Value)...

Hello geoff5,

One more question, I wish you could help.

I have a query like: SELECT name, agency from tblname.

I also have a query like: SELECT username, grant from tblgrant.

Then I created...

Thank you very much. I am always thinking about writing expression or something. You show me a much easy way to do it with WHERE clause. You are great.

Regards.

Frank

thank you.

I will practice it on a test database first. Do I have to schedule a job to do the transaction log backup many times or just one time,...

Thanks.

by the way, how can I create a parameter by using something like '%xxx%'?