By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,480 Members | 755 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,480 IT Pros & Developers. It's quick & easy.

Implementing a calendar report

P: n/a
In one of my apps, I developed a calendar report composed of a 6x7
grid of subreports, one for each potential day in a month (the worst
case scenario is that a month spans 6 weeks, like July 2005).

The report logic works fine and the report can be printed when the
front-end and back-end both reside on my hard drive. In a live
environment however, when the back-end resides on a network drive, the
report doesn't get printed. It *appears* to spool to the printer but
never reaches the printer nor results in any sort of error message.

Does anyone have any idea which system resources are at the root of my
problems? What do I not have enough of? (Easy now!)

Or perhaps there is a less CPU-intensive way to generate a calendar?

Chuck
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Chuck Van Den Corput wrote:
In one of my apps, I developed a calendar report composed of a 6x7
grid of subreports, one for each potential day in a month (the worst
case scenario is that a month spans 6 weeks, like July 2005).

The report logic works fine and the report can be printed when the
front-end and back-end both reside on my hard drive. In a live
environment however, when the back-end resides on a network drive, the
report doesn't get printed. It *appears* to spool to the printer but
never reaches the printer nor results in any sort of error message.

Does anyone have any idea which system resources are at the root of my
problems? What do I not have enough of? (Easy now!)

Or perhaps there is a less CPU-intensive way to generate a calendar?


I think that depends. 8)

You have 42 sub-reports - do you have a routine that makes each grid
visible/invisible (you'd only need this for the sub reports on the first
line and last two lines of the "grid")? Does this or another routine
assign a date value to each subreport? That's how I'd do it (it's how I
run a little mini date picker calendar that doesn't rely on any 3rd
party calendar controls) and I don't see that creating a problem in the
environment you describe.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #2

P: n/a
On Wed, 08 Jun 2005 22:41:23 -0230, Tim Marshall
<TI****@PurplePandaChasers.Moertherium> wrote:
Chuck Van Den Corput wrote:
In one of my apps, I developed a calendar report composed of a 6x7
grid of subreports, one for each potential day in a month (the worst
case scenario is that a month spans 6 weeks, like July 2005).

The report logic works fine and the report can be printed when the
front-end and back-end both reside on my hard drive. In a live
environment however, when the back-end resides on a network drive, the
report doesn't get printed. It *appears* to spool to the printer but
never reaches the printer nor results in any sort of error message.

Does anyone have any idea which system resources are at the root of my
problems? What do I not have enough of? (Easy now!)

Or perhaps there is a less CPU-intensive way to generate a calendar?


I think that depends. 8)

You have 42 sub-reports - do you have a routine that makes each grid
visible/invisible (you'd only need this for the sub reports on the first
line and last two lines of the "grid")? Does this or another routine
assign a date value to each subreport? That's how I'd do it (it's how I
run a little mini date picker calendar that doesn't rely on any 3rd
party calendar controls) and I don't see that creating a problem in the
environment you describe.


Tim, I am probably implementing my calendar similarly to what you have
described. 42 sub-reports all drawing on a prepopulated temporary
table with daily events with a "day number key" from 1 to 42.

As I mentioned, generating the report, even in a network environment,
is not the problem. The problem comes when the users attempt to print
that report. Presumably Access goes through its report generation
logic one more time, as is its wont, but somehow the resultant report
never quite reaches the printer. And that's where I am lost. Where in
the path from Access to the printer does this transmission die?

Chuck
Nov 13 '05 #3

P: n/a
Chuck Van Den Corput wrote:
And that's where I am lost. Where in
the path from Access to the printer does this transmission die?


Bizarre. Mind you, I've never done a report with so many subreports,
either. Don't know if that has anything to do with it, but I'm lost,
sorry. Anyone else?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.