Hey all...
I would like to apply back ground color to alternate row so is it possible ?? how ?
ThanksSection expert, color tab, click background color formula box and enter something like
if recordnumber mod 2 = 0 then crSilver else crNoColor|||Thank you very much JaganEllis...
It works for me ...|||But when I export my report in excel sheet it gives me file without background color so how can I get same background color if I export my report in EXCEL?
Thanks|||How are you doing the export?
I believe you can choose to export just the data, or the formatting too.
Certainly works OK for me when I choose File.Export.Export Report and choose the format as the non Data only Excel option, to the application.|||I am exporting manually and what I am doing in crystal report is after previewing my report I go to File menu -> Print -> Export
And to export in Excel I have 2 options to choose from so first one Excel 8.0 (XLS) and 2nd one is Excel 8.0 (XLS) (Extended)
But in none of them I am able to export format too..|||Did you select Data only option? Dont Choose that option
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment