Skip to Content

Showing details of the same dimension on column level in Crystal Reports.

Hello,

I've been looking for a solution for the below case:

I am using Item Code as my main dimension and we want to put let's say 8 text boxes, each box contains Item Code and its details(Item name, bin location etc...), the specific item codes will be determined with parameters that the user will select when running the report.

Problem is we want them on column level next to each other, not in row level under each other.

I have tried duplicating my command several times, looked into creating a temp table but i haven't been successful so far.

Regards,

Ashraf

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 06, 2017 at 03:10 PM

    Right-click the detail section handle area.
    Section Expert
    Turn on the checkbox option for 'Format with Multiple Columns'

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks, i appreciate the answer but it's not what i am looking for :).

      I don't wanna just split my data into multiple columns instead of multiple rows, i wanna be able to list on column level selectively.

      For example:

      I want to select details for items A (quantity 3), B(quantity 2), E, F(quantity 4), and Z

      So the display should be like this:

      AAABBEFF
      FFZ

      With the details of each item showing below.

  • Nov 07, 2017 at 04:24 PM

    What type of database are you connecting to? Can you post the command that you're using? I may have some thoughts about how to re-write it to get what you need.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • Problem with this query is that if you suppress let's say row id 1, you suppress 1 of each item, so they all need to have even quantities and we have to set the max number manually based on duplicates:

      1	ItemCode1	ItemName1	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      2	ItemCode1	ItemName1	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      3	ItemCode1	ItemName1	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      4	ItemCode1	ItemName1	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      5	ItemCode1	ItemName1	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      6	ItemCode1	ItemName1	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      7	ItemCode1	ItemName1	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      8	ItemCode1	ItemName1	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      9	ItemCode1	ItemName1	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      10	ItemCode1	ItemName1	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      1	ItemCode2	ItemName2	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      2	ItemCode2	ItemName2	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      3	ItemCode2	ItemName2	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      4	ItemCode2	ItemName2	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      5	ItemCode2	ItemName2	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      6	ItemCode2	ItemName2	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      7	ItemCode2	ItemName2	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      8	ItemCode2	ItemName2	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      9	ItemCode2	ItemName2	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5
      10	ItemCode2	ItemName2	Bin 1, Bin 2, Bin 3, Bin 4, Bin 5