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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RND()- RTotal0 in Detailsection not working

Status
Not open for further replies.

petrovlis

Programmer
Jan 15, 2002
114
NL
CRXI –GoldminePE SQL -Vista Home Premium.
I have detailsection with products(contsupref) and one company has 20 products and
other only 30 productS,other 7 products …etc etc.
I LIKE TO HAVE max 10 RANDOM PRODUCTS (for each company)
OUT OF (1 UPTO 30 PRODUCTS) DEPENDING ON
COMPANY,WITH BELOW PARAMETERS, IT DOES NOT WORK …AS YET.
-------------------------------------
Group Contsupref with contsupref field in surpressed area
---------------------------------------
I have inserted RND() formula in detailsection as below
WhilePrintingRecords;
NumberVar Array array1;
Redim array1 [10];
Local NumberVar i;
For i := 1 to 10
Step 1
Do (array1 := 1+Truncate(RND()*Count({ContSupp.CONTSUPREF})));


Also inserted in Detailsection
RTotal0
Fields to Summerize Contsupref
Evaluate on change of field
Reset:Never



Section expert: surpress formula:
WhilePrintingRecords;
NumberVar Array Array1;
not (RecordNumber = Array1)

WHAT IS WRONG ??

Thanks for help
William
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top