|
 |
access thread: Auto-magically Resize Reports?
Message #1 by Beth Moffitt <BethMoffitt@i...> on Wed, 28 Aug 2002 12:38:11 -0500
|
|
This is for all of you seasoned international developers of reports.
I have a database with 60+ reports set in Portrait and Landscape
presentations with paper size of 8 1/2" x 11" (standard for U.S.).
When I deploy this internationally, the users' paper size is 8" x 11 1/2"
(A4?). Just enough difference to really aggravate you.
Without touching every report object and resize page size, controls and
margins, is there an auto-magical way to change the settings for each report
object? Even through printer settings and then still, not receive the
message that "the page width extends yahda yahda yahda..."
Any input is appreciated!
Beth Moffitt
Developer
Information Network International
400 Durham Drive
Houston, TX 77007
xxx-xxx-xxxx x110
Fax: xxx-xxx-xxxx
www.iniinc.com
Message #2 by "Carnley, Dave" <dcarnley@a...> on Wed, 28 Aug 2002 13:59:47 -0500
|
|
Maybe you could write a conversion utility that modifies all the reports and
changes the margins?
or maybe your app comes with a few reams of paper free of charge LOL to
order more see the website ; )
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 12:38 PM
To: Access
Subject: [access] Auto-magically Resize Reports?
This is for all of you seasoned international developers of reports.
I have a database with 60+ reports set in Portrait and Landscape
presentations with paper size of 8 1/2" x 11" (standard for U.S.).
When I deploy this internationally, the users' paper size is 8" x 11 1/2"
(A4?). Just enough difference to really aggravate you.
Without touching every report object and resize page size, controls and
margins, is there an auto-magical way to change the settings for each report
object? Even through printer settings and then still, not receive the
message that "the page width extends yahda yahda yahda..."
Any input is appreciated!
Beth Moffitt
Developer
Information Network International
400 Durham Drive
Houston, TX 77007
xxx-xxx-xxxx x110
Fax: xxx-xxx-xxxx
www.iniinc.com
Message #3 by Beth Moffitt <BethMoffitt@i...> on Wed, 28 Aug 2002 14:10:51 -0500
|
|
LOL! Or maybe in *your* spare time you could write the conversion utility
and forward for testing?!?!? I'm too busy using wizards! :)
Buried in paper..
Beth
-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Wednesday, August 28, 2002 2:00 PM
To: Access
Subject: [access] Auto-magically Resize Reports?
Maybe you could write a conversion utility that modifies all the reports and
changes the margins?
or maybe your app comes with a few reams of paper free of charge LOL to
order more see the website ; )
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 12:38 PM
To: Access
Subject: [access] Auto-magically Resize Reports?
This is for all of you seasoned international developers of reports.
I have a database with 60+ reports set in Portrait and Landscape
presentations with paper size of 8 1/2" x 11" (standard for U.S.).
When I deploy this internationally, the users' paper size is 8" x 11 1/2"
(A4?). Just enough difference to really aggravate you.
Without touching every report object and resize page size, controls and
margins, is there an auto-magical way to change the settings for each report
object? Even through printer settings and then still, not receive the
message that "the page width extends yahda yahda yahda..."
Any input is appreciated!
Beth Moffitt
Developer
Information Network International
400 Durham Drive
Houston, TX 77007
xxx-xxx-xxxx x110
Fax: xxx-xxx-xxxx
www.iniinc.com
Message #4 by "Gerald, Rand" <RGerald@u...> on Wed, 28 Aug 2002 14:39:34 -0500
|
|
If you design all your reports to fit on an imaginary 8in x 11in sheet
with
a 1/2 in margin on each edge (report space 7in x 10in), then it should
fit
either US Std (8 1/2 x 11) . or ISO (A4) size paper. You'll just have
a
slightly larger top/bottom margin with the ISO paper or a slightly
larger
left/right margin with the US standard paper.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 12:38 PM
To: Access
Subject: [access] Auto-magically Resize Reports?
This is for all of you seasoned international developers of reports.
I have a database with 60+ reports set in Portrait and Landscape
presentations with paper size of 8 1/2" x 11" (standard for U.S.).
When I deploy this internationally, the users' paper size is 8" x 11
1/2"
(A4?). Just enough difference to really aggravate you.
Without touching every report object and resize page size, controls and
margins, is there an auto-magical way to change the settings for each
report
object? Even through printer settings and then still, not receive the
message that "the page width extends yahda yahda yahda..."
Any input is appreciated!
Beth Moffitt
Developer
Information Network International
400 Durham Drive
Houston, TX 77007
xxx-xxx-xxxx x110
Fax: xxx-xxx-xxxx
www.iniinc.com
Message #5 by Beth Moffitt <BethMoffitt@i...> on Wed, 28 Aug 2002 15:17:37 -0500
|
|
Thanks Rand, but I was looking for something that would still hold my
margin
values, just reduce the report width. Reporting is one of the areas
where
our clients want precision.
Can you believe it? :)
Beth
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Wednesday, August 28, 2002 2:40 PM
To: Access
Subject: [access] RE: Auto-magically Resize Reports?
If you design all your reports to fit on an imaginary 8in x 11in sheet
with
a 1/2 in margin on each edge (report space 7in x 10in), then it should
fit
either US Std (8 1/2 x 11) . or ISO (A4) size paper. You'll just have
a
slightly larger top/bottom margin with the ISO paper or a slightly
larger
left/right margin with the US standard paper.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 12:38 PM
To: Access
Subject: [access] Auto-magically Resize Reports?
This is for all of you seasoned international developers of reports.
I have a database with 60+ reports set in Portrait and Landscape
presentations with paper size of 8 1/2" x 11" (standard for U.S.).
When I deploy this internationally, the users' paper size is 8" x 11
1/2"
(A4?). Just enough difference to really aggravate you.
Without touching every report object and resize page size, controls and
margins, is there an auto-magical way to change the settings for each
report
object? Even through printer settings and then still, not receive the
message that "the page width extends yahda yahda yahda..."
Any input is appreciated!
Beth Moffitt
Developer
Information Network International
400 Durham Drive
Houston, TX 77007
xxx-xxx-xxxx x110
Fax: xxx-xxx-xxxx
www.iniinc.com
Message #6 by "Gerald, Rand" <RGerald@u...> on Wed, 28 Aug 2002 15:45:17 -0500
|
|
Of course I can believe it, the reports are what the clients see and
show to
their bosses.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 3:18 PM
To: Access
Subject: [access] RE: Auto-magically Resize Reports?
Thanks Rand, but I was looking for something that would still hold my
margin
values, just reduce the report width. Reporting is one of the areas
where
our clients want precision.
Can you believe it? :)
Beth
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Wednesday, August 28, 2002 2:40 PM
To: Access
Subject: [access] RE: Auto-magically Resize Reports?
If you design all your reports to fit on an imaginary 8in x 11in sheet
with
a 1/2 in margin on each edge (report space 7in x 10in), then it should
fit
either US Std (8 1/2 x 11) . or ISO (A4) size paper. You'll just have
a
slightly larger top/bottom margin with the ISO paper or a slightly
larger
left/right margin with the US standard paper.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 12:38 PM
To: Access
Subject: [access] Auto-magically Resize Reports?
This is for all of you seasoned international developers of reports.
I have a database with 60+ reports set in Portrait and Landscape
presentations with paper size of 8 1/2" x 11" (standard for U.S.).
When I deploy this internationally, the users' paper size is 8" x 11
1/2"
(A4?). Just enough difference to really aggravate you.
Without touching every report object and resize page size, controls and
margins, is there an auto-magical way to change the settings for each
report
object? Even through printer settings and then still, not receive the
message that "the page width extends yahda yahda yahda..."
Any input is appreciated!
Beth Moffitt
Developer
Information Network International
400 Durham Drive
Houston, TX 77007
xxx-xxx-xxxx x110
Fax: xxx-xxx-xxxx
www.iniinc.com
Message #7 by "Gerald, Rand" <RGerald@u...> on Wed, 28 Aug 2002 15:59:45 -0500
|
|
The problem is that you have to deal with many individual objects
within the
report. Many of them will have to be resized and/or relocated in the
process. There is no EASY way to do it.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 3:18 PM
To: Access
Subject: [access] RE: Auto-magically Resize Reports?
Thanks Rand, but I was looking for something that would still hold my
margin
values, just reduce the report width. Reporting is one of the areas
where
our clients want precision.
Can you believe it? :)
Beth
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Wednesday, August 28, 2002 2:40 PM
To: Access
Subject: [access] RE: Auto-magically Resize Reports?
If you design all your reports to fit on an imaginary 8in x 11in sheet
with
a 1/2 in margin on each edge (report space 7in x 10in), then it should
fit
either US Std (8 1/2 x 11) . or ISO (A4) size paper. You'll just have
a
slightly larger top/bottom margin with the ISO paper or a slightly
larger
left/right margin with the US standard paper.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 12:38 PM
To: Access
Subject: [access] Auto-magically Resize Reports?
This is for all of you seasoned international developers of reports.
I have a database with 60+ reports set in Portrait and Landscape
presentations with paper size of 8 1/2" x 11" (standard for U.S.).
When I deploy this internationally, the users' paper size is 8" x 11
1/2"
(A4?). Just enough difference to really aggravate you.
Without touching every report object and resize page size, controls and
margins, is there an auto-magical way to change the settings for each
report
object? Even through printer settings and then still, not receive the
message that "the page width extends yahda yahda yahda..."
Any input is appreciated!
Beth Moffitt
Developer
Information Network International
400 Durham Drive
Houston, TX 77007
xxx-xxx-xxxx x110
Fax: xxx-xxx-xxxx
www.iniinc.com
Message #8 by Beth Moffitt <BethMoffitt@i...> on Thu, 29 Aug 2002 08:49:34 -0500
|
|
Exactly. That's my dilemma, the objects, as well as margins and paper
size.
*sigh* Looks like overtime for someone! :)
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Wednesday, August 28, 2002 4:00 PM
To: Access
Subject: [access] RE: Auto-magically Resize Reports?
Importance: High
The problem is that you have to deal with many individual objects
within the
report. Many of them will have to be resized and/or relocated in the
process. There is no EASY way to do it.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 3:18 PM
To: Access
Subject: [access] RE: Auto-magically Resize Reports?
Thanks Rand, but I was looking for something that would still hold my
margin
values, just reduce the report width. Reporting is one of the areas
where
our clients want precision.
Can you believe it? :)
Beth
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Wednesday, August 28, 2002 2:40 PM
To: Access
Subject: [access] RE: Auto-magically Resize Reports?
If you design all your reports to fit on an imaginary 8in x 11in sheet
with
a 1/2 in margin on each edge (report space 7in x 10in), then it should
fit
either US Std (8 1/2 x 11) . or ISO (A4) size paper. You'll just have
a
slightly larger top/bottom margin with the ISO paper or a slightly
larger
left/right margin with the US standard paper.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 12:38 PM
To: Access
Subject: [access] Auto-magically Resize Reports?
This is for all of you seasoned international developers of reports.
I have a database with 60+ reports set in Portrait and Landscape
presentations with paper size of 8 1/2" x 11" (standard for U.S.).
When I deploy this internationally, the users' paper size is 8" x 11
1/2"
(A4?). Just enough difference to really aggravate you.
Without touching every report object and resize page size, controls and
margins, is there an auto-magical way to change the settings for each
report
object? Even through printer settings and then still, not receive the
message that "the page width extends yahda yahda yahda..."
Any input is appreciated!
Beth Moffitt
Developer
Information Network International
400 Durham Drive
Houston, TX 77007
xxx-xxx-xxxx x110
Fax: xxx-xxx-xxxx
www.iniinc.com
Message #9 by "David Chapman" <luckychap@b...> on Sat, 31 Aug 2002 05:42:28 +0930
|
|
I have created dynamic reports in code, as described in the Access97
developers handbook. I had to do this because the number of columns is never
known. It works great, but requires a lot of time and effort to get it
right. I copy a template, (which is an existing partial report). If I had to
create reports for different sized papers I would investigate dynamic
reports and templates again; but only after failing to find an easier
solution on every access forum in the universe.
David
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Thursday, 29 August 2002 6:30 AM
To: Access
Subject: [access] RE: Auto-magically Resize Reports?
Importance: High
The problem is that you have to deal with many individual objects within the
report. Many of them will have to be resized and/or relocated in the
process. There is no EASY way to do it.
Rand E Gerald
Database Specialist
Information Services / Operations
Bahá'í National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 3:18 PM
To: Access
Subject: [access] RE: Auto-magically Resize Reports?
Thanks Rand, but I was looking for something that would still hold my margin
values, just reduce the report width. Reporting is one of the areas where
our clients want precision.
Can you believe it? :)
Beth
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Wednesday, August 28, 2002 2:40 PM
To: Access
Subject: [access] RE: Auto-magically Resize Reports?
If you design all your reports to fit on an imaginary 8in x 11in sheet with
a 1/2 in margin on each edge (report space 7in x 10in), then it should fit
either US Std (8 1/2 x 11) . or ISO (A4) size paper. You'll just have a
slightly larger top/bottom margin with the ISO paper or a slightly larger
left/right margin with the US standard paper.
Rand E Gerald
Database Specialist
Information Services / Operations
Bahá'í National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Beth Moffitt [mailto:BethMoffitt@i...]
Sent: Wednesday, August 28, 2002 12:38 PM
To: Access
Subject: [access] Auto-magically Resize Reports?
This is for all of you seasoned international developers of reports.
I have a database with 60+ reports set in Portrait and Landscape
presentations with paper size of 8 1/2" x 11" (standard for U.S.).
When I deploy this internationally, the users' paper size is 8" x 11 1/2"
(A4?). Just enough difference to really aggravate you.
Without touching every report object and resize page size, controls and
margins, is there an auto-magical way to change the settings for each report
object? Even through printer settings and then still, not receive the
message that "the page width extends yahda yahda yahda..."
Any input is appreciated!
Beth Moffitt
Developer
Information Network International
400 Durham Drive
Houston, TX 77007
xxx-xxx-xxxx x110
Fax: xxx-xxx-xxxx
www.iniinc.com
|
|
|
View Cart
