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

Ability to use a formula on a specified column on a crosstab 1

Status
Not open for further replies.

n2nuk

IS-IT--Management
Dec 24, 2002
190
GB
Hi there,

I am attempting to report on outcomes from a client interview, the front-end allows workers to select multiple values using a check box. the values are stored in the database as a text field concatenated by a $, for example
Advice given$Escalate to Intensive Service
Signposted$Advice given$Escalated to Health Services
Advice given$Escalate to Intensive Service
Signposted$Referral to another organisation$Advice given
Advice given$Escalate to Intensive Service
Assistance with form filling
Signposted$Advice given
Signposted$Advice given$Escalated to Health Services
Advice given$Assistance with form filling

On my column listing i am using a formula to strip out the values, foe example
InStr(( {events.outcome} ), 'Advice given' ) > 0
InStr(( {events.outcome} ), 'Signposted' ) > 0

I would like to produce a crosstab that counts the number of number of events by outcome. i am using using specified order but i am not able to use my formula to filter out the outcomes from the text file.

Any ideas how i can get around this?

Many thanks




 
Create a manual crosstab in the report footer.

Create formulas like this and place in the detail section:

If instr({events.outcome}),’Advice Given’)>0 then 1

Insert a sum on this at the report total level, and then move it next to a label “Advice Given: ” in the report footer. Repeat for other text alternatives.

-LB
 
Many thanks Lbass,

worked just i wanted it to.

Thanks again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top