Crystal expression help please
I am trying to convert this crystal expression into an SSRS but when i run the report i get an #Error message in my textbox. Can you help ? Crystal expression: totext(Count ({VW_RPT_CLOSING_REVENUE.INVOICENUMBER}, {VW_RPT_CLOSING_REVENUE.PROFITCENTERCODE}),0) + " INVOICES FOR " + {VW_RPT_CLOSING_REVENUE.DESCRIPTION} + " (" + {VW_RPT_CLOSING_REVENUE.PROFITCENTERCODE} + ")" SSRS Expression: = count (cstr(Fields!INVOICENUMBER.Value)+ count(Fields!PROFITCENTERCODE.Value)+ " INVOICES FOR" + Fields!DESCRIPTION.Value + " (" + Fields!PROFITCENTERCODE.Value + " )" ) FM
May 4th, 2011 2:24pm

= CStr(COUNT(CInt(Fields!INVOICENUMBER.Value))) + CStr(COUNT(CInt(Fields!PROFITCENTERCODE.Value))) + " INVOICES FOR" + Fields!DESCRIPTION.Value + " (" + Fields!PROFITCENTERCODE.Value + " )" )KG, MCTS
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2011 2:42pm

Kumar i still get the same error.FM
May 4th, 2011 2:49pm

Kumar i still get the same error. FM Never min di got it thank you for your help
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2011 2:49pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics