Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Column heading alignment off 1
- Thread starter josephwc
- Start date
-
1
- #2
synapsevampire
Programmer
They are different products, so you should expect differences.
Ordering is different...perhaps you should elaborate and state specifcs.
My trick for providing Excel exports is to create a secondary details section with the columns closely dumped alongside each other, and use a parameter to conditionally suppress this section (or all others) when an export to Excel is required.
This resolves across all versions, and should prove effective in all future versions as well.
-k
Ordering is different...perhaps you should elaborate and state specifcs.
My trick for providing Excel exports is to create a secondary details section with the columns closely dumped alongside each other, and use a parameter to conditionally suppress this section (or all others) when an export to Excel is required.
This resolves across all versions, and should prove effective in all future versions as well.
-k
- Thread starter
- #3
What if the headings are not directly associated with the fields in the detail section and you need the headings that are manually entered in.
Headings Jan2006 Feb2006 Mar2006 Apr2006 May2006
details month1 month2 month3 month4 month5
Month headings created by a formula showing Current Month/Year, Current month/year + 1, etc...
The "typical" excel export in Crystal Reports 11 lines the column headings up with the detail fields.
Crystal Enterprise 9 pulls the headings to the far left and pushes the headings that preceeded the Date headings to the right.
Headings Jan2006 Feb2006 Mar2006 Apr2006 May2006
details month1 month2 month3 month4 month5
Month headings created by a formula showing Current Month/Year, Current month/year + 1, etc...
The "typical" excel export in Crystal Reports 11 lines the column headings up with the detail fields.
Crystal Enterprise 9 pulls the headings to the far left and pushes the headings that preceeded the Date headings to the right.
synapsevampire
Programmer
Probably the result of differnet export DLLs, AND a different printer driver.
Windows WYSIWYG is based on the current printer installed, so make sure that they are the same.
I don't understand how your example of month names and monthly data isn't related??? And I assume that these are page headers?
Anyway, I offered a solution which you seem to have ignored.
Whether headings are manually entered in (this is impossible, I assume that you mean that they are based on parameter(s), has nothing to do with this, just create a export details section where everything is alongside each other, that way they get a nice data dump if they just want data.
If you want to emulate the report in the Excel export, then make sure that everyting is the same during development, which might be impossible since you develop in a new product and run in an older product.
-k
-k
Windows WYSIWYG is based on the current printer installed, so make sure that they are the same.
I don't understand how your example of month names and monthly data isn't related??? And I assume that these are page headers?
Anyway, I offered a solution which you seem to have ignored.
Whether headings are manually entered in (this is impossible, I assume that you mean that they are based on parameter(s), has nothing to do with this, just create a export details section where everything is alongside each other, that way they get a nice data dump if they just want data.
If you want to emulate the report in the Excel export, then make sure that everyting is the same during development, which might be impossible since you develop in a new product and run in an older product.
-k
-k
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question