Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Print Repeated value with other words instead of blank leave (Reports)

Status
Not open for further replies.

koklimabc

Programmer
Jun 17, 2013
49
MY
Dear all,

I've one easier question to ask that if i want to change the repeated values with hypen("-") instead of blank for continuos printout of fields under details line of report. I know it it settings under "print when" option for fields but i've no idea on how to do it.Guide me please .Thanks.
 
I don't quite follow your question.

Could you provide an example of your data and the layout you have in mind?

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are not good for you.
 
If you want anything else but blank output for repeated values, you can't use the No option of the "print repeated values" section.
There is no really simple solution like ány setting you can set to "-" instead of space.

You have to put the current value of a record in a report variable and compare with it in the next row, like the solution Vilhel-Ion points to.

You don't need tohe on exit expression, you can also use a second variable, for which you set "value to store" to the first variable, which stores the field.
That way the second variable always is one row behind, so you can compare current with previous row and if identical (== operator) print whatever you like, eg a hyphen.

Bye, Olaf.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top