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.
Hello Everyone,
I'm just curious if anyone has tries ssrs reporting in maximo. We are using ontracks solution (plugin) but have some issues. For example recreating the birt reports in ssrs and also triggering the print flag once a report has been run on a certain workorder.
I'm quite new to Maximo so maybe these issues are not that serious?
Thank You,
Michael
You can run ssrs report on the Maximo database. But before going towards that path Can you explain what are u r current issues with reporting ?
Sent from my iPhone
On 25 Sep 2012, at 22:23, "dasisart" <happiestguyalive@hotmail.com> wrote:
> Hello Everyone,
>
> I'm just curious if anyone has tries ssrs reporting in maximo. We are using ontracks solution (plugin) but have some issues. For example recreating the birt reports in ssrs and also triggering the print flag once a report has been run on a certain workorder.
> I'm quite new to Maximo so maybe these issues are not that serious?
>
> Thank You,
>
> Michael
>
>
Hi,
Thank You for your response. Yes we can run reports on the database, but face a few challenges.
- first one is once printing in WOTRACK, it does not recognize the WO that is open and a value has to be entered for the WO number to print a specific report. It would be nice to print a report form the WO that you are currently on.
- We are unable to set up a direct print button on the toolbar.
We had some instructions on how to do this but unsure how to set up the security permissions, and I think that is the reason the button does not show.
- and finally it would be nice to run batch reports in maximo as well.
We can get a lot of this done running the reports off the server, but it would be nice to do it directly in Maximo UI.
Thanks for all your thoughts on this,
I'll let you know if any progress has been made in this area.
Michael
--- In MAXIMO@yahoogroups.com, mohska@... wrote:
>
> You can run ssrs report on the Maximo database. But before going towards that path Can you explain what are u r current issues with reporting ?
>
> Sent from my iPhone
>
> On 25 Sep 2012, at 22:23, "dasisart" <happiestguyalive@...> wrote:
>
> > Hello Everyone,
> >
> > I'm just curious if anyone has tries ssrs reporting in maximo. We are using ontracks solution (plugin) but have some issues. For example recreating the birt reports in ssrs and also triggering the print flag once a report has been run on a certain workorder.
> > I'm quite new to Maximo so maybe these issues are not that serious?
> >
> > Thank You,
> >
> > Michael
> >
> >
>
>
>
>
For All this you need an integration between ssrs and
MAximo, which doesn't exist
Sent from my iPhone
On 03 Oct 2012, at 22:36, "dasisart" <happiestguyalive@hotmail.com> wrote:
Hi,
we are also using On-tracks link for SSRS reports, with Maximo 7.1.1.5
Have you considered doing this the other way round, set the SSRS Workorder print to be the default WOPrint report, and use Change Status to Printed, and tick the Print Workorder flag on Change Status.
--- In MAXIMO@yahoogroups.com, mohska@... wrote:
>
> For All this you need an integration between ssrs and
> MAximo, which doesn't exist
>
>
>
> Sent from my iPhone
>
> On 03 Oct 2012, at 22:36, "dasisart" <happiestguyalive@...> wrote:
>
Hi,
We are also using On-Tracks to link to SSRS reports, on Maximo 7.1.1.5.
We have written the SQL for some of our reports to use the 'WHERE' clause passed from Maximo, including the Workorder Print - this means that they will run from the (filtered) List screen, and for Selected records.
The SQL is a bit more complicated, as you need to use the EXEC( statement ) format to achieve this. You also need to ensure that you set the correct number of quotes in the SQL, to surround your other passed parameters.
Format (for SQLServer) would be something like
==================================================================
-- Standard Parameters - ALL Maximo SSRS Reports
declare @mroSite as varchar(16)
declare @mroOrg as varchar(16)
declare @userName as varchar(25)
declare @where as varchar(max)
-- Test parameters - really passed from Maximo
set @mroOrg = 'XXX'
set @where = 'wonum in (%271234%27,%271235%27)'
-- Required LOCAL Varaiables used in Query, not supplied by Maximo
declare @MYWhere as varchar(max)
-- Required for use of passed WHERE Clause
-- doubles up the passed quotes in the WHERE clause
set @MYWhere = replace(replace(@where,'%3D','='),'%27','''')
-- test lines to show the substitution
select @where
select @MYWhere
exec ('
select
W.wonum,
W.description as wodesc,
W.location,
L.description as building
from workorder W
inner join locations L
on L.orgid = W.orgid
and L.location = W.location
where W.orgid = ''' + @mroOrg + '''
and W.istask = 0
and W.wonum in (select wonum from workorder
where istask = 0
and orgid = ''' + @mroOrg + '''
and ' + @MYWhere + ')')==================================================================
The Maximo WHERE clause (from QBE or selected records) passes field names which are not qualified with table names - hence the sub select statement. You need to link other tables in the main select statement.
The above will select Workorders 1234 & 1235 for Orgid = XXX
Change the values in the Where clause to work on your system to see results.
--- In MAXIMO@yahoogroups.com, "dasisart" <happiestguyalive@...> wrote:
>
> Hi,
>
> Thank You for your response. Yes we can run reports on the database, but face a few challenges.
> - first one is once printing in WOTRACK, it does not recognize the WO that is open and a value has to be entered for the WO number to print a specific report. It would be nice to print a report form the WO that you are currently on.
> - We are unable to set up a direct print button on the toolbar.
> We had some instructions on how to do this but unsure how to set up the security permissions, and I think that is the reason the button does not show.
> - and finally it would be nice to run batch reports in maximo as well.
>
> We can get a lot of this done running the reports off the server, but it would be nice to do it directly in Maximo UI.
>
> Thanks for all your thoughts on this,
> I'll let you know if any progress has been made in this area.
>
> Michael
>
> --- In MAXIMO@yahoogroups.com, mohska@ wrote:
> >
> > You can run ssrs report on the Maximo database. But before going towards that path Can you explain what are u r current issues with reporting ?
> >
> > Sent from my iPhone
> >
> > On 25 Sep 2012, at 22:23, "dasisart" <happiestguyalive@> wrote:
> >
> > > Hello Everyone,
> > >
> > > I'm just curious if anyone has tries ssrs reporting in maximo. We are using ontracks solution (plugin) but have some issues. For example recreating the birt reports in ssrs and also triggering the print flag once a report has been run on a certain workorder.
> > > I'm quite new to Maximo so maybe these issues are not that serious?
> > >
> > > Thank You,
> > >
> > > Michael
> > >
> > >
> >
> >
> >
> >
>