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