Field Combination (1 Viewer)

C

CosmaL

Registered User.

Local time

Today, 06:18

Joined

Jan 14, 2010

Messages

92

• Jun 15, 2018

• #1

Hello my friends!


I need your valuable help once more!


I'm trying to create a report which will contain only 2 fields:

-ID (will be the same for all records)

-Description (which will be different for each record).


Maximum records will be 5.


My question is, if there's a way to show in the report, the fields continuously in a raw (description. description. description. etc) instead of a record/raw.


Thank you in advance!!!!!!!


Best Regards,
Costas

 

Minty

AWF VIP

Local time

Today, 04:18

Joined

Jul 26, 2013

Messages

10,371

• Jun 15, 2018

• #2

I'm not sure how you would get the data stored like you describe but you need a concatenation method.

This one http://allenbrowne.com/func-concat.html is considered the standard.

 

Last edited: Jun 15, 2018

isladogs

MVP / VIP

Local time

Today, 04:18

Joined

Jan 14, 2017

Messages

18,212

• Jun 15, 2018

• #3

If I understand you correctly, you can hide repeated values for one (or more) fields. Click the field then look in the property sheet

 

jdraw

Super Moderator

Staff member

Local time

Yesterday, 23:18

Joined

Jan 23, 2006

Messages

15,378

• Jun 15, 2018

• #4

@CosmaL,

I suggest that you restate your question to remove some confusion.
This statement is confusing 9( to me at least)

-ID (will be the same for all records)

Click to expand...

Perhaps you could create a mockup of what you want as output.

 

C

CosmaL

Registered User.

Local time

Today, 06:18

Joined

Jan 14, 2010

Messages

92

• Jun 15, 2018

• #5

@jdraw
Report (subreport actually) will collect data under the same ID from the main form. Main form will have the Record ID and ID which is the same for the subform's data.



Guys,
I think it's better to leave it record by raw...

 

M

Mark_

Longboard on the internet

Local time

Yesterday, 20:18

Joined

Sep 12, 2017

Messages

2,111

• Jun 19, 2018

• #6

@ Cosmal,

What it sounds like you really want to do is format a text box on the parent with the contents of child records.

To do so, you would declare a string, loop through child records appending their [Description] to the string, then filling the text box with the contents of your string.

You would do this when you format the detail for each parent record.

Personally I'd make a function that accepts the parent ID as a parameter that returns your formatted string.

Let me know if this is getting close to what you want to have happen.

 

C

CosmaL

Registered User.

Local time

Today, 06:18

Joined

Jan 14, 2010

Messages

92

• Jul 2, 2018

• #7

@Mark


thanks!


I've tried it and the result wasn't good enough.


I kept it as a subreport.


Thank you all!