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

Diaplaying the field valuees for various paramter ranges

Status
Not open for further replies.

mintman

IS-IT--Management
Mar 5, 2007
66
US
Hello frinds, I have a field IDCASE, and I am doing count on that where IDSTAT> {?Parameter}..this works fine for single values.
I want to display the values for IDCASE where IDSTAT>1 in first line, then values of IDCASSE where IDSTAT>>2 in second line and so on upto 10. So that users dont have to enter the paramter values and he can see whar are the values if this is the paramter value. Any suggestions on this.
Thanks a lot,
Reed.
 
Can i use arrays instead of suing paramters? and directly show them line by line.If so can anyone give an example Waiting for your suggestions.
Thanks,
Reed.
 
Hello if you people want a better example..
Field Names
Opentks TotalUnits STO ORDERS STT ORDERS

Count(PHPCTL) Sum(PHTUTS) (Count(PHPCTL) (Count (PHPCTL)
wherePHTUTS>?P ) WHERE PHTUTS<?P)

I did running total for STO oRDERS and STT orders on field
PHPCTL and in evaluate condition i gave those where conditions.
This works really good if I enter single paramters like 1,2,3.
But Instead of this.
I want to show user without slection individually, he can see like
field field field field
for parm value=1 --- --- ---- ---
for param value=2 --- --- --- ---

son on upto 10.
I know i have to remove paramterand use arrays or something to show in this way. Can anyone suggest something on this.
Thanks a ton.
Reed
 
Hi frnds this might help you, I dont know ether this is the best idea, I created 6 separate subreports and used different condition values for the running totals that i mentioned earlier. THis works fine. But i think there is much better way to do it.
Thanks,
Reed
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top