Print values From Detail Section in Footer 1

[talibm]

Hi All,

I have created a report that contains treatment information in the detail section. I would like to print this information in the group or report footer because I need to have all the treatment services appear in a table like a cross-tab report even if they are not select in the input form where the data is entered. When I attempted to place the values in the footer it only prints the last entry. I am using crystal reports XI. Below is an example of what I want to happen. When the service is selected I have a formulas that places an X in the check box, the frequency, duratiion and therapist fields are drop-down fields. The service type fields need to appear whether they are selected or not. thanks for your help as always.

talib

Service Type Frequency Duration Therapist

Assessment X 1-3 Times 1 Month Jan Jones
Case Management
Individual Counseling X 2 x week 6 Months Fred Flintstone
Group Counseling
Crisis Intervention

 

[IanWaterman]

You can probably do this by storing values in variables. But we need to know how our detailed data looks.

Please provided sample of how your data displays in Details nad what you want to see in the footer

Ian

 

[talibm]

Hello Ian,

I am attaching a pdf document. The top grid is what the detail section of the report produces. The table below that is what I am trying to create

 

[talibm]

Sorry I couldn't get the attachment uploaded. Below is the current detail section

Service Type Frequency Duration Responsible Staff/Provider
Crisis Intervention Min 1 x Week 3 Months NIXON,OPHELIA
Assessment 1-3 Sessions 2 Months Rufus Dufus
Adjunctive AOD Services As Needed 45 Days Jane Doe
Case Management 1-3 Sessions 45 Days BIXENSTINE,CATHERINE

Below is what I am trying to accomplish.

Service Type Frequency Duration Responsible Staff/Provider

X Assessment 1-3 Sessions 2 Months Rufus Dufus
X Crisis Intervention Min 1 x Week 3 Months NIXON,OPHELIA
X Case Management 1-3 Sessions 45 Days BIXENSTINE,CATHERINE
Individual Counseling
Group Counseling
Family Counseling
Urinalysis
Medical/Somatic
X Adjunctive AOD Services As Needed 45 Days Jane Doe

 

[talibm]

Hello Ian,

Cutting and pasting didn't work so well. Below is what the detail section looks like. And then below that is what I am trying to create. They both contains headings for the fields.

Service Type ------------- Frequency ------------- Duration ----------- Therapist
Diagnostic Assessment ---- 1-3 Sessions ---------- 2 months ----------- John Smith
Case Management ---------- Min 1 x Month --------- 6 months ----------- Bob Jones

Check Box with "X"if selected
Service Type ------------- Frequency ------------- Duration ----------- Therapist
X Crisis Intervention ------ Min 1 x Week ---------- 3 months ----------- Jane Smith
X Diagnostic Assessment ---- 1-3 Sessions ---------- 2 months ----------- John Smith
Individual Counseling
Group Counseling
Family Counseling
X Case Management ---------- Min 1 x Month --------- 6 months ----------- Bob Jones
Adjunctive AOD Services

I need all of the available service types to be visible in the report. The services that are entered should appear in the report with an "X" or check box next to the selected services. I apologize for my inability to get the information in a readable format. thannks for your help.

talib

 

[talibm]

Hello Ian,
How do I go about setting up variables for these fields. thanks

 

[CoSpringsGuy]

how do you want the output to look in the footer
Is the "X" a part of the field? If so, do you want the output in the footer to include the X or not?

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[IanWaterman]

YOu will need to create several formula formulae

@Reset // place this in groupheader
whileprintingrecords;

Global Stringvar CrisisX:='';
Global Stringvar Crisis:='';
Global Stringvar DiagnosticX:='';
Global Stringvar Diagnostic:='';
....repeat for each category

@Eval// place in Details
whileprintingrecords;

Global Stringvar CrisisX;
Global Stringvar Crisis;
Global Stringvar DiagnosticX;
Global Stringvar Diagnostic;
.. plus other vars

If Categoryfield = 'Crisis...' then CrisisX:='X';
If Categoryfield = 'Crisis...' then Crisis:= Frequency&' '&Duration&' '&Responsible Staff/Provider
Repeat for other categories

Create formula to display each Var
@display CrisisX
whileprintingrecords;

Global Stringvar CrisisX;

@display Crisis
whileprintingrecords;

Global Stringvar Crisis;

In Group Footer

Create text boxes holding the categories and add text as required

Each box will then look like

@display crisisX "Crisis Intervention" @display crisis

If you want Frequency Duration and therapist aligned replace &' '& in the eval formula with &Chrw(11)&
this will insert tab

Ian

 

[talibm]

Hi Ian,

Just wanted to say thanks for all your help. I used your suggestions and it is working Great! Thank you!

talib