Crystal Reports Forum : Talk with the Author http://www.crystalreportsbook.com/forum This is an XML content feed of; Crystal Reports Forum : Talk with the Author : Last 10 Posts Sat, 14 Mar 2026 16:43:16 +0000 Tue, 13 Sep 2022 12:28:25 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 8.04 30 www.crystalreportsbook.com/forum/RSS_topic_feed.asp?FID=4 Talk with the Author : Report Design http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22896&PID=75335#75335 Author: hilfy
Subject: Report Design
Posted: 13 Sep 2022 at 12:28pm

Looking at this, it appears that you want one set of columns for the DR values and another for the CR values. If that's correct, here's what you'll need to do:

1. In the main report, add something like the following to the Select Expert: And {MyTable.DR} > 0

2. If you don't have a group in the report, group on something that has a single value throughout the report. Frequently, I'll create a formula that just calls CurrentDate and use it for this. The point is that we need a group header section for the subreport that I describe below.

3. Insert an additional group header section below the first one and put the column headers for your data in it.

5. Create a subreport that has the same data and Select Expert criteria as the main report but replace the reference to {MyTable.DR} with {MyTable.CR} and put the subreport in the first group header section to the right of the columns you've already configured. If you're using parameters in the Select Expert, be sure to create them in the subreport as well. Put the second set of columns in the subreport.   

6. Link the subreport to the main report based on the parameters - For each parameter you move to the top-right of the screen, select the corresponding parameter in the drop-down in the bottom left of the screen. This should automatically uncheck the "Select data in subreport based on field" checkbox, which is ok. This will make sure that you only get prompted for each parameter once.

7. Go to the Section Expert for the section where the subreport is located. Turn on "Underlay Following".

-Dell]]> Tue, 13 Sep 2022 12:28:25 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22896&PID=75335#75335 Talk with the Author : Report Design http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22896&PID=74960#74960 Author: kevlray
Subject: Report Design
Posted: 09 Sep 2020 at 4:38am

So you want two columns?  Setting columns is slightly different depending on the version of Crystal Reports. For Crystal Reports 2016,   In the Section Expert for the details.  There is a check box for Format with Multiple Columns.  When you check that box, a new tab appears in the Section Expert called Layout, from there you can adjust the size of the columns.
]]> Wed, 09 Sep 2020 04:38:47 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22896&PID=74960#74960 Talk with the Author : Report Design http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22896&PID=74959#74959 Author: shafiq
Subject: Report Design
Posted: 09 Sep 2020 at 1:49am

my table data are below

Head Dr Cr
1010 100 0
1011 200 0
1012 100 0
1013 0   200
1014 300 0
1015 0   100
1016 0   60

but i want to a crystal report design like as below

Head Dr    Head   Cr
1010 100   1013   200
1011 200   1015   100
1012 100   1016   60
1014 300

can any help??




Edited by shafiq - 09 Sep 2020 at 1:49am]]> Wed, 09 Sep 2020 01:49:13 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22896&PID=74959#74959 Talk with the Author : Custom Page Numbering http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22536&PID=74275#74275 Author: bhanson
Subject: Custom Page Numbering
Posted: 07 Nov 2018 at 12:17am

Originally posted by hilfy

Here's what I would do:

1. For the label in header or footer, place a text block in the report and type in "Page of 10". Then drag "Page Number" from the Special Fields in the Field Explorer to the appropriate spot in the text block. It will embed itself into the text if you do this correctly.

2. If the page number is in a section by itself, open the Section Expert. Otherwise right-click on the text block and select "Format Text...". In either case, click on the formula button to the right of "Suppress" (DO NOT check the Suppress checkbox!). Add this to the suppress formula:

PageNumber > 10

Save the his secret obsession book formula.

This will suppress the display of the page number block when you're on pages that are past the 10th page.

-Dell


Thanks for the detailed guidelines. It really helped. Thank you!

Edited by bhanson - 05 Oct 2019 at 11:39am]]> Wed, 07 Nov 2018 00:17:40 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22536&PID=74275#74275 Talk with the Author : Custom Page Numbering http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22536&PID=73719#73719 Author: hilfy
Subject: Custom Page Numbering
Posted: 08 Feb 2018 at 6:56am

