"Stack" several functions into the same cell?

[roberthagan]

I have a detail section where a contact is evaluated for several types of time "compliance," e.g if this is the first attempt at contact was it done within 3 business days of a referral date. If it is after the referal month, was the client seen during the month, if not why not, etc.

I'm converting this report from Crystal. In that I broke these measures into several functions. The functions contained counters and a display message to the end user telling them which if any type of compliance standard was met. I "piled" these functions on top of one another on the detail row, so the condition that was met showed its display message. Can this be done in RS?

(I could also build one display function and pass in values from the other functions to tell it which message to display) Preferable?

 

[xlbo]

not sure what you mean by "piled" but you can use a nested IIF statement or you can concatenate strings (ie different results) with & or +....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[roberthagan]

Hi I think you pretty much answered my quetion.

By "stacked"/"piled" I meant that in Crystal it is possible to lay/overlay serveral functions over one another,

                     cell_1    cell_2    cell_3  cell_4
contact detail line: date,     type      status  functions

so that cell4 could contain several functions that evaluated the other cells, and showed different displays.
I assume that is impossible, at lest in a table layout.

 

[msflinx]

Did you try writing written your "Stacked" code in the Report Properties, Code tab and then call then procedure?

 

[roberthagan]

When I first experimented with RS that's what I di. I'm sure I'll have to do that now.

Unfortunately I have to deal first with my question about parameters

http://tek-tips.com/viewthread.cfm?qid=1275954&page=1

If I can't get the query to run, the rest is academic.

Thanks