Crystal Reports

system · May 16, 2003, 10:05am

Maybe.

If I put both sub-reports in the same section they print on top of each
other. Any thoughts?

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com

-----Original Message-----
From: Jerry Boyle [mailto:jboyle@...]
Sent: Friday, May 16, 2003 9:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports

I have a PDR in Crystal that has 2 subreports that print on the same detail
line for a job. I have no page breaks in the subs and the field is on the
job group footer line in the sub reports. I had a lot of trial and errors
with the subreport links before I got it work correctly. In several of those
I got all of one or the other of the sub reports. I'm not sure if I have
any info that could help or not. Feel free to contact me if you want.

Jerry Boyle
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
vantage 5.10.132

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Friday, May 16, 2003 8:22 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports

Thanks, but I had tried that. I think I have a problem with the design of
the report.

In both sub reports, I had a page break before the group. If I remove them
the report prints all of subreport1 and then all of subreport2. What I want
is group (by job) for subreport1 and group (by job) for subreport2 to print
on the same page. I admit I am a Crystal novice, but I am not sure I can do
what I want.

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · May 15, 2003, 8:46am

We have recently brought a second company on to our Vantage system and I'm
trying to find an elegant way of organising all our Report Builder reports
for use on the two companies.

At the moment I've had to create 2 copies of each report with filters by
company as I can't see any way of working out within RB which company the
reports should be run on. Does anyone have a more elegant way of doing this
or am I stuck with 2 copies of every report?

Paul.

This e-Mail (and any attachments) should only be read by the intended
addressee(s) and not be relied upon without subsequent written confirmation
of its contents. Concentric Controls Ltd. accepts no liability for the
consequences of any person acting on such information prior to the receipt
of such confirmation. If you are not the intended recipient, you are not
authorised to, and must not use, disclose, copy, distribute, or retain this
message, its attachments or any part thereof. Any views or opinions
expressed are those of the author and do not necessarily reflect the
opinions of Concentric Controls Ltd.

Concentric Controls Ltd. www.concentriccontrols.com
Priory Road, Aston, Birmingham B6 7LH, UK
Tel: +44 (0)121 327 1662 Fax: +44 (0)121 328 2498

system · May 15, 2003, 9:05am

Report Builder has little or no security in a multi-company environment in
Vantage that I'm aware of.

It's scary from a security stand point that if you delete the filter for
company while running the report you get access to all companies. Anyone
come up with a block for this?

Also if you setup a user to only access one company but give them access to
custom report link guess what they get all reports. So that kind of forces
you to add all reports to the menu structure and secure them that way but
you are still wide open with the company line in the filter.

Patrick Winter

-----Original Message-----
From: Paul Oliver [mailto:p.oliver@...]
Sent: Thursday, May 15, 2003 7:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder in multi-company environment

We have recently brought a second company on to our Vantage system and I'm
trying to find an elegant way of organising all our Report Builder reports
for use on the two companies.

At the moment I've had to create 2 copies of each report with filters by
company as I can't see any way of working out within RB which company the
reports should be run on. Does anyone have a more elegant way of doing this
or am I stuck with 2 copies of every report?

Paul.

This e-Mail (and any attachments) should only be read by the intended
addressee(s) and not be relied upon without subsequent written confirmation
of its contents. Concentric Controls Ltd. accepts no liability for the
consequences of any person acting on such information prior to the receipt
of such confirmation. If you are not the intended recipient, you are not
authorised to, and must not use, disclose, copy, distribute, or retain this
message, its attachments or any part thereof. Any views or opinions
expressed are those of the author and do not necessarily reflect the
opinions of Concentric Controls Ltd.

Concentric Controls Ltd. www.concentriccontrols.com
Priory Road, Aston, Birmingham B6 7LH, UK
Tel: +44 (0)121 327 1662 Fax: +44 (0)121 328 2498

------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
A Free Psychic Reading! Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/uetFAA/PhFolB/TM
---------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · May 15, 2003, 9:15am

The table UserFile contains the field CurComp which is the current company a person is logged into. But linking to it is really convoluted. It involves the table _MyConnection linking to Connect (via PID field) and then linking Connect to UserFile (via ConnectName--->UserID). Then you can link CurComp to the top "real" table you are after (what would usually be Master Table). Trying to adapt this to an existing report would be a nightmare (due to Master Table change) but for new report is might work.

I have a sample that links to OrdHead only for orders in the company you are currently logged into that I'll send off-list.
-Todd C.

-----Original Message-----
From: Paul Oliver [mailto:p.oliver@...]
Sent: Thursday, May 15, 2003 7:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder in multi-company environment

We have recently brought a second company on to our Vantage system and I'm
trying to find an elegant way of organising all our Report Builder reports
for use on the two companies.

