I need help formatting Crystal Reoprts 2008 Calculated members.
I have column 1, column 2 in cross tab.
then Calculated Member Variance and Calculated Member Percentage.
I would like Column 1, 2, and variance to be formatted for currency and Percent column formatted with % symbol. Any time I...
We are using .NET application to call crystal reports 2008. When Report Displays user has option of exporting report.
Default export for report format is Crystal Reports (RPT).
1) How do I change that to have Excel (97-2003) be the default?
2) How Do I set the report.rpt name in the file...
thanks that worked! one more question
step 2
if this is the group formula
if {@Type} = "M" then if {MV_TRANS_DELPHI_ALLOC_SUMMARY.SOURCE} = '0' then "Allocations" else
totext({MV_TRANS_DELPHI_ALLOC_SUMMARY.EXP_DATE}, "MMM, yyyy")
else
{@Column1}
how do I get allocations as first column...
thanks you for your quick response - I have done step one.
On step two
If {@Type} = "M" then
({MV_TRANS_DELPHI_ALLOC_SUMMARY.EXP_DATE}, "MMM, yyyy")
else
{@Column1}
I am getting an error The ) is missing error at the comma after the field.
Thanks much
this is the formula I am using for @column1 - column one is in Cross-tab
if {@Type} = "Q" then if {MV_TRANS_DELPHI_ALLOC_SUMMARY.SOURCE} = '0' then "Allocations"
else
"FY"+{MV_TRANS_DELPHI_ALLOC_SUMMARY.FISCAL_YEAR} + " " +(if month({MV_TRANS_DELPHI_ALLOC_SUMMARY.EXP_DATE}) in [10, 11, 12]...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.