|
Home > Archive > Programming with dBASE > April 2005 > Calendar from dbase table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Calendar from dbase table
|
|
|
| I have a table of dates and events and would like to print out the info in a calendar, month and/or week. I would like the calendar to have clean lines and boxes, like MS Outlook.
I like the Dbase report writer, but have not had much luck with lines and boxes. I’m hoping someone would know about some other options for a calendar report.
For example:
- Anyone know if Crystal Reports or R&R provide any kind of a calendar shell that you can use to put a printed calendar together?
- Anyone know of an activex or other option that might help me out?
- Is there a way to send it thru MS Outlook and then print it thru Outlook?
Got to find some way to get a nice looking printout for this data.
Thanks for any help you can give,
Rick
| |
| Todd Kreuter 2005-04-15, 7:23 am |
| Rick wrote:
>
> I have a table of dates and events and would like to print out the info in a calendar, month and/or week. I would like the calendar to have clean lines and boxes, like MS Outlook.
What do you mean by clean lines?
--
Todd Kreuter [dBVIPS]
| |
|
| Hi Todd,
Sorry, should have said just lines.
I believe I could construct a calendar without any lines using the dbase report writer, but getting the lines and boxes to line up properly would take me a long time. Just have not had much luck getting lines into a dbase report to format properly around
field data. The kind of calendar I need would have lots of lines.
Admit I have not had a lot of experience with the report writer yet, tho. Maybe someone uses lots of liines in a report and can tell me what I may be missing.
Thanks,
Rick
Todd Kreuter Wrote:
> Rick wrote:
>
> What do you mean by clean lines?
>
>
> --
> Todd Kreuter [dBVIPS]
| |
| Frank J. Polan 2005-04-15, 1:23 pm |
| Rick,
I've duplicated some "preprinted" forms and created some reports with
lines & "boxes", with the Report Designer.
I generally don't use actual "boxes" - I create them with horizontal
& vertical lines.
I put all the lines on the Page Template. Usually it takes some
editing in the source editor to get everything lined up
HTH
Frank Polan
On Fri, 15 Apr 2005 13:15:43 -0400, Rick <Sportman7@netzero.net>
wrote:
>Hi Todd,
>
>Sorry, should have said just lines.
>
>I believe I could construct a calendar without any lines using the dbase report writer, but getting the lines and boxes to line up properly would take me a long time. Just have not had much luck getting lines into a dbase report to format properly aroun
d field data. The kind of calendar I need would have lots of lines.[color=darkred]
>
>Admit I have not had a lot of experience with the report writer yet, tho. Maybe someone uses lots of liines in a report and can tell me what I may be missing.
>
>Thanks,
>Rick
>
>
>Todd Kreuter Wrote:
>
| |
| Ken Mayer [dBVIPS] 2005-04-15, 8:23 pm |
| Rick wrote:
> Hi Todd,
>
> Sorry, should have said just lines.
>
> I believe I could construct a calendar without any lines using the
> dbase report writer, but getting the lines and boxes to line up
> properly would take me a long time. Just have not had much luck
> getting lines into a dbase report to format properly around field
> data. The kind of calendar I need would have lots of lines.
>
> Admit I have not had a lot of experience with the report writer yet,
> tho. Maybe someone uses lots of liines in a report and can tell me
> what I may be missing.
There are probably ways to do it. If you assume a 7 day week, copy the
data into a table that has the data laid out the way you want, so that
you have one day per column, per row ...
You could place a Shape object down and use that for the background for
each day. (Or not -- there are lots of ways of doing things ...)
A text control can be used in the same way as a shape. Or a rectangle.
Those can be a bit weird, though, suggest going with a shape.
Lots of ways to approach it.
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
|
| Hi Ken,
Yes, had planned to use Todd's tmpquery to set up the data file.
Well, I guess I'll just have to give lines and shapes (instead of boxes) another try. Just remember spending lots of time before and not getting a lot of success for some reason.
I'm setting up reports to use with kmscheduler, and just want to thank you again for your work on that great schedule code.
Thanks,
Rick
Ken Mayer [dBVIPS] Wrote:
> Rick wrote:
>
> There are probably ways to do it. If you assume a 7 day week, copy the
> data into a table that has the data laid out the way you want, so that
> you have one day per column, per row ...
>
> You could place a Shape object down and use that for the background for
> each day. (Or not -- there are lots of ways of doing things ...)
>
> A text control can be used in the same way as a shape. Or a rectangle.
> Those can be a bit weird, though, suggest going with a shape.
>
> Lots of ways to approach it.
>
> Ken
>
> --
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase
| |
|
| Frank,
Thanks Frank. Always good to know others have succeeded. Means I should be able to get it to work. Just remember speding lots of time on lines and boxes before without a lot of success. But, will have to give it another try.
Rick
Frank J. Polan Wrote:
> Rick,
>
> I've duplicated some "preprinted" forms and created some reports with
> lines & "boxes", with the Report Designer.
> I generally don't use actual "boxes" - I create them with horizontal
> & vertical lines.
> I put all the lines on the Page Template. Usually it takes some
> editing in the source editor to get everything lined up
>
> HTH
>
> Frank Polan
>
>
> On Fri, 15 Apr 2005 13:15:43 -0400, Rick <Sportman7@netzero.net>
> wrote:
>
und field data. The kind of calendar I need would have lots of lines.[color=darkred]
>
| |
| Ken Mayer [dBVIPS] 2005-04-15, 8:23 pm |
| Rick wrote:
> Hi Ken,
>
> Yes, had planned to use Todd's tmpquery to set up the data file.
>
> Well, I guess I'll just have to give lines and shapes (instead of
> boxes) another try. Just remember spending lots of time before and
> not getting a lot of success for some reason.
>
> I'm setting up reports to use with kmscheduler, and just want to
> thank you again for your work on that great schedule code.
Ah. I was wondering if that's what was up. <g> Glad you like it. That
was a fun (but weird and sometimes frustrating) project.
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
|
|
|
|
|