Skip to main content
Answer

Changing multi-column report to single, only returning every other result

  • February 25, 2023
  • 2 replies
  • 176 views

Hi all,

I’m modifying the stock Location Labels report to a format that will better fit the labels we want to use. I wasn’t smart enough to keep a print out of the original report, but it basically outputs two columns of location labels. If you haven’t seen it, think of it like this:

Location 1 Location 2
Location 3 Location 4
Location 5 Location 6

Honestly I kind of hacked and slashed the report, removing all of the objects on the right side as well as adding a barcode and some other stuff, to where it only outputs one location label per page. All of my additions and changes work, except the report still behaves as if it had the second column, and when I request a range of locations it gives me the equivalent of Location 1, Location 3, Location 5, etc. If I start the range on Location 2, it will then give me Location 4, Location 6, etc.

I’m sure there’s probably a simple answer here, but I have a case of Friday burnout and this is kicking my butt. Any help that can be provided would be greatly appreciated.

Thanks,

Matt Nelsen

Best answer by lauraj46

Hi @MattNelsen ,

The standard report looks uses the ‘next’ function to print the data from two records in one section.  The ‘VisibleExpr’ property conditionally hides every other row.  If you have deleted the second column from the report then you can blank out the VisibleExpr field or set it to True.

Hope this helps!

Laura

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • Answer
  • February 28, 2023

Hi @MattNelsen ,

The standard report looks uses the ‘next’ function to print the data from two records in one section.  The ‘VisibleExpr’ property conditionally hides every other row.  If you have deleted the second column from the report then you can blank out the VisibleExpr field or set it to True.

Hope this helps!

Laura


  • Author
  • Freshman III
  • February 28, 2023

Thank you so much Laura! That did the trick.