At the moment I've had to create 2 copies of each report with filters by
company as I can't see any way of working out within RB which company the
reports should be run on. Does anyone have a more elegant way of doing this
or am I stuck with 2 copies of every report?

Paul.

This e-Mail (and any attachments) should only be read by the intended
addressee(s) and not be relied upon without subsequent written confirmation
of its contents. Concentric Controls Ltd. accepts no liability for the
consequences of any person acting on such information prior to the receipt
of such confirmation. If you are not the intended recipient, you are not
authorised to, and must not use, disclose, copy, distribute, or retain this
message, its attachments or any part thereof. Any views or opinions
expressed are those of the author and do not necessarily reflect the
opinions of Concentric Controls Ltd.

Concentric Controls Ltd. www.concentriccontrols.com
Priory Road, Aston, Birmingham B6 7LH, UK
Tel: +44 (0)121 327 1662 Fax: +44 (0)121 328 2498

Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=249982.3179269.4495679.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3179269&prop=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=249982.3179269.4495679.1261774/D=egroupmail/S=:HM/A=1524963/rand=904933528>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .

[Non-text portions of this message have been removed]

system · May 15, 2003, 9:54am

Patrick,
I haven't tried this but could you maybe link the UserID (again tough to get at) and the Company field from any table in a report to the table UserComp with an Inner join. There are only entries for companies valid for that user in UserComp so that if they changed (or added) a company filter it would not find one and return no records in the record complex. The links that control it would be out of reach by the user so RB would obey the access privileges per company.
-Todd C.

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Thursday, May 15, 2003 8:05 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder in multi-company environment

Report Builder has little or no security in a multi-company environment in
Vantage that I'm aware of.

It's scary from a security stand point that if you delete the filter for
company while running the report you get access to all companies. Anyone
come up with a block for this?

Also if you setup a user to only access one company but give them access to
custom report link guess what they get all reports. So that kind of forces
you to add all reports to the menu structure and secure them that way but
you are still wide open with the company line in the filter.

Patrick Winter

-----Original Message-----
From: Paul Oliver [mailto:p.oliver@...]
Sent: Thursday, May 15, 2003 7:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder in multi-company environment

We have recently brought a second company on to our Vantage system and I'm
trying to find an elegant way of organising all our Report Builder reports
for use on the two companies.

At the moment I've had to create 2 copies of each report with filters by
company as I can't see any way of working out within RB which company the
reports should be run on. Does anyone have a more elegant way of doing this
or am I stuck with 2 copies of every report?

Paul.

This e-Mail (and any attachments) should only be read by the intended
addressee(s) and not be relied upon without subsequent written confirmation
of its contents. Concentric Controls Ltd. accepts no liability for the
consequences of any person acting on such information prior to the receipt
of such confirmation. If you are not the intended recipient, you are not
authorised to, and must not use, disclose, copy, distribute, or retain this
message, its attachments or any part thereof. Any views or opinions
expressed are those of the author and do not necessarily reflect the
opinions of Concentric Controls Ltd.

Concentric Controls Ltd. www.concentriccontrols.com
Priory Road, Aston, Birmingham B6 7LH, UK
Tel: +44 (0)121 327 1662 Fax: +44 (0)121 328 2498

