Need Help Concatenating a field

[TanmedIT]

I have a database which contains a table "fieldval" which stores numerous data types (it wasnt my idea to create this table). Within this Table I have CR select all the records that correspond to 5 diffent vaiables (VancoCL, VancoPICC, VancoMID, VancoPeri, and PercVanco). When I run the report it returns each variable as a seperate line item, which gives 5 lines of data for every Company.. I only want one line of info per company.. Is there a way I can do this? Sorry about the explanation, since I am not too famialiar with the CR lingo.

Thanks

 

[kenhamady]

How do you want the 5 values to appear? Five Columns, or concatenated in a string? Will some have less than 5? Ken Hamady

http://www.kenhamady.com/

 

[TanmedIT]

I want them to appear on 5 columns with the Five Heading mentioned earlier. When I currently run the report it will give me five lines with one one of the columns in each lines having values and the rest zeros:

Example:

VancoCL VancoPICC VancoMID VancoPeri PercVanco
---------------------------------------------------
0 0 40 0 0
0 30 0 0 0
0 0 0 15 0
10 0 0 0 0
0 0 0 0 5


I want a report to have all the values in just one line if that is possible. Thanks!!

 

[kenhamady]

Insert a group, so that all 5 records appear between the group header and footer.

Select each of the 5 columns in turn and use Insert-Summary field to add a "Maximum" of each column for Group 1.

These will appear on the group footer, showing the 5 values. Now suppress the details and group header. The group footer will appear once per group with all 5 values Ken Hamady

http://www.kenhamady.com/

 

[TanmedIT]

OK.. I am a newbie.. Can you explain how to create a group so that all 5 records appear between the group header and footer.. Do you mean in the details section?

Also, CR doesnt allow me to use the Insert Summary feature on these formula fields.. I have to use a formula like this to get info:

shared numberVar TotalVanco;

If {Total_Vanco.Contact_Field_No} = 126 then
if NumericText ({Total_Vanco.Value}) then
TotalVanco := ToNumber ({Total_Vanco.Value}) else
TotalVanco := 0


As you can see I have to pull the values based on Field Numbers.. Shouldnt I be able to use the Inerst Summary commmand since I change it to a numeric value? I tried to use the select expert, but it returns zero records.. I am a little confused here.. Thanks in advanced!!