In fact if you export to Excel it exports the whole field width even if you have set the width to only one character, so what I do is just use the report expert to build the report (looks a mess, does anyone else wish we had what ReportSmith used to have ie an auto width function) and then...
I have had this problem also even just printing from another machine with Crystal installed. I think the problem is more to do with printable areas as defined by the relevant printer drivers, and generally inkjets have a smaller printable area hence the cut off. The solution I used was simply to...
Doh! I have found it does work but only if you export as Excel 5,7 or 8 normal NOT extended !
It also kinda ignores any formatting ie I had all the initials in a line likes AAA BBB CCC DDD and it comes across to Excel like this
AAA
BBB
CCC
DDD
But at least it comes across, thanks for your...
Is there a way when exporting a report to Excel to include the data in the subreport.
Specifically I have a report which shows a list of
Clients and I use a sub report to bring back all the salesman linked to that Client (1 to many) but show it in one line, as follows
The square brackets...
Superb, this worked perfectly! I just made a running total (count) on group 4 which only evaluates on change of group four and voila!
Excellent, keep up the good work.
Dave
Neither of these work if you have more than one group ie
Group 1
Group 2
Group 3
Group 4
summary1 summary2 etc...
I am only displaying the summaries in the 4th group (and grand totals), and when you try either of the above methods it's kinda' random as to whether it's shaded or...
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.