Search results for query: *

Madawc I tried your second suggestion and it worked like a charm! Thanks SO much. PS tried to give you a star but link wasn't working, so will try again later!

CR 9, Sybase ASA 6.0.2 Setup H1 Program H2 Client H3 Service Maximum (ActivityDate)conditional suppress (see below) H4 ActivityDate suppress Details activitydate suppress Sample Output H1 Seating H2 Joe Blow H3 OT 2005 02 02 conditional suppress (see below) H4 2005 02 02...

Nagornyi and Jim - I tried Jim's suggestion and it worked like a charm! I want to thank you both. Your assistance is much appreciated. And Nagornyi, if you want me to follow-up on your question, please let me know...

Made the modifications - now output is: detail 1 = @activitylength_countable = 1, @countable_calculation = 90 detail 2 = @activitylength_countable = 0, @countable_calculation = 90 detail 3 = @activitylength_countable = 0, @countable_calculation = 90 detail 4 = @activitylength_countable = 0...

Hi ya the #PersonId_Count is calculating as you say it should 1 1 1 2 2 2 However, the @activitylength_countable, which is: whileprintingrecords; Global NumberVar T; NumberVar P; if {#PersonId_Count}>1 then P:={#PersonId_Count}-T else P:=1; T:={#PersonId_Count}; P; is returning 1 1 1 0 0 0...

Not quite there yet...Here is an example of what I'm getting, using a different example (yes/no means whether or not the activitylength should be included in the sum) Occupational Therapy 1162465 Single Ax 113 detail 1 =masterno = 772, activitylength...

Thanks nagornyi - you've got me thinking along the right lines! I'll work with your suggestions and get back to you!

OK, so far so good. I completed steps 1 & 2 and placed both formulas in the detail section. I see results such as the following based on my example from before: Occupational Therapy 1162465 Single Ax 111 detail 1 =masterno = 771, activitylength = 60, personid...

Thanks for responding so quickly... I just tried your suggestion but not giving me correct results - I think because the personid is not sequential (although it did look that way in my example above).... And result was also not displayed if only one personid showed up in group 2 (ie., did not...

CR 9 - Sybase ASA 6.0.2 Having a difficult time finding the correct way to come up with a sum.... group 1 - ServCatDesc group 2 - AccountNo group 3 - ActivityTypeDesc group 4 - ActivityNo detail - pat.masterno (may or may not be present), activitylength (always...

Hi - think I've got it figured out - I was using not isNull instead of isNull .... ........ ( isNull ({Prog.ProgDesc}) and ( IsNull ({PatReg.ProgNo}))or (not isNull({Prog.ProgDesc}) and not ({Prog.ProgDesc} in ["Acquired Brain Injury", "Early Expressions&quot...

Thanks for the heads up Madawc - I take that to mean that I include the not isNull ({field}) before the and statement? I am still struggling with this concept. I am working on another report with the same premise, only this time I am excluding activities if they have a certain progdesc or a...

Perfect! I am an inexperienced user - had known about being aware of null values and had tried accounting for them but was using IsNull and getting way too many records back. Deep gratitude! Hours of exasperation solved in 1 minute! Enjoy your weekend...

CR 9.0/Sybase ASA 6.0.2 Table Activity LOJ to table Program.ProgDesc (to determine program name that may or may not have been selected for Activity) Table Activity also LOJ to table PatReg.ProgNo (through 2 other tables) (to determine program name patient belongs to if activity included patient)...