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.
Hi guys: is there any way to set up a BIRT report to behave like the Direct Print (i.e. automatically output to PDF) but instead, ask the user where to save it?
This would be very useful for POPRINT, for instance.
Shannon
My coworker figured out how to get reports to bypass the birt viewer and go
straight to PDF, it doesn't automatically bring up the save dialog but this
is only one click of the save button... if you are interested I can find out
the details from him. He is out this week.
Kevin Wertz
Grifols, Inc
Clayton NC
On Wed, Sep 7, 2011 at 6:16 PM, shannonrotz <shannonrotz@yahoo.ca> wrote:
> **
>
>
> Hi guys: is there any way to set up a BIRT report to behave like the Direct
> Print (i.e. automatically output to PDF) but instead, ask the user where to
> save it?
>
> This would be very useful for POPRINT, for instance.
>
> Shannon
>
>
>
Hi,
We anxiously await the return of the wizard!
Dave Bone
--- In MAXIMO@yahoogroups.com, Kevin Wertz <wertzee@...> wrote:
>
> My coworker figured out how to get reports to bypass the birt viewer and go
> straight to PDF, it doesn't automatically bring up the save dialog but this
> is only one click of the save button... if you are interested I can find out
> the details from him. He is out this week.
>
> Kevin Wertz
> Grifols, Inc
> Clayton NC
>
> On Wed, Sep 7, 2011 at 6:16 PM, shannonrotz <shannonrotz@...> wrote:
>
> > **
> >
> >
> > Hi guys: is there any way to set up a BIRT report to behave like the Direct
> > Print (i.e. automatically output to PDF) but instead, ask the user where to
> > save it?
> >
> > This would be very useful for POPRINT, for instance.
> >
> > Shannon
> >
> >
> >
>
>
>
>
Hey guys, we haven't forgotten about this, my colleague Patrick is awaiting
acceptance into the group.
KW
On Thu, Sep 8, 2011 at 11:40 AM, in2data <in2data@yahoo.com> wrote:
> **
>
>
> Hi,
>
> We anxiously await the return of the wizard!
>
> Dave Bone
>
>
> --- In MAXIMO@yahoogroups.com, Kevin Wertz <wertzee@...> wrote:
> >
> > My coworker figured out how to get reports to bypass the birt viewer and
> go
> > straight to PDF, it doesn't automatically bring up the save dialog but
> this
> > is only one click of the save button... if you are interested I can find
> out
> > the details from him. He is out this week.
> >
> > Kevin Wertz
> > Grifols, Inc
> > Clayton NC
> >
> > On Wed, Sep 7, 2011 at 6:16 PM, shannonrotz <shannonrotz@...> wrote:
> >
> > > **
> > >
> > >
> > > Hi guys: is there any way to set up a BIRT report to behave like the
> Direct
> > > Print (i.e. automatically output to PDF) but instead, ask the user
> where to
> > > save it?
> > >
> > > This would be very useful for POPRINT, for instance.
> > >
> > > Shannon
> > >
> > >
> > >
> >
> >
> >
> >
>
>
>
Hello Kevin,
We too have the same requirement but except for Direct Print reports,
for all other reports of every application we would like to bypass birt viewer and automatically output to PDF and from there user will print.
our environment
Maximo 7.1.1.8
Websphere 7.0
Birt 2.3
oracle 10g
regards
--- In MAXIMO@yahoogroups.com, Kevin Wertz <wertzee@...> wrote:
>
> Hey guys, we haven't forgotten about this, my colleague Patrick is awaiting
> acceptance into the group.
>
> KW
>
> On Thu, Sep 8, 2011 at 11:40 AM, in2data <in2data@...> wrote:
>
> > **
> >
> >
> > Hi,
> >
> > We anxiously await the return of the wizard!
> >
> > Dave Bone
> >
> >
> > --- In MAXIMO@yahoogroups.com, Kevin Wertz <wertzee@> wrote:
> > >
> > > My coworker figured out how to get reports to bypass the birt viewer and
> > go
> > > straight to PDF, it doesn't automatically bring up the save dialog but
> > this
> > > is only one click of the save button... if you are interested I can find
> > out
> > > the details from him. He is out this week.
> > >
> > > Kevin Wertz
> > > Grifols, Inc
> > > Clayton NC
> > >
> > > On Wed, Sep 7, 2011 at 6:16 PM, shannonrotz <shannonrotz@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Hi guys: is there any way to set up a BIRT report to behave like the
> > Direct
> > > > Print (i.e. automatically output to PDF) but instead, ask the user
> > where to
> > > > save it?
> > > >
> > > > This would be very useful for POPRINT, for instance.
> > > >
> > > > Shannon
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
>
Hello,
I have finally been granted access to the Yahoo group and am ready to
answer your question.
There are two scenarios that I need to address to implement this trick.
Scenario 1: Report is NOT a Browser View report
(Maximo will allow report import of a report design file that
has parameters)
(1) Add a new parameter named "__format" to the required report design
file using the Eclipse BIRT report designer.
(2) Set a default value for this parameter of "pdf" in Eclipse BIRT
report designer.
(3) Import the report from the Maximo Report Administration App.
(4) Click the 'Save Report' icon and the new report parameter '__format'
will be visible under the listed report parameters.
(5) Change the default value of the parameter '__format' to the value
'pdf' (without quotes), and the Display Name to something like 'Report
Format (html, pdf, xls):' and click the 'Save Report' icon.
(6) Click the Generate Request Page button to generate the report
parameter XML.
(7) When you run the report from 'Select Action'->'Run Reports' the
report parameter dialog window will display with the new parameter shown
with its default value of 'pdf'. When user clicks the 'Submit' button,
the report will go directly to the PDF version, skipping the BIRT Viewer
entirely.
Scenario 2: Report IS a Browser View report
(Maximo will not allow report import of a report design file
that has parameters. This one is kind of tricky, so pay attention)
This trick involves "fooling" Maximo into allowing you to have a Browser
View report that has embedded parameters. It involves unchecking all of
the boxes on the report administration screen (Browser View, Direct
Print, Limit Records, and blanking out the value for Toolbar Sequence)
(1) Add a new parameter named "__format" to the required report design
file using the Eclipse BIRT report designer.
(2) Set a default value for this parameter of "pdf" in Eclipse BIRT
report designer.
(3) Before beginning record the values or take a screen shot(s) of the
report details screen for the given report(s) in order that you can
reset each of these values when we are finished.
(3.5) Not required the first time a report is imported, but is required
for each subsequent Re-Import of an existing report of this type: Delete
all report parameters for this report and click save. Maximo will not
allow you to uncheck the items in Step 4 until this step is completed.
(4) Uncheck the parameters "Browser View", "Direct Print", and "Limit
Records". Blank out the value for "Toolbar Sequence" if Maximo doesn't
already do this for you.
(5) Click on the Save Report icon.
(6) Import the new version of your report that has the new parameter
'__format' embedded in it.
(7) Click on the Save Report icon button.
(8) The new parameter '__format' will show up in the listed report
parameters.
(9) Change the default value of the parameter '__format' to the value
'pdf' (without quotes), and the Display Name to something like 'Report
Format (html, pdf, xls):' and click the 'Save Report' icon.
(10) Click on the Save Report icon button.
(11) Click the Generate Request Page button to generate the report
parameter XML.
(12) Using a text editor and whatever back-end tool you are comfortable
with (TOAD, SQLPlus, etc) create and execute a script file similar to
the following:
update report set toolbarsequence = 1 where reportname =
'woprint.rptdesign' and appname = 'WOTRACK';
update report set usewherewithparam = 1 where reportname =
'woprint.rptdesign' and appname = 'WOTRACK';
update report set ql = 1 where reportname = 'woprint.rptdesign' and
appname = 'WOTRACK';
update report set qlloc = 'ALL' where reportname = 'woprint.rptdesign'
and appname = 'WOTRACK';
update report set detail = 1 where reportname = 'woprint.rptdesign' and
appname = 'WOTRACK';
update report set recordlimit = 50 where reportname =
'woprint.rptdesign' and appname = 'WOTRACK';
update report set dp = 1 where reportname = 'woprint.rptdesign' and
appname = 'WOTRACK';
update report set dploc = 'ALL' where reportname = 'woprint.rptdesign'
and appname = 'WOTRACK';
commit;
You may not need all of these lines. Most of the column names are
self-explanatory. The two columns names starting with 'ql' (quick
launch) are 'Browser View' and 'Browser View Location'. The two columns
starting with 'dp' are for 'Direct Print' and 'Direct Print Location'.
Once you have completed these steps you have "fooled" Maximo into
allowing you to have a Browser View report that has embedded parameters.
You will notice that when you run this report now it will have the
__format=pdf tacked onto the end of the URL when the report is invoked.
Each time you import reports of the type in Scenario 2, you will need to
run through these steps. You will need to add one extra step between
steps 3 and 4 for each subsequent re-import of the report. You need to
delete all report parameters for the report and click save before Maximo
will allow you to uncheck the items listed in step 4. I know it might
seem like alot, but I have done it so many times now that it only takes
me an extra 30 seconds each time I import a report of this type.
Please don't hesitate to give me a call if you have any problems with
these instructions or have additional questions. I can be reached at
the following numbers:
Office - 919-359-5439
Mobile - 919-306-4407
Regards,
- Patrick Burrows
Grifols, Inc.
Clayton, NC
--- In MAXIMO@yahoogroups.com, Kevin Wertz <wertzee@...> wrote:
>
> Hey guys, we haven't forgotten about this, my colleague Patrick is
awaiting
> acceptance into the group.
>
> KW
>
> On Thu, Sep 8, 2011 at 11:40 AM, in2data in2data@... wrote:
>
> > **
> >
> >
> > Hi,
> >
> > We anxiously await the return of the wizard!
> >
> > Dave Bone
> >
> >
> > --- In MAXIMO@yahoogroups.com, Kevin Wertz wertzee@ wrote:
> > >
> > > My coworker figured out how to get reports to bypass the birt
viewer and
> > go
> > > straight to PDF, it doesn't automatically bring up the save dialog
but
> > this
> > > is only one click of the save button... if you are interested I
can find
> > out
> > > the details from him. He is out this week.
> > >
> > > Kevin Wertz
> > > Grifols, Inc
> > > Clayton NC
> > >
> > > On Wed, Sep 7, 2011 at 6:16 PM, shannonrotz shannonrotz@ wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Hi guys: is there any way to set up a BIRT report to behave like
the
> > Direct
> > > > Print (i.e. automatically output to PDF) but instead, ask the
user
> > where to
> > > > save it?
> > > >
> > > > This would be very useful for POPRINT, for instance.
> > > >
> > > > Shannon
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
>
That rocks! Thanks for the details explanation on how you guys got it to work.
--- In MAXIMO@yahoogroups.com, "pburrowspab" <pburrowspab@...> wrote:
>
> Hello,
>
> I have finally been granted access to the Yahoo group and am ready to
> answer your question.
>
> There are two scenarios that I need to address to implement this trick.
>
> Scenario 1: Report is NOT a Browser View report
> (Maximo will allow report import of a report design file that
> has parameters)
>
> (1) Add a new parameter named "__format" to the required report design
> file using the Eclipse BIRT report designer.
> (2) Set a default value for this parameter of "pdf" in Eclipse BIRT
> report designer.
> (3) Import the report from the Maximo Report Administration App.
> (4) Click the 'Save Report' icon and the new report parameter '__format'
> will be visible under the listed report parameters.
> (5) Change the default value of the parameter '__format' to the value
> 'pdf' (without quotes), and the Display Name to something like 'Report
> Format (html, pdf, xls):' and click the 'Save Report' icon.
> (6) Click the Generate Request Page button to generate the report
> parameter XML.
> (7) When you run the report from 'Select Action'->'Run Reports' the
> report parameter dialog window will display with the new parameter shown
> with its default value of 'pdf'. When user clicks the 'Submit' button,
> the report will go directly to the PDF version, skipping the BIRT Viewer
> entirely.
>
>
> Scenario 2: Report IS a Browser View report
> (Maximo will not allow report import of a report design file
> that has parameters. This one is kind of tricky, so pay attention)
> This trick involves "fooling" Maximo into allowing you to have a Browser
> View report that has embedded parameters. It involves unchecking all of
> the boxes on the report administration screen (Browser View, Direct
> Print, Limit Records, and blanking out the value for Toolbar Sequence)
> (1) Add a new parameter named "__format" to the required report design
> file using the Eclipse BIRT report designer.
> (2) Set a default value for this parameter of "pdf" in Eclipse BIRT
> report designer.
> (3) Before beginning record the values or take a screen shot(s) of the
> report details screen for the given report(s) in order that you can
> reset each of these values when we are finished.
> (3.5) Not required the first time a report is imported, but is required
> for each subsequent Re-Import of an existing report of this type: Delete
> all report parameters for this report and click save. Maximo will not
> allow you to uncheck the items in Step 4 until this step is completed.
> (4) Uncheck the parameters "Browser View", "Direct Print", and "Limit
> Records". Blank out the value for "Toolbar Sequence" if Maximo doesn't
> already do this for you.
> (5) Click on the Save Report icon.
> (6) Import the new version of your report that has the new parameter
> '__format' embedded in it.
> (7) Click on the Save Report icon button.
> (8) The new parameter '__format' will show up in the listed report
> parameters.
> (9) Change the default value of the parameter '__format' to the value
> 'pdf' (without quotes), and the Display Name to something like 'Report
> Format (html, pdf, xls):' and click the 'Save Report' icon.
> (10) Click on the Save Report icon button.
> (11) Click the Generate Request Page button to generate the report
> parameter XML.
> (12) Using a text editor and whatever back-end tool you are comfortable
> with (TOAD, SQLPlus, etc) create and execute a script file similar to
> the following:
>
> update report set toolbarsequence = 1 where reportname =
> 'woprint.rptdesign' and appname = 'WOTRACK';
> update report set usewherewithparam = 1 where reportname =
> 'woprint.rptdesign' and appname = 'WOTRACK';
> update report set ql = 1 where reportname = 'woprint.rptdesign' and
> appname = 'WOTRACK';
> update report set qlloc = 'ALL' where reportname = 'woprint.rptdesign'
> and appname = 'WOTRACK';
> update report set detail = 1 where reportname = 'woprint.rptdesign' and
> appname = 'WOTRACK';
> update report set recordlimit = 50 where reportname =
> 'woprint.rptdesign' and appname = 'WOTRACK';
> update report set dp = 1 where reportname = 'woprint.rptdesign' and
> appname = 'WOTRACK';
> update report set dploc = 'ALL' where reportname = 'woprint.rptdesign'
> and appname = 'WOTRACK';
> commit;
>
> You may not need all of these lines. Most of the column names are
> self-explanatory. The two columns names starting with 'ql' (quick
> launch) are 'Browser View' and 'Browser View Location'. The two columns
> starting with 'dp' are for 'Direct Print' and 'Direct Print Location'.
>
> Once you have completed these steps you have "fooled" Maximo into
> allowing you to have a Browser View report that has embedded parameters.
> You will notice that when you run this report now it will have the
> __format=pdf tacked onto the end of the URL when the report is invoked.
>
> Each time you import reports of the type in Scenario 2, you will need to
> run through these steps. You will need to add one extra step between
> steps 3 and 4 for each subsequent re-import of the report. You need to
> delete all report parameters for the report and click save before Maximo
> will allow you to uncheck the items listed in step 4. I know it might
> seem like alot, but I have done it so many times now that it only takes
> me an extra 30 seconds each time I import a report of this type.
>
> Please don't hesitate to give me a call if you have any problems with
> these instructions or have additional questions. I can be reached at
> the following numbers:
>
> Office - 919-359-5439
> Mobile - 919-306-4407
>
> Regards,
>
> - Patrick Burrows
> Grifols, Inc.
> Clayton, NC
>
>
> --- In MAXIMO@yahoogroups.com, Kevin Wertz <wertzee@> wrote:
> >
> > Hey guys, we haven't forgotten about this, my colleague Patrick is
> awaiting
> > acceptance into the group.
> >
> > KW
> >
> > On Thu, Sep 8, 2011 at 11:40 AM, in2data in2data@ wrote:
> >
> > > **
> > >
> > >
> > > Hi,
> > >
> > > We anxiously await the return of the wizard!
> > >
> > > Dave Bone
> > >
> > >
> > > --- In MAXIMO@yahoogroups.com, Kevin Wertz wertzee@ wrote:
> > > >
> > > > My coworker figured out how to get reports to bypass the birt
> viewer and
> > > go
> > > > straight to PDF, it doesn't automatically bring up the save dialog
> but
> > > this
> > > > is only one click of the save button... if you are interested I
> can find
> > > out
> > > > the details from him. He is out this week.
> > > >
> > > > Kevin Wertz
> > > > Grifols, Inc
> > > > Clayton NC
> > > >
> > > > On Wed, Sep 7, 2011 at 6:16 PM, shannonrotz shannonrotz@ wrote:
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > Hi guys: is there any way to set up a BIRT report to behave like
> the
> > > Direct
> > > > > Print (i.e. automatically output to PDF) but instead, ask the
> user
> > > where to
> > > > > save it?
> > > > >
> > > > > This would be very useful for POPRINT, for instance.
> > > > >
> > > > > Shannon
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>
>
>
>
My thanks, too! That worked like a charm.
FYI other users: the "__format" parameter that Patrick is talking about has two (2) __s, not one. It makes a difference!
Shannon
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> That rocks! Thanks for the details explanation on how you guys got it to work.
>
> --- In MAXIMO@yahoogroups.com, "pburrowspab" <pburrowspab@> wrote:
> >
> > Hello,
> >
> > I have finally been granted access to the Yahoo group and am ready to
> > answer your question.
> >
> > There are two scenarios that I need to address to implement this trick.
> >
> > Scenario 1: Report is NOT a Browser View report
> > (Maximo will allow report import of a report design file that
> > has parameters)
> >
> > (1) Add a new parameter named "__format" to the required report design
> > file using the Eclipse BIRT report designer.
> > (2) Set a default value for this parameter of "pdf" in Eclipse BIRT
> > report designer.
> > (3) Import the report from the Maximo Report Administration App.
> > (4) Click the 'Save Report' icon and the new report parameter '__format'
> > will be visible under the listed report parameters.
> > (5) Change the default value of the parameter '__format' to the value
> > 'pdf' (without quotes), and the Display Name to something like 'Report
> > Format (html, pdf, xls):' and click the 'Save Report' icon.
> > (6) Click the Generate Request Page button to generate the report
> > parameter XML.
> > (7) When you run the report from 'Select Action'->'Run Reports' the
> > report parameter dialog window will display with the new parameter shown
> > with its default value of 'pdf'. When user clicks the 'Submit' button,
> > the report will go directly to the PDF version, skipping the BIRT Viewer
> > entirely.
> >
> >
> > Scenario 2: Report IS a Browser View report
> > (Maximo will not allow report import of a report design file
> > that has parameters. This one is kind of tricky, so pay attention)
> > This trick involves "fooling" Maximo into allowing you to have a Browser
> > View report that has embedded parameters. It involves unchecking all of
> > the boxes on the report administration screen (Browser View, Direct
> > Print, Limit Records, and blanking out the value for Toolbar Sequence)
> > (1) Add a new parameter named "__format" to the required report design
> > file using the Eclipse BIRT report designer.
> > (2) Set a default value for this parameter of "pdf" in Eclipse BIRT
> > report designer.
> > (3) Before beginning record the values or take a screen shot(s) of the
> > report details screen for the given report(s) in order that you can
> > reset each of these values when we are finished.
> > (3.5) Not required the first time a report is imported, but is required
> > for each subsequent Re-Import of an existing report of this type: Delete
> > all report parameters for this report and click save. Maximo will not
> > allow you to uncheck the items in Step 4 until this step is completed.
> > (4) Uncheck the parameters "Browser View", "Direct Print", and "Limit
> > Records". Blank out the value for "Toolbar Sequence" if Maximo doesn't
> > already do this for you.
> > (5) Click on the Save Report icon.
> > (6) Import the new version of your report that has the new parameter
> > '__format' embedded in it.
> > (7) Click on the Save Report icon button.
> > (8) The new parameter '__format' will show up in the listed report
> > parameters.
> > (9) Change the default value of the parameter '__format' to the value
> > 'pdf' (without quotes), and the Display Name to something like 'Report
> > Format (html, pdf, xls):' and click the 'Save Report' icon.
> > (10) Click on the Save Report icon button.
> > (11) Click the Generate Request Page button to generate the report
> > parameter XML.
> > (12) Using a text editor and whatever back-end tool you are comfortable
> > with (TOAD, SQLPlus, etc) create and execute a script file similar to
> > the following:
> >
> > update report set toolbarsequence = 1 where reportname =
> > 'woprint.rptdesign' and appname = 'WOTRACK';
> > update report set usewherewithparam = 1 where reportname =
> > 'woprint.rptdesign' and appname = 'WOTRACK';
> > update report set ql = 1 where reportname = 'woprint.rptdesign' and
> > appname = 'WOTRACK';
> > update report set qlloc = 'ALL' where reportname = 'woprint.rptdesign'
> > and appname = 'WOTRACK';
> > update report set detail = 1 where reportname = 'woprint.rptdesign' and
> > appname = 'WOTRACK';
> > update report set recordlimit = 50 where reportname =
> > 'woprint.rptdesign' and appname = 'WOTRACK';
> > update report set dp = 1 where reportname = 'woprint.rptdesign' and
> > appname = 'WOTRACK';
> > update report set dploc = 'ALL' where reportname = 'woprint.rptdesign'
> > and appname = 'WOTRACK';
> > commit;
> >
> > You may not need all of these lines. Most of the column names are
> > self-explanatory. The two columns names starting with 'ql' (quick
> > launch) are 'Browser View' and 'Browser View Location'. The two columns
> > starting with 'dp' are for 'Direct Print' and 'Direct Print Location'.
> >
> > Once you have completed these steps you have "fooled" Maximo into
> > allowing you to have a Browser View report that has embedded parameters.
> > You will notice that when you run this report now it will have the
> > __format=pdf tacked onto the end of the URL when the report is invoked.
> >
> > Each time you import reports of the type in Scenario 2, you will need to
> > run through these steps. You will need to add one extra step between
> > steps 3 and 4 for each subsequent re-import of the report. You need to
> > delete all report parameters for the report and click save before Maximo
> > will allow you to uncheck the items listed in step 4. I know it might
> > seem like alot, but I have done it so many times now that it only takes
> > me an extra 30 seconds each time I import a report of this type.
> >
> > Please don't hesitate to give me a call if you have any problems with
> > these instructions or have additional questions. I can be reached at
> > the following numbers:
> >
> > Office - 919-359-5439
> > Mobile - 919-306-4407
> >
> > Regards,
> >
> > - Patrick Burrows
> > Grifols, Inc.
> > Clayton, NC
> >
> >
> > --- In MAXIMO@yahoogroups.com, Kevin Wertz <wertzee@> wrote:
> > >
> > > Hey guys, we haven't forgotten about this, my colleague Patrick is
> > awaiting
> > > acceptance into the group.
> > >
> > > KW
> > >
> > > On Thu, Sep 8, 2011 at 11:40 AM, in2data in2data@ wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Hi,
> > > >
> > > > We anxiously await the return of the wizard!
> > > >
> > > > Dave Bone
> > > >
> > > >
> > > > --- In MAXIMO@yahoogroups.com, Kevin Wertz wertzee@ wrote:
> > > > >
> > > > > My coworker figured out how to get reports to bypass the birt
> > viewer and
> > > > go
> > > > > straight to PDF, it doesn't automatically bring up the save dialog
> > but
> > > > this
> > > > > is only one click of the save button... if you are interested I
> > can find
> > > > out
> > > > > the details from him. He is out this week.
> > > > >
> > > > > Kevin Wertz
> > > > > Grifols, Inc
> > > > > Clayton NC
> > > > >
> > > > > On Wed, Sep 7, 2011 at 6:16 PM, shannonrotz shannonrotz@ wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > Hi guys: is there any way to set up a BIRT report to behave like
> > the
> > > > Direct
> > > > > > Print (i.e. automatically output to PDF) but instead, ask the
> > user
> > > > where to
> > > > > > save it?
> > > > > >
> > > > > > This would be very useful for POPRINT, for instance.
> > > > > >
> > > > > > Shannon
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
>
Shannon,
Glad my solution was so easy to implement. Just curious, did you implement the solution where the report was a Browser based report, or non-browser based report? Also, just wanted to point out that you can use it to send the user directly to an excel spreadsheet, which we have used to replace some of our old Actuate-based Pivot tables.
Regards,
Patrick Burrows
Grifols, Inc.
Clayton, NC
--- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@...> wrote:
>
> My thanks, too! That worked like a charm.
>
> FYI other users: the "__format" parameter that Patrick is talking about has two (2) __s, not one. It makes a difference!
>
>
> Shannon
>
> --- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@> wrote:
> >
> > That rocks! Thanks for the details explanation on how you guys got it to work.
> >
> > --- In MAXIMO@yahoogroups.com, "pburrowspab" <pburrowspab@> wrote:
> > >
> > > Hello,
> > >
> > > I have finally been granted access to the Yahoo group and am ready to
> > > answer your question.
> > >
> > > There are two scenarios that I need to address to implement this trick.
> > >
> > > Scenario 1: Report is NOT a Browser View report
> > > (Maximo will allow report import of a report design file that
> > > has parameters)
> > >
> > > (1) Add a new parameter named "__format" to the required report design
> > > file using the Eclipse BIRT report designer.
> > > (2) Set a default value for this parameter of "pdf" in Eclipse BIRT
> > > report designer.
> > > (3) Import the report from the Maximo Report Administration App.
> > > (4) Click the 'Save Report' icon and the new report parameter '__format'
> > > will be visible under the listed report parameters.
> > > (5) Change the default value of the parameter '__format' to the value
> > > 'pdf' (without quotes), and the Display Name to something like 'Report
> > > Format (html, pdf, xls):' and click the 'Save Report' icon.
> > > (6) Click the Generate Request Page button to generate the report
> > > parameter XML.
> > > (7) When you run the report from 'Select Action'->'Run Reports' the
> > > report parameter dialog window will display with the new parameter shown
> > > with its default value of 'pdf'. When user clicks the 'Submit' button,
> > > the report will go directly to the PDF version, skipping the BIRT Viewer
> > > entirely.
> > >
> > >
> > > Scenario 2: Report IS a Browser View report
> > > (Maximo will not allow report import of a report design file
> > > that has parameters. This one is kind of tricky, so pay attention)
> > > This trick involves "fooling" Maximo into allowing you to have a Browser
> > > View report that has embedded parameters. It involves unchecking all of
> > > the boxes on the report administration screen (Browser View, Direct
> > > Print, Limit Records, and blanking out the value for Toolbar Sequence)
> > > (1) Add a new parameter named "__format" to the required report design
> > > file using the Eclipse BIRT report designer.
> > > (2) Set a default value for this parameter of "pdf" in Eclipse BIRT
> > > report designer.
> > > (3) Before beginning record the values or take a screen shot(s) of the
> > > report details screen for the given report(s) in order that you can
> > > reset each of these values when we are finished.
> > > (3.5) Not required the first time a report is imported, but is required
> > > for each subsequent Re-Import of an existing report of this type: Delete
> > > all report parameters for this report and click save. Maximo will not
> > > allow you to uncheck the items in Step 4 until this step is completed.
> > > (4) Uncheck the parameters "Browser View", "Direct Print", and "Limit
> > > Records". Blank out the value for "Toolbar Sequence" if Maximo doesn't
> > > already do this for you.
> > > (5) Click on the Save Report icon.
> > > (6) Import the new version of your report that has the new parameter
> > > '__format' embedded in it.
> > > (7) Click on the Save Report icon button.
> > > (8) The new parameter '__format' will show up in the listed report
> > > parameters.
> > > (9) Change the default value of the parameter '__format' to the value
> > > 'pdf' (without quotes), and the Display Name to something like 'Report
> > > Format (html, pdf, xls):' and click the 'Save Report' icon.
> > > (10) Click on the Save Report icon button.
> > > (11) Click the Generate Request Page button to generate the report
> > > parameter XML.
> > > (12) Using a text editor and whatever back-end tool you are comfortable
> > > with (TOAD, SQLPlus, etc) create and execute a script file similar to
> > > the following:
> > >
> > > update report set toolbarsequence = 1 where reportname =
> > > 'woprint.rptdesign' and appname = 'WOTRACK';
> > > update report set usewherewithparam = 1 where reportname =
> > > 'woprint.rptdesign' and appname = 'WOTRACK';
> > > update report set ql = 1 where reportname = 'woprint.rptdesign' and
> > > appname = 'WOTRACK';
> > > update report set qlloc = 'ALL' where reportname = 'woprint.rptdesign'
> > > and appname = 'WOTRACK';
> > > update report set detail = 1 where reportname = 'woprint.rptdesign' and
> > > appname = 'WOTRACK';
> > > update report set recordlimit = 50 where reportname =
> > > 'woprint.rptdesign' and appname = 'WOTRACK';
> > > update report set dp = 1 where reportname = 'woprint.rptdesign' and
> > > appname = 'WOTRACK';
> > > update report set dploc = 'ALL' where reportname = 'woprint.rptdesign'
> > > and appname = 'WOTRACK';
> > > commit;
> > >
> > > You may not need all of these lines. Most of the column names are
> > > self-explanatory. The two columns names starting with 'ql' (quick
> > > launch) are 'Browser View' and 'Browser View Location'. The two columns
> > > starting with 'dp' are for 'Direct Print' and 'Direct Print Location'.
> > >
> > > Once you have completed these steps you have "fooled" Maximo into
> > > allowing you to have a Browser View report that has embedded parameters.
> > > You will notice that when you run this report now it will have the
> > > __format=pdf tacked onto the end of the URL when the report is invoked.
> > >
> > > Each time you import reports of the type in Scenario 2, you will need to
> > > run through these steps. You will need to add one extra step between
> > > steps 3 and 4 for each subsequent re-import of the report. You need to
> > > delete all report parameters for the report and click save before Maximo
> > > will allow you to uncheck the items listed in step 4. I know it might
> > > seem like alot, but I have done it so many times now that it only takes
> > > me an extra 30 seconds each time I import a report of this type.
> > >
> > > Please don't hesitate to give me a call if you have any problems with
> > > these instructions or have additional questions. I can be reached at
> > > the following numbers:
> > >
> > > Office - 919-359-5439
> > > Mobile - 919-306-4407
> > >
> > > Regards,
> > >
> > > - Patrick Burrows
> > > Grifols, Inc.
> > > Clayton, NC
> > >
> > >
> > > --- In MAXIMO@yahoogroups.com, Kevin Wertz <wertzee@> wrote:
> > > >
> > > > Hey guys, we haven't forgotten about this, my colleague Patrick is
> > > awaiting
> > > > acceptance into the group.
> > > >
> > > > KW
> > > >
> > > > On Thu, Sep 8, 2011 at 11:40 AM, in2data in2data@ wrote:
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > > We anxiously await the return of the wizard!
> > > > >
> > > > > Dave Bone
> > > > >
> > > > >
> > > > > --- In MAXIMO@yahoogroups.com, Kevin Wertz wertzee@ wrote:
> > > > > >
> > > > > > My coworker figured out how to get reports to bypass the birt
> > > viewer and
> > > > > go
> > > > > > straight to PDF, it doesn't automatically bring up the save dialog
> > > but
> > > > > this
> > > > > > is only one click of the save button... if you are interested I
> > > can find
> > > > > out
> > > > > > the details from him. He is out this week.
> > > > > >
> > > > > > Kevin Wertz
> > > > > > Grifols, Inc
> > > > > > Clayton NC
> > > > > >
> > > > > > On Wed, Sep 7, 2011 at 6:16 PM, shannonrotz shannonrotz@ wrote:
> > > > > >
> > > > > > > **
> > > > > > >
> > > > > > >
> > > > > > > Hi guys: is there any way to set up a BIRT report to behave like
> > > the
> > > > > Direct
> > > > > > > Print (i.e. automatically output to PDF) but instead, ask the
> > > user
> > > > > where to
> > > > > > > save it?
> > > > > > >
> > > > > > > This would be very useful for POPRINT, for instance.
> > > > > > >
> > > > > > > Shannon
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> >
>