Using SQL - multiple bit of information

[former_member568297]

Hi,

If anyone could please help

I have a table called obsdef with a field called label(string) - I also have an another table called Observe with a field called Obs_String (String).

I want to get the information out of Obs_String, I have set the label in record selection to pick out what I want so for example part1

{ObsDef.Label} in ["part1"] this works and get the desired result in Obs_String.

But

I want get two bits of information {ObsDef.Label} in ["part1","service2"] with Obs_String.

The problem is that its creating two line / multiple lines I want them in column not a row like below

Customer name	Part	Service
name 1	xyz	qrs
name 2		abc

As I have set it up I'm getting

Customer Name	Part	Service
name 1	xyz
name 1		qrs
name 2		abc

I really hope someone can point me in the right direction

Thanks

[DellSC · Accepted solution]

Try this:

1.  Group on Customer Name.

2.  Put the customer name and part number in the group header.

3.  Put the customer name and service in the details section.

4.  Go to the Section Expert and put something like the following in the Suppress formula (DO NOT check the Suppress checkbox!)

     {ObsDef.Label} = 'part1'

5.  Suppress the group footer section.

-Dell

[former_member568297]

Hi thank you for your replies,

I have linked an example CR and a screen shot

Hopefully by looking at the example you may see if I have missed information.( I know I have sorry)

We fill out an electronic assessment, in that assessment we have information that we want to get out the labels.

We have  Obsdef.Label as the Label names but have Obs_String to display the results.

Two problems if we have two labels I cannot work out how to display one line as customer has two entries – ok to display each on a different line but needs to be on one. Last problem is that the entries can be a date or text check box etc… but this is a string field.

I have put more info on the CR as we can use a function to turn the string into any field.

Message was edited by: Abhilash Kumar

[abhilash_kumar]

Hi Philippe,

Could you attach a copy of the report 'with saved data' again?

-Abhilash

[former_member568297]

Hi

Thanks for that slip up it can be found here

Regards

Philippe

[abhilash_kumar]

Hi Philippe,

Could you post some sample data as it appears in both these tables please?

Are 'part' and 'service' separate columns or values of the same field?

-Abhilash