How do I get a line on Date Change on a report

[richmond88]

I have a Calendar Type Report with the date down the left hand side, I hide duplicate dates. When I have a date change I would like to have a line going across the report.

How do I do this please.

Thanks

Chris

 

[Crowley16]

draw the line, and set it's visible property to false...

then somewhere in your code put:

lineName.visible = true

Crowley - as in like a Crow

 

[richmond88]

Presumably I would put that in the Detail Secvtion.

But how do I no when the date changes.

 

[ZmrAbdulla]

Hi,
Do a grouping on the date, Create a Group header(of date field),Draw a line as soon as the DateHeader starts ( on top of date textbox ).

I believe this will do the trick


Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com

 

[ZmrAbdulla]

One more update. Create a group footer and draw the line in that this is more beautiful

Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com

 

[richmond88]

Abdullah - I dont think that will work.

I have a header already that splits the data into months so that each monthe appears on a seperate page.

 

[ZmrAbdulla]

Hi,
OK Create another report...
When wizard ask you "Do you want to add any Grouping levels?"
Select your date field twice..
Click "Grouping options" button..
Select Grouping intervals First one to month and second one to Day. Rest as usual......
Now you have two grouping levels of the date field.
On the design view of the report Click the Grouping & Sorting command (View >Grouping & sorting). You can see 4 times the date field has been grouped. Click on the second one and set Group Footer = yes

You can draw the line in that footer.

Hope this helps


Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com

 

[richmond88]

Thanks Abdullah - I eventually did it another way usine the Detail_Print and Detail_Format.

On the Detail_Print I set the StoredEventDate to EventDate.

Then on the Detail_Format I Checked StoredEventDate against EventDate and if it was the same make the Line Invisible If Different make it Visible.

 

[ZmrAbdulla]

Glad that you win

Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com