Skip to Content

Design tips for a specific client needs

Hello everyone,

I have a client who needs something specific, and I have no idea how to pull this off in Crystal Report (using Visual Studio 2017).

Report layout is as follow:

Top of the page would have a picking list (so a details section) in 2 columns. To the right of those 2 sections, I need a vertical barcode (just 1 barcode, identifying the pick list)

Bellow the picking list, the client details (like a page header section).

Then, a packing list would follow the client details (another details section).

How can I do this kind of layout??

thanks for your time and help!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 11 at 11:16 PM

    Cool. That makes it easier.

    The pick list is going to be your main report. Assuming you want to print multiple pick list/packing slip combinations at a time, do the following:

    1. Group the report by pick list number. Suppress the report header and page header sections.

    2. Put the bar code in the group header section. Right-click on it and go to "Format Field...".Go to the "Common" tab and look for "Rotation" in the middle of the page and rotate it 90 (reads bottom to top) or 270 (reads top to bottom) degrees. Make sure that the field and the section it's in are tall enough for the whole bar code to appear. Put the field at the right edge of the report.

    3. Go to the Section Expert for the group header section. Check the "Underlay Following" checkbox so that the bar code will appear to the right of your data.

    4. Go to the Section Expert for the details section. Check the "Format with Multiple Columns" checkbox. Then go to the Layout tab that will appear and set the column width and printing direction. Remember to leave space on the page for your bar code.

    You may have to play with the formatting to get everything working correctly for this part of the report.

    I'm going to assume that you want the packing slip to start on a new page.

    1. Go to the Section Expert for the group footer section. On the Paging tab, turn on New Page Before and New Page After.

    2. Put a subreport in the group footer section. Use this to connect to the Packing Slip data. The subreport link should be on whatever field relates a specific pick list to the packing slip.

    3. There are no page headers or footers in subreports. However, you can simulate a page header by creating an outer group on data that only has one value during the run of the subreport. In this case I might use the field that's in the subreport link. Go to the "Change Group Options" for this group and turn on "Repeat Group Header On Each Page". You can then put page numbers at the top of the page if you need to. There is no way to simulate a page footer, though.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11 at 10:04 PM

    no, completely different set of data

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12 at 01:20 PM

    thanks a lot for this very details answer. It's really appreciate!!! :-)

    Add comment
    10|10000 characters needed characters exceeded