×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Detail Lines on the same line?
3

Detail Lines on the same line?

Detail Lines on the same line?

(OP)
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

RE: Detail Lines on the same line?

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.

RE: Detail Lines on the same line?

(OP)
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

RE: Detail Lines on the same line?

Jamie,

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

For a general approach, you could:

A)    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    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

RE: Detail Lines on the same line?

(OP)
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 "Require User?"

Thanks.

Jamie

RE: Detail Lines on the same line?

2
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 = "" then
        strD = rst.Fields("SessionDate")
     Else
        strD = strD & ", " & rst.Fields("SessionDate")
     End if
     rst.MoveNext
Loop
rst.close

me.txtStringDate = strD
 
Adapting this concept may do what you need.



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close