Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Counting distinct fields in data grouping report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00521590
Message ID:
00521656
Views:
19
>I have found the solution for this thread. I used two variables with the next conditions and code:
>
> Variable Name : TotalShipments
> Val to Store :iif(tmpShipment=Invoice.Shipment,TotalShipments,TotalShipments+1)
> Init value : 0
> Reset at: End of Report
> Calculate: Nothing
>
> Variable Name : tmpShipment
> Value to Store :Invoice.Shipment
> Init value : 0
> Reset at: Invoice.Shipments
> Calculate: Nothing

Very good. Believe or not I was just working on a solution to this using two report variables also. Sorry I could not help. Give yourself the points :)
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Reply
Map
View

Click here to load this message in the networking platform