Detail Lines on the same line? 3

[jamiers]

I am using the report to create a htaccess file in unix... don't ask....

Detail lines presently print like this:

require user <username here>
require user <username2 here>
require user <username3 here>

where the <username here> is a different record.

I want it to print:

require user <username here>, <username2 here>
require user <username3 here>, <username4 here>
require user <username5 here>, <username6 here>

Can anyone help me with this report?? Thanks.

Jamie

 

[Eradic8or]

If you go to the report and enter page setup, you will see a tab for columns. Set this number to be 2 and it will print how you want.

Hope this is what you were looking for

Eradic8or.

 

[jamiers]

Unfortunately, that isn't exactly what I want, but thanks for the reply . What that does is:

require user <user1> require user <user4>
require user <user2> require user <user5>
require user <user3> require user <user6>


I want it to put in a comma with the field trimmed like this:

require user <user1>, <user2>, <user3>, <user4>
require user <user5>, <user6>, <user7>, <user8>
require user <user9>, <user10>, <user11>, <user12>

Anyone else like to take a stab at it?

Jamie

 

[MichaelRed]

Jamie,

Without A LOT more info, I can't give you specifics.

For a general approach, you could:

A)[tab]redo the recordsource so the data is organized in the manner you want the output. This is the traditional approach, and the way I would usually do it.

B[tab]Read the recordsource one record at a time. Set up your fields with conditional statements. Sort of IIF (Record is like 'User1' then print this date, print that data)...



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[jamiers]

I don't exactly know what this means. Let me try to describe this once more.

I have one field that I want to repeat across the printed report output. I want it to look like this:

Require User <USERNAME>, <(next record)USERNAME>
Require User <(next record)USERNAME, <(next record)USERNAME>
Require User <(next record)USERNAME, <(next record)USERNAME>
Require User <(next record)USERNAME, <(next record)USERNAME>


Right now it only prints:

Require User <USERNAME>
Require User <(next record)USERNAME>
Require User <(next record)USERNAME>
Require User <(next record)USERNAME>


Is there anyway to print it with two different records going on the same line without repeating the words &quot;Require User?&quot;

Thanks.

Jamie

 

[evalesthy]

I have a similar situation on a report where patients attend different sessions on various days. The report shows each unique day a session was attended.
For example:

Dates attended groups this week: 6/5/00, 6/7/00, 6/8/00

The first part is the field label (Dates attended...)
And the actual dates are fields from the table.

After building the appropriate recordset (dimmed here as strSQL) the following code
builds the date string (strD):

Set rst = dbs.Openrecordset(strSQL)
Do until rst.eof
If strD = &quot;&quot; then
strD = rst.Fields(&quot;SessionDate&quot
Else
strD = strD &amp; &quot;, &quot; &amp; rst.Fields(&quot;SessionDate&quot
End if
rst.MoveNext
Loop
rst.close

me.txtStringDate = strD

Adapting this concept may do what you need.