Excel (data only) Display Strings fail 2

[rbescos]

I have a few fields that are edited with a display string. The report looks fine when I preview it. When I try to export it to Excel (data only), the display formula fails. Am I missing a setting or does this not work with Excel (data only)? Here is one of the formulas I'm using.

if {BBT.Reside Type} = "Primary" then "1" else if {BBT.Reside Type} = "Secondary" then "2" else "3"

When I export I get "Primary" and "Secondary"

Thank you in advance,
Robert

 

[lbass]

I see that the display string does not appear in the data only export, but if you use the regular Excel export it does. I have no explanation or fix, other than to use the regular export.

-LB

 

[rbescos]

When I use the regular report I get an extra blank row between all my data rows. I haven't been able to figure out how to align the fields to eliminate this. I was able to eliminate the extra columns by aligning the lefts in the details and headers.

 

[lbass]

You need to format all fields to be the same height (select all section objects->format objects->make same size->height) and then right above make same size, set align: bottoms. All fields should be attached to both vertical and horizontal guidelines, with neighboring fields sharing the same vertical guideline. Once attached to the horizontal guideline, move the fields to the top of the section and then bring the bottom border up to snug against the bottom of the fields.

-LB

 

[rbescos]

It took a while with 85 feilds but I finally got it done.

Thank you very much for your assistance. It was greatly appreciated.

Have a great weekend!!

Robert

 

[lbass]

I hope you took advantage of the feature where you right click on the gray area to the left of the section containing your fields->select all section objects--and then you can format all simultaneously--at least for sizing and aligning them. You can then attach all to a horizontal guideline. The vertical guidelines would have taken more effort with many fields though.

-LB

 

[TeyBrady]

If you create a formula field and drop it on the report it will export. Try that instead of changing the display properties of the field.

 

[rbescos]

TeyBrady,

Thanks for the tip. I'll try it on my next report I need to get done next week. This should allow me to export data only without having to worry about alignments so much.

Robert