Here's what I would do:

1. For the label in header or footer, place a text block in the report and type in "Page of 10". Then drag "Page Number" from the Special Fields in the Field Explorer to the appropriate spot in the text block. It will embed itself into the text if you do this correctly.

2. If the page number is in a section by itself, open the Section Expert. Otherwise right-click on the text block and select "Format Text...". In either case, click on the formula button to the right of "Suppress" (DO NOT check the Suppress checkbox!). Add this to the suppress formula:

PageNumber > 10

Save the formula.

This will suppress the display of the page number block when you're on pages that are past the 10th page.

-Dell]]> Thu, 08 Feb 2018 06:56:39 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22536&PID=73719#73719 Talk with the Author : Custom Page Numbering http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22536&PID=73697#73697 Author: Becantor
Subject: Custom Page Numbering
Posted: 02 Feb 2018 at 7:52am

Hi,

Have a report that is just a single report (no embedded sub reports).

The report may be anywhere from 10-15 pages depending on add on pages, however, I would like the page counter to 'ignore' these additional pages and only have a hard page counter from 1 to 10.

So, even if the report is 15 pages, I want the page counter to read 'Page 1 of 10, Page 2 of 10, etc. Once it reaches page 10 of 10 it would be suppressed.

Any ideas on how to hard code the page number range?

thanks
]]> Fri, 02 Feb 2018 07:52:26 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22536&PID=73697#73697 Talk with the Author : Setting PrintToPrinter to Mirror image layout http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22463&PID=73420#73420 Author: hilfy
Subject: Setting PrintToPrinter to Mirror image layout
Posted: 26 Sep 2017 at 7:56am

There is no way to mirror the image automatically. Instead, you would have to do something like this:

1. Add two copies of the image to the report - one is the image and one is its mirror.

2. For the image, right-click, select "Format Image..." and click on the button to the right of the Suppress checkbox (DO NOT check the checkbox!). Enter the following:

PageNumber mod 2 = 0

3. For the mirrored image do the same thing except the suppression formula is:

PageNumber mod 2 = 1

4. Align the top right of the images so that one is on top of the other.

-Dell]]> Tue, 26 Sep 2017 07:56:33 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22463&PID=73420#73420 Talk with the Author : Setting PrintToPrinter to Mirror image layout http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22463&PID=73415#73415 Author: lecntp
Subject: Setting PrintToPrinter to Mirror image layout
Posted: 26 Sep 2017 at 4:21am

Hi you,
I use crystal report version 13-0-20 for Visual Studio to design a report. I use PrintToPrinter funciton to print report. But I can not print with option Mirror Image layout on any Printer. It only print without Mirror.
Can you help me!
Thanks you very much.

Here my file:
http://www.mediafire.com/file/fcm01j7pnc8qj1j/PrintReport.rar

The mirror image option like below:
]]> Tue, 26 Sep 2017 04:21:24 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22463&PID=73415#73415 Talk with the Author : Parameterizing Crystal Report http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21551&PID=71308#71308 Author: Vimal Nair
Subject: Parameterizing Crystal Report
Posted: 23 Feb 2016 at 5:29pm

Create a parameter for user and date and make user as optional parameter. If you need a particular user for all date range you can filter by using user parameter. And for improvement purpose you can take the report according to alphabetical order. This might require multiple scheduling of the report but still you will get an output. If it has to be run reccuring create a report and create run schedule with user parameter.
 
User parameter will be like User Like 'A', User like 'B'. etc
]]> Tue, 23 Feb 2016 17:29:53 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21551&PID=71308#71308 Talk with the Author : CR Version 13 VS 2013 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21754&PID=70890#70890 Author: Rbassman98003
Subject: CR Version 13 VS 2013
Posted: 29 Oct 2015 at 1:02pm

I don't know for sure how to ask this question so I'm just going to throw it out there. The report page I have built with CR is printing with a "frame" around it. The program was originally in VS 2003 and worked perfect. When I upgraded to VS 2013 the page changed had a Main Report tab up at the top and a group tree top left. I got rid of those but cannot get rid of this "frame". Anybody have/had this problem?? Thanks ]]> Thu, 29 Oct 2015 13:02:51 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21754&PID=70890#70890