------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
A Free Psychic Reading! Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/uetFAA/PhFolB/TM
---------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1564416/R=0/*http://www.netflix.com/Default?mqso=60164797&partid=3170658>
<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail/S=:HM/A=1564416/rand=338834501>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .

[Non-text portions of this message have been removed]

system · May 15, 2003, 3:54pm

Thanks, It looks like that could help on future reports.

Patrick

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, May 15, 2003 8:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder in multi-company environment

Patrick,
I haven't tried this but could you maybe link the UserID (again tough to get
at) and the Company field from any table in a report to the table UserComp
with an Inner join. There are only entries for companies valid for that
user in UserComp so that if they changed (or added) a company filter it
would not find one and return no records in the record complex. The links
that control it would be out of reach by the user so RB would obey the
access privileges per company. -Todd C.

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Thursday, May 15, 2003 8:05 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder in multi-company environment

Report Builder has little or no security in a multi-company environment in
Vantage that I'm aware of.

It's scary from a security stand point that if you delete the filter for
company while running the report you get access to all companies. Anyone
come up with a block for this?

Also if you setup a user to only access one company but give them access to
custom report link guess what they get all reports. So that kind of forces
you to add all reports to the menu structure and secure them that way but
you are still wide open with the company line in the filter.

Patrick Winter

-----Original Message-----
From: Paul Oliver [mailto:p.oliver@...]
Sent: Thursday, May 15, 2003 7:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder in multi-company environment

We have recently brought a second company on to our Vantage system and I'm
trying to find an elegant way of organising all our Report Builder reports
for use on the two companies.

At the moment I've had to create 2 copies of each report with filters by
company as I can't see any way of working out within RB which company the
reports should be run on. Does anyone have a more elegant way of doing this
or am I stuck with 2 copies of every report?

Paul.

This e-Mail (and any attachments) should only be read by the intended
addressee(s) and not be relied upon without subsequent written confirmation
of its contents. Concentric Controls Ltd. accepts no liability for the
consequences of any person acting on such information prior to the receipt
of such confirmation. If you are not the intended recipient, you are not
authorised to, and must not use, disclose, copy, distribute, or retain this
message, its attachments or any part thereof. Any views or opinions
expressed are those of the author and do not necessarily reflect the
opinions of Concentric Controls Ltd.

Concentric Controls Ltd. www.concentriccontrols.com
Priory Road, Aston, Birmingham B6 7LH, UK
Tel: +44 (0)121 327 1662 Fax: +44 (0)121 328 2498

------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
A Free Psychic Reading! Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/uetFAA/PhFolB/TM
---------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=17050071
83:HM/A=1564416/R=0/*http://www.netflix.com/Default?mqso=60164797&partid=317
0658>

<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmai
l/S=:HM/A=1564416/rand=338834501>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

[Non-text portions of this message have been removed]

------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
A Free Psychic Reading! Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/uetFAA/PhFolB/TM
---------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · May 15, 2003, 4:40pm

I'm pounding my head against the wall here.

I have two sub reports that I want to print on the same page. I put one in
details a and the other in details b. When I print the report all the
detail a's are printed and then all detail b's.

Does any one know how I can keep them together? I know it can be done
because they are on the traveler. I set the details to "keep together" but
it does not matter.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com

system · May 15, 2003, 9:51pm

On Thu, 2003-05-15 at 16:40, Edward F. Fox, Jr. wrote:

> I'm pounding my head against the wall here.
>
> I have two sub reports that I want to print on the same page. I put one in
> details a and the other in details b. When I print the report all the
> detail a's are printed and then all detail b's.
>
> Does any one know how I can keep them together? I know it can be done
> because they are on the traveler. I set the details to "keep together" but
> it does not matter.

Edward,

I think what you are looking for is found by right-clicking on the
subreport object and checking off the 'keep object together' flag.

Good luck,
Adam Ellis
Senior Consultant - SaberLogic, LLC
Phone (330) 335-6442

system · May 16, 2003, 8:22am

Adam,

Thanks, but I had tried that. I think I have a problem with the design of
the report.

In both sub reports, I had a page break before the group. If I remove them
the report prints all of subreport1 and then all of subreport2. What I want
is group (by job) for subreport1 and group (by job) for subreport2 to print
on the same page. I admit I am a Crystal novice, but I am not sure I can do
what I want.

Have you explored Linux/Vantage options any further? I did get the client
to run on a Linux box here, but it was too slow to be used.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com

-----Original Message-----
From: Adam Ellis [mailto:AELinuxGuy@...]
Sent: Thursday, May 15, 2003 9:33 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Reports

On Thu, 2003-05-15 at 16:40, Edward F. Fox, Jr. wrote:
> I'm pounding my head against the wall here.
>
> I have two sub reports that I want to print on the same page. I put one
in
> details a and the other in details b. When I print the report all the
> detail a's are printed and then all detail b's.
>
> Does any one know how I can keep them together? I know it can be done
> because they are on the traveler. I set the details to "keep together"
but
> it does not matter.

Edward,

I think what you are looking for is found by right-clicking on the
subreport object and checking off the 'keep object together' flag.

Good luck,
Adam Ellis
Senior Consultant - SaberLogic, LLC
Phone (330) 335-6442

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · May 16, 2003, 9:54am

I have a PDR in Crystal that has 2 subreports that print on the same detail
line for a job. I have no page breaks in the subs and the field is on the
job group footer line in the sub reports. I had a lot of trial and errors
with the subreport links before I got it work correctly. In several of those
I got all of one or the other of the sub reports. I'm not sure if I have
any info that could help or not. Feel free to contact me if you want.

Jerry Boyle
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
vantage 5.10.132

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Friday, May 16, 2003 8:22 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports

Thanks, but I had tried that. I think I have a problem with the design of
the report.

In both sub reports, I had a page break before the group. If I remove them
the report prints all of subreport1 and then all of subreport2. What I want
is group (by job) for subreport1 and group (by job) for subreport2 to print
on the same page. I admit I am a Crystal novice, but I am not sure I can do
what I want.

Topic		Replies	Views
Crystal Reports problem Yahoo Archive	7	456	September 26, 2001
Crystal Sub reports Yahoo Archive	2	323	October 29, 2001
Spam Multicopies in Crystal Yahoo Archive	5	309	April 5, 2006
Crystal Subreport Yahoo Archive	1	257	May 14, 2002
I hate Crystal Reports Yahoo Archive	15	476	March 13, 2002

Crystal Reports

Related Topics