Search results for query: *

Hi - thank you! I took a further look at it and it is pulling the first 100 records every time and not randomly. RecordNumber > Count({OFFENDERS.ROOT_OFFENDER_ID})*10/100 (this is the formula I have entered in the Section Expert Details section)

Could some of this has an effect on the way its pulling? It is pulling but is now pulling all from one unit and still not changing after each refresh. {OFFENDER_BOOKINGS.ACTIVE_FLAG} = "Y" and not ({OFFENDER_EXTERNAL_MOVEMENTS.MOVEMENT_REASON_CODE} in ["INT", "RAB", "RECA"]) and...

I closed and reopened and it pulls the same data. I have SAP Crystal Reports 2016

Hi Peter :) It worked. Thank you very much!! Is there a way that when I refresh the report that it would pull a new set of 10 percent. It is currently not changing the selection upon refreshing the report.

So I have to pull say 10 percent of names randomly from a number of housing units.

I am needing to pull only a percentage of names. Needing a formula for Crystal Reports. Thanks for any help with this!!

Thanks - After I wrote the formula, my next step directions were to take the formulas and place them in a text box - one after another. With this, it lines up one after another, when I generate it, like below, which is correct. 00000000000000 0000000(13sp)...

Thanks - that worked perfectly BUT when I go to export in text, the columns are not aligned.

Thank you!! The formula now works but my columns are still not aligning. Any suggestions?

HI I am developing a Crystal Report in text format but my columns are not aligning as to the number of spaces that are to be in each field, such as the last name field is to be 13 space field size, first name is to be 10 space field size, etc. I have this as one of the formulas: stringvar...