I need some help to with conversion of crystal expression to ssrs. totext(Count ({VW_RPT_CLOSING_REVENUE.INVOICENUMBER}, {VW_RPT_CLOSING_REVENUE.INVOICEDATE}, "daily"),0) + " INVOICES FOR " + GroupName ({VW_RPT_CLOSING_REVENUE.INVOICEDATE}, "daily")FM

Hi Farhan1, Based on my research on Crystal expression, I will give some suggestion about your issue. In your expression, Count function is similar to Reporting Services' Count function, here is a sample =Count(Fields!FirstName.Value,"GroupByInitial") Here "GroupByInitial" is a scope name, which could be group name or dataset name. totext function is used to integer value, just like Int function in Reporting Servcies. To GroupName, which used to get the group's name, there is no relevant function in reporting services, but you could hard code this value in your expression. Next time if you have any question about converting the crystal report to SSRS, please must make sure give the detail requirement logic or give some explanation about your requirement, as not everybody are familiar with Crystal report, so clear logic is very necessary for us convert the Crystal expression to SSRS expression. Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.