Skip to main content
Solved

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


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

View original
Did this topic help you find an answer to your question?

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 502 replies
  • 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
  • 4 replies
  • February 28, 2023

Thank you so much Laura! That did the trick.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings