This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
It's been a year since I started this thread. Now I have to lose crys 7 and use crys 11. I still have the same problem. I did rewrite the report and that helped to at least get the data. But, the 15 minute report now takes 4 hours to run.
On a side note, I have another report I wrote from scratch in crys 11 that will run in 10 minutes and as soon as I add one supreport, the report takes an hour. I am not adding complex supreports. In this case it is to show long description. I have the link set up right. I even went into the supbreport select expert and stated the ownertable and owner column.
All I know now is that crys 7 worked quickly with subreports and crys 11 is almost unuseable with subreports.
In another post, Wes mentioned using views. No idea what those are. If you can link me to a site that explains their use, I will research it.
While writing this I took the 15 minute report and removed the subreport. The report went from four hours to less than five minutes. However, i really need the subreport stuff also :-)
Thanks all
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
>
> I'll second what Wes said, but it raises a question I've had regarding the typical background of the people who wear the title 'Maximo Admin'. I've been the 'admin' for our Maximo install for over 8 years and just started realizing the benefit of using views about 6 months ago. Why? I was the engineer who got assigned the 'Implement CMMS Software' project because I had maintenance management experience and knew how to write basic reports in Crystal. My role has been more on the functional side of Maximo. But to continue to expand the functionality we wanted out of Maximo, I needed to start expanding my technical understanding of the application - SQL, Websphere, logging, etc.
>
> So I'm curious how many of the Maximo 'admins' out there are actually from the IT world or from somewhere else? For the non-IT admins, where have you gone to learn the technical side of Maximo administration?
>
>
> BTW - I owe a lot of what I know to a bunch of you on this forum and for time you've spent sharing your knowledge and answering questions over the years. Thank you very much!
>
> --- In MAXIMO@yahoogroups.com, wwilliams@ wrote:
> >
> > You really need to try to create some views.
> > Wes Williams
> >
> >
> >
> > http://www.williamsconnell.com
> >
> >
> >
> >
> > ________________________________
> > From: "Patterson, Dennis" <dpatterson@>
> > To: MAXIMO@yahoogroups.com
> > Sent: Mon, March 28, 2011 8:40:30 PM
> > Subject: RE: [MAXIMO List] Re: Crystal reports
> >
> >
> > When I took my Crystal training, I learned the most efficient method for
> > queries/subqueries was to have only one main table in the report and
> > numerous subreports related to it. Maybe 11 tables is too many for the
> > main report?
> >
> > Dennis Patterson
> > Kemess Mine
> > ________________________________
> >
> > From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
> > Of mhenry1857
> > Sent: Friday, March 25, 2011 9:04 AM
> > To: MAXIMO@yahoogroups.com
> > Subject: [MAXIMO List] Re: Crystal reports
> >
> > 11 tables and 1 subreport using wonum as the link. I am using the Oracle
> > Server data connection. I have oracle 9.2 installed.
> >
> > --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> , "Jason
> > Verly" <jason.verly@> wrote:
> > >
> > > How complex is the report (e.g. multiple sub-reports) and what data
> > connection are you using for the new version?
> > >
> > > --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
> > "mhenry1857" <mike.henry@> wrote:
> > > >
> > > > I use Crystal Reports to get the data out of Maximo. I went from
> > Crys 7 to Crys 11 and now a 1 minute Crys 7 report can take 15-20
> > minutes and a 20 minute Crys 7 will time out in Crys 11. The report is
> > written in Crys 7 and opened in Crys 11. Can't wee why a newer version
> > would take so long. Only thing that comes to mind is to rewrite the
> > report from scratch in Crys 11 and see if it will run as fast as Crys 7.
> > Please help.
> > > >
> > >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
Regarding views: essentially, you create the SQL code that you need for
the report, give it a name, and save it on the database side. Ask your DBA
for more info .
Once you've created the view, you treat it like a table, i.e. in the report,
you would just say
Select * from {your view name}
To get the data you need.
I find views quite handy, since you can a) simplify your report code; and b)
If you need to tweak the SQL code, you can just tweak it in the view rather
than having to publish a new report version (unless you need to add new
columns to the report, of course).
Actually, come to think of it: you really need to talk to your DBA anyway -
he may have more insight into why the Crystal reports take so long to run.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
mhenry1857
Sent: March-22-12 5:11 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Crystal reports
It's been a year since I started this thread. Now I have to lose crys 7 and
use crys 11. I still have the same problem. I did rewrite the report and
that helped to at least get the data. But, the 15 minute report now takes 4
hours to run.
On a side note, I have another report I wrote from scratch in crys 11 that
will run in 10 minutes and as soon as I add one supreport, the report takes
an hour. I am not adding complex supreports. In this case it is to show long
description. I have the link set up right. I even went into the supbreport
select expert and stated the ownertable and owner column.
All I know now is that crys 7 worked quickly with subreports and crys 11 is
almost unuseable with subreports.
In another post, Wes mentioned using views. No idea what those are. If you
can link me to a site that explains their use, I will research it.
While writing this I took the 15 minute report and removed the subreport.
The report went from four hours to less than five minutes. However, i really
need the subreport stuff also :-)
Thanks all
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> , "Jason
Verly" <jason.verly@...> wrote:
>
>
> I'll second what Wes said, but it raises a question I've had regarding the
typical background of the people who wear the title 'Maximo Admin'. I've
been the 'admin' for our Maximo install for over 8 years and just started
realizing the benefit of using views about 6 months ago. Why? I was the
engineer who got assigned the 'Implement CMMS Software' project because I
had maintenance management experience and knew how to write basic reports in
Crystal. My role has been more on the functional side of Maximo. But to
continue to expand the functionality we wanted out of Maximo, I needed to
start expanding my technical understanding of the application - SQL,
Websphere, logging, etc.
>
> So I'm curious how many of the Maximo 'admins' out there are actually from
the IT world or from somewhere else? For the non-IT admins, where have you
gone to learn the technical side of Maximo administration?
>
>
> BTW - I owe a lot of what I know to a bunch of you on this forum and for
time you've spent sharing your knowledge and answering questions over the
years. Thank you very much!
>
> --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
wwilliams@ wrote:
> >
> > You really need to try to create some views.
> > Wes Williams
> >
> >
> >
> > http://www.williamsconnell.com
> >
> >
> >
> >
> > ________________________________
> > From: "Patterson, Dennis" <dpatterson@>
> > To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> > Sent: Mon, March 28, 2011 8:40:30 PM
> > Subject: RE: [MAXIMO List] Re: Crystal reports
> >
> >
> > When I took my Crystal training, I learned the most efficient method for
> > queries/subqueries was to have only one main table in the report and
> > numerous subreports related to it. Maybe 11 tables is too many for the
> > main report?
> >
> > Dennis Patterson
> > Kemess Mine
> > ________________________________
> >
> > From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
[mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf
> > Of mhenry1857
> > Sent: Friday, March 25, 2011 9:04 AM
> > To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> > Subject: [MAXIMO List] Re: Crystal reports
> >
> > 11 tables and 1 subreport using wonum as the link. I am using the Oracle
> > Server data connection. I have oracle 9.2 installed.
> >
> > --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com> , "Jason
> > Verly" <jason.verly@> wrote:
> > >
> > > How complex is the report (e.g. multiple sub-reports) and what data
> > connection are you using for the new version?
> > >
> > > --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com> ,
> > "mhenry1857" <mike.henry@> wrote:
> > > >
> > > > I use Crystal Reports to get the data out of Maximo. I went from
> > Crys 7 to Crys 11 and now a 1 minute Crys 7 report can take 15-20
> > minutes and a 20 minute Crys 7 will time out in Crys 11. The report is
> > written in Crys 7 and opened in Crys 11. Can't wee why a newer version
> > would take so long. Only thing that comes to mind is to rewrite the
> > report from scratch in Crys 11 and see if it will run as fast as Crys 7.
> > Please help.
> > > >
> > >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>