Crystal Reports Forum : Tips and Tricks

Exporting report to excel

Tue, 08 Nov 2022 09:55:42 GMT

I have had the same issue as well. Thank you for sharing. Hopefully this will help me if I needed to perform this type of export again.

Exporting report to excel

Wed, 21 Sep 2022 04:11:09 GMT

I do not believe I have done a data only export with a sub-report. I have no idea if it will work.

I have been doing this for a very long time. I have picked up a few tips and tricks. But there are some users on this forum that make me look like a beginner.

Exporting report to excel

Tue, 20 Sep 2022 21:29:34 GMT

Just managed to get all fields including sub report in one row! Until now I have been exporting as data only xls (makes it easier with lots of columns). I just run it with straightforward xls after checking line up/size etc. again and it worked. Still doesn't work with data only export though. I will now insert the rest of my required fields (several from further sub reports) and run it again. Hopefully it will be ok now, will let you know.
Thanks for your tips and interest kevlray. It helps sometimes just to ping issues/ideas to someone else out there!

Exporting report to excel

Tue, 20 Sep 2022 03:58:12 GMT

Furthermore. You have to make sure all the fields in the main report and sub-report are the exact same height and aligned to the top of the section. Remove the border from the sub-report (if you have not done so already). Also, make sure the section is as small as possible (height of the fields).

Exporting report to excel

Mon, 19 Sep 2022 22:51:29 GMT

Thanks for your suggestions, I will keep trying. I really need to get this to work!

Exporting report to excel

Fri, 16 Sep 2022 06:55:43 GMT

Odd. I wonder why. Of course you have make sure your section height is exactly the same (Excel export is very touchy to get correct).

Exporting report to excel

Thu, 15 Sep 2022 21:41:25 GMT

Good morning, I'm afraid the underlay tick in section expert made no difference

How to stop default rounding of numbers

Wed, 14 Sep 2022 11:57:30 GMT

Are you setting the number of decimals to the max number of decimals available in the database? If so, there should be no rounding. One way around it (if it works for you), you can convert the number to a string and thus it will not round at all. If you are exporting to Excel that could be an issue.

Exporting report to excel

Wed, 14 Sep 2022 10:11:32 GMT

OK thanks for responding, I will try that in the morning!

How to stop default rounding of numbers

Wed, 14 Sep 2022 00:43:44 GMT

I have number fields having decimal values (can be of any length). I have chosen the default format of number in crystal report format field. the value of that filed is rounding to off automatically in output. Is there any way to stop rounding of the values and display the database value of type number as it is in report ?

Please help

Thanks in Advance
DDSJ