Report builder question

Yahoo Archive
1
Todd
Any chance of getting a copy of your RB Performance Tips file off-line
?? I'm a rookie with report builder but learning fast ?

Cliff Drumeller
Information Technology Manager
Mass Precision Sheetmetal
408 954-0200 ex 217

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, July 28, 2003 3:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] report builder question


I'm shooting in the dark here but normally on any report linking orders to
jobs my master table would be JobProd. Then I would start by filtering as
much as possible on things in that table. Especially on Company even if you
have only one company that allows using indexes. I always try to use the
most detailed file I can as my master then filter it down on as many key
fields in an index as I can although there are suggestions to join form the
smallest file to the largest (# of records) as well. A lot depends on what
you can do in the filters with the indexed fields.

Mark Pladson at Epicor did a great session at the 1999 user conference
(predecessor to Perspectives) session 944 "Report Builder Performance Tips".
Perhaps you can talk some in tech support into sending a copy. I had a
report that took as long as 6 hours run in under 10 seconds after applying
all the suggestions in that session (meaning since it took all of them I had
it screwed up as bad as possible when I started). That one session has paid
for attending that year many times over. I would scan and post it in the
files section but it is copyrighted by Epicor and some US Senator would
probably want to blow up my PC.

-Todd C.

-----Original Message-----
From: Zarda, Sandy [mailto:szarda@...]
Sent: Monday, July 28, 2003 4:27 PM
To: Vantage@yahoogroups.com
Subject: [Vantage] report builder question
Importance: High


I have created a report in report builder that only uses 3 tables but takes
over a minute to generate, which is longer than I think it should take. It
contains about 10 lines in the filter, and has about 10 calculated or
aggregate fields. The tables are linked as follows: (master) JobHead,
JobOper, OrdDtl. Is it all the filters and calculations I have in it, or
something I need to relook at with the tables? Any help would be greatly
appreciated.

Sandy Zarda, Vice President
Major Industries Inc
<mailto:szarda@...> szarda@...



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



Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=170500718
3:HM/A=1652964/R=0/SIG=11t2ts2ch/*http://www.netflix.com/Default?mqso=601782
76
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=17050071
83:HM/A=1652964/R=0/SIG=11t2ts2ch/*http://www.netflix.com/Default?mqso=60178
276&partid=3170658> &partid=3170658> click here
<
http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail
/S=:HM/A=1652964/rand=216171909
<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmai
l/S=:HM/A=1652964/rand=216171909> >

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<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/ <http://docs.yahoo.com/info/terms/> > .




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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=194081.3551198.4824677.1261774/D=egroupweb/S=17050071
83:HM/A=1663535/R=0/SIG=11ps6rfef/*http://www.ediets.com/start.cfm?code=3050
4&media=atkins> click here

<http://us.adserver.yahoo.com/l?M=194081.3551198.4824677.1261774/D=egroupmai
l/S=:HM/A=1663535/rand=680010114>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<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]
2
Hey all,

Sorry if this seems elementary - I am the production planner not a report
builder guru - but I know someone here can help me. I know that report
builder can pull info from VB forms - my question is, can it pull from check
boxes and/or radio buttons on the VB forms?? For example, I want to know if
the program is ready, tooling is required, etc. If I put check boxes for
these things on the VB form at the joboper level, can I run a report builder
report that will tell me if they are checked off? TIA


Diane Rowberry
Westwood Precision, Inc.
(425) 742-7011 ex 43
(425) 353-8945 Fax
diane.rowberry@...
www.westwoodprecision.com
3
At 02:01 PM 12/11/2000 , you wrote:
>builder can pull info from VB forms - my question is, can it pull from check
>boxes and/or radio buttons on the VB forms?? For example, I want to know if

Yup. The check offs show up in the dictionary as CheckBox01 - 05. They
are logical (true / false) values, so in report builder you can choose any
two values to display (open/closed, yes/no, etc.) The radio buttons map
into text fields Character01 - 10.

-Wayne Cox
4
hi all,
i've got a quick preliminary question...i'm getting an error when trying to open report builder. we are using vantage 4.0 and the error is as follows.....

Report Builder has detected that the SQL engine has shut down due to a database error. Please save your report, exit and restart Report Builder

could this be a drive mapping problem on the workstation or is this something more serious? any help would be greatly appreciated!! thanks!!
-gary


[Non-text portions of this message have been removed]
5
In Vantage 3.00.632 I get that message (on my machine only) whenever a new client is installed somewhere in the company. What I do to fix it is:

1Edit the Report Builder.vtg file (by right-clicking the RB icon and selecting edit),
2. Then delete the double quotes( "" ) in front of Database=, ConnectionOptions=, and StartupProcedure=.
3. Then save and exit.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Gary Schmucker
To: vantage@yahoogroups.com
Sent: Tuesday, March 20, 2001 9:30 AM
Subject: [Vantage] report builder question


hi all,
i've got a quick preliminary question...i'm getting an error when trying to open report builder. we are using vantage 4.0 and the error is as follows.....

Report Builder has detected that the SQL engine has shut down due to a database error. Please save your report, exit and restart Report Builder

could this be a drive mapping problem on the workstation or is this something more serious? any help would be greatly appreciated!! thanks!!
-gary


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


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
6
At 09:30 AM 3/20/2001 , you wrote:
>i'm getting an error when trying to open report builder. we are using
>vantage 4.0 and the error is as follows.....
>Report Builder has detected that the SQL engine has shut down due to a
>database error. Please save your report, exit and restart Report Builder

Does the shortcut that you're launching it from point to a .VTG file, or
directly to the report builder .EXE? If it's the later, then you will get
that error if the startup directory is not writeable by the user. You can
change the "start in" directory to something else, like the c:\something.

-Wayne
7
I have created a report in report builder that only uses 3 tables but takes
over a minute to generate, which is longer than I think it should take. It
contains about 10 lines in the filter, and has about 10 calculated or
aggregate fields. The tables are linked as follows: (master) JobHead,
JobOper, OrdDtl. Is it all the filters and calculations I have in it, or
something I need to relook at with the tables? Any help would be greatly
appreciated.

Sandy Zarda, Vice President
Major Industries Inc
<mailto:szarda@...> szarda@...



[Non-text portions of this message have been removed]
8
What are your joined fields between tables?



[Non-text portions of this message have been removed]
9
It may be the order in which you are filtering. If JobHead is first your
filters should first filter out all conditions to minimize the source for
the next level of searching, then continue to the next table.


-----Original Message-----
From: Zarda, Sandy [mailto:szarda@...]
Sent: Monday, July 28, 2003 4:27 PM
To: Vantage@yahoogroups.com
Subject: [Vantage] report builder question
Importance: High

I have created a report in report builder that only uses 3
tables but takes over a minute to generate, which is longer than I think it
should take. It contains about 10 lines in the filter, and has about 10
calculated or aggregate fields. The tables are linked as follows: (master)
JobHead, JobOper, OrdDtl. Is it all the filters and calculations I have in
it, or something I need to relook at with the tables? Any help would be
greatly appreciated.
Sandy Zarda, Vice President
Major Industries Inc
<mailto:szarda@...
<mailto:szarda@...> > szarda@...
<mailto:szarda@...>
10
I'm shooting in the dark here but normally on any report linking orders to jobs my master table would be JobProd. Then I would start by filtering as much as possible on things in that table. Especially on Company even if you have only one company that allows using indexes. I always try to use the most detailed file I can as my master then filter it down on as many key fields in an index as I can although there are suggestions to join form the smallest file to the largest (# of records) as well. A lot depends on what you can do in the filters with the indexed fields.

Mark Pladson at Epicor did a great session at the 1999 user conference (predecessor to Perspectives) session 944 "Report Builder Performance Tips". Perhaps you can talk some in tech support into sending a copy. I had a report that took as long as 6 hours run in under 10 seconds after applying all the suggestions in that session (meaning since it took all of them I had it screwed up as bad as possible when I started). That one session has paid for attending that year many times over. I would scan and post it in the files section but it is copyrighted by Epicor and some US Senator would probably want to blow up my PC.

-Todd C.

-----Original Message-----
From: Zarda, Sandy [mailto:szarda@...]
Sent: Monday, July 28, 2003 4:27 PM
To: Vantage@yahoogroups.com
Subject: [Vantage] report builder question
Importance: High


I have created a report in report builder that only uses 3 tables but takes
over a minute to generate, which is longer than I think it should take. It
contains about 10 lines in the filter, and has about 10 calculated or
aggregate fields. The tables are linked as follows: (master) JobHead,
JobOper, OrdDtl. Is it all the filters and calculations I have in it, or
something I need to relook at with the tables? Any help would be greatly
appreciated.

Sandy Zarda, Vice President
Major Industries Inc
<mailto:szarda@...> szarda@...



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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1652964/R=0/SIG=11t2ts2ch/*http://www.netflix.com/Default?mqso=60178276&partid=3170658> click here
<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail/S=:HM/A=1652964/rand=216171909>

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]