Different rows on one line CR 4.6 (or vb reporter - VB6) 
Author Message
 Different rows on one line CR 4.6 (or vb reporter - VB6)

I am doing a schedule report and would like to include different rows on a single line
ie:

Name    Mon        tues              wed     etc
            start time    start time    start time
            end time      end time
  the name , day, start and end time are all one row, so Mon start time & Tues Start time are different rows from the database, but I would like them on the same line on the report

Any Thoughts?
Tia    Pat



Fri, 18 Jul 2003 22:53:45 GMT  
 Different rows on one line CR 4.6 (or vb reporter - VB6)

I don't know how to do it straight.

But with a little trick, it can be done with a crosstab.
The trick is to split every record into two recors (using joins)
to create separate entries for start time and end time.
Then we can use formulas to create just what you need.

--
Deniss Andrijevski
SKRIINING

I am doing a schedule report and would like to include different rows on a
single line
ie:

Name    Mon        tues              wed     etc
            start time    start time    start time
            end time      end time
  the name , day, start and end time are all one row, so Mon start time &
Tues Start time are different rows from the database, but I would like them
on the same line on the report

Any Thoughts?
Tia    Pat



Sat, 19 Jul 2003 23:23:41 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. CR 4.6 Fill & Line Color Question

2. Help with CR 4.6 and VB6

3. CR 4.6 + VB6 -> Setup

4. CR 4.6 VB6 question

5. vb6 cr 4.6 help

6. VB6, CR 4.6, error 20533

7. VB 6.0, Access 97, CR 4.6

8. VB 6.0, Access 97, CR 4.6

9. Using the CR 4.6 that comes with VB 5

10. VB & CR 4.6 Stored Procedure Parameters

11. CR8 upgrade to VB 6 CR 4.6 ?

12. Does CR 4.6 actually work with VB 6 ?

 

 
Powered by phpBB® Forum Software