Maximo List Archive

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.


Birt Question

From: Jagan Rajan (2011-07-28 10:34)

    helloo all,
 
   
   I just updated the work order details report in BIRT, added location long Description to the report. We store the address of the location in the location long description field. When I print one work order from the work order itself it prints the correct address.
 
 But if I print more than 1 work order from list it will print the first work orders address on all of them. Can you please help me resolve this issue?
 
Any help is appreciated.
 
 
Thanks
Jagan

From: planschd (2011-07-28 17:36)

Can you copy/paste that section of the BIRT code?
Sent on the Sprint� Now Network from my BlackBerry�

-----Original Message-----
From: Jagan Rajan <lensman511@yahoo.com>
Sender: MAXIMO@yahoogroups.com
Date: Thu, 28 Jul 2011 10:34:32
To: maximo@yahoogroups.com<maximo@yahoogroups.com>
Reply-To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Birt Question

����helloo all,
�
���
�� I just updated the work order details report in BIRT, added location long Description to the report. We store the address of the location in the location long description field. When I print one work order from the work order itself it prints the correct address.
�
�But if I print more than 1 work order from list it will print the first work orders address on all of them. Can you please help me resolve this issue?
�
Any help is appreciated.
�
�
Thanks
Jagan




From: Michael Dougherty (2011-07-28 13:40)

I have been attempting to add the Long description right next to the description in the task ID for the work order report. Anyone know how to do this successfully?
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of planschd@yahoo.com
Sent: Thursday, July 28, 2011 1:37 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Birt Question
Can you copy/paste that section of the BIRT code?
Sent on the Sprint® Now Network from my BlackBerry®
-----Original Message-----
From: Jagan Rajan <lensman511@yahoo.com>
Sender: MAXIMO@yahoogroups.com
Date: Thu, 28 Jul 2011 10:34:32
To: maximo@yahoogroups.com<maximo@yahoogroups.com>
Reply-To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Birt Question
    helloo all,
 
   
   I just updated the work order details report in BIRT, added location long Description to the report. We store the address of the location in the location long description field. When I print one work order from the work order itself it prints the correct address.
 
 But if I print more than 1 work order from list it will print the first work orders address on all of them. Can you please help me resolve this issue?
 
Any help is appreciated.
 
 
Thanks
Jagan

------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join : MAXIMO-subscribe@yahoogroups.com
Leave : MAXIMO-unsubscribe@yahoogroups.com
Cry : MAXIMO-owner@yahoogroups.com
Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links

From: Jagan Rajan (2011-07-28 10:52)

this is the fetch code
 
 
longDesclocationDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), "longDesclocationDataSet");
 longDesclocationDataSet.open();
 
 longDesclocationSQL = "select longdescription.ldtext  "
 + "from longdescription "
    + "where longdescription.ldownertable='LOCATIONS' and longdescription.ldownercol='DESCRIPTION' "
    + "and longdescription.ldkey=" + row["locationsid"];
 
 
 longDesclocationDataSet.setQuery(longDesclocationSQL);
 if(longDesclocationDataSet.fetch()) {
  row["longdesclocation"] = longDesclocationDataSet.getString("ldtext");
 }
 
 longDesclocationDataSet.close();
From: "planschd@yahoo.com" <planschd@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, July 28, 2011 1:36 PM
Subject: Re: [MAXIMO List] Birt Question
Can you copy/paste that section of the BIRT code?
Sent on the Sprint® Now Network from my BlackBerry®
-----Original Message-----
From: Jagan Rajan <lensman511@yahoo.com>
Sender: MAXIMO@yahoogroups.com
Date: Thu, 28 Jul 2011 10:34:32
To: maximo@yahoogroups.com<maximo@yahoogroups.com>
Reply-To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Birt Question
    helloo all,
 
   
   I just updated the work order details report in BIRT, added location long Description to the report. We store the address of the location in the location long description field. When I print one work order from the work order itself it prints the correct address.
 
 But if I print more than 1 work order from list it will print the first work orders address on all of them. Can you please help me resolve this issue?
 
Any help is appreciated.
 
 
Thanks
Jagan

------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join  : MAXIMO-subscribe@yahoogroups.com
Leave  : MAXIMO-unsubscribe@yahoogroups.com
Cry    : MAXIMO-owner@yahoogroups.com
Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links

From: planschd (2011-07-28 17:56)

Ok Jagan. Thanks.
To me this looks good.
But you need to make sure somehow that the Workorder.Location value is driving this "sub query" which will change as you read each new WONUM
Sent on the Sprint� Now Network from my BlackBerry�

-----Original Message-----
From: Jagan Rajan <lensman511@yahoo.com>
Sender: MAXIMO@yahoogroups.com
Date: Thu, 28 Jul 2011 10:52:46
To: MAXIMO@yahoogroups.com<MAXIMO@yahoogroups.com>
Reply-To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Birt Question

this is the fetch code
�
�
longDesclocationDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), "longDesclocationDataSet");
�longDesclocationDataSet.open();
�
�longDesclocationSQL = "select longdescription.ldtext� "
�+ "from longdescription "
��� + "where longdescription.ldownertable='LOCATIONS' and longdescription.ldownercol='DESCRIPTION' "
��� + "and longdescription.ldkey=" + row["locationsid"];
�
�
�longDesclocationDataSet.setQuery(longDesclocationSQL);
�if(longDesclocationDataSet.fetch()) {
��row["longdesclocation"] = longDesclocationDataSet.getString("ldtext");
�}
�
�longDesclocationDataSet.close();



From: "planschd@yahoo.com" <planschd@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, July 28, 2011 1:36 PM
Subject: Re: [MAXIMO List] Birt Question

Can you copy/paste that section of the BIRT code?
Sent on the Sprint� Now Network from my BlackBerry�

-----Original Message-----
From: Jagan Rajan <lensman511@yahoo.com>
Sender: MAXIMO@yahoogroups.com
Date: Thu, 28 Jul 2011 10:34:32
To: maximo@yahoogroups.com<maximo@yahoogroups.com>
Reply-To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Birt Question

����helloo all,
�
���
�� I just updated the work order details report in BIRT, added location long Description to the report. We store the address of the location in the location long description field. When I print one work order from the work order itself it prints the correct address.
�
�But if I print more than 1 work order from list it will print the first work orders address on all of them. Can you please help me resolve this issue?
�
Any help is appreciated.
�
�
Thanks
Jagan










------------------------------------

Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join� : MAXIMO-subscribe@yahoogroups.com
Leave� : MAXIMO-unsubscribe@yahoogroups.com
Cry� � : MAXIMO-owner@yahoogroups.com
Group� : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links






From: Martin Wunder (2011-07-28 14:53)

Hello!

I have a problem with the page breaking functionality for PDF reports. I
have a report that should print a fixed table or a grid for collecting data;
some has 4 rows, another 5, etc. But they should be kept together since it
has the title of a table or the label and the table itself but when printing
they are torn apart by page breaks. The Report looks bad if the title is at
the end of one page and the body (a table or a list) is on the next page.
I cannot find anywhere on how to keep them together. If you know how to do
this, could you please let me know?

Thanks!

Martin

From: planschd (2011-07-28 19:16)

Are you able to ascertain current-line-number?
And then sense this on each new line print.
Insert If-then-else type function which forces page-break.
Sorry not much help in exact syntax ...
Sent on the Sprint� Now Network from my BlackBerry�

-----Original Message-----
From: "Martin Wunder" <martin.wunder@wsidc.com>
Sender: MAXIMO@yahoogroups.com
Date: Thu, 28 Jul 2011 14:53:16
To: <MAXIMO@yahoogroups.com>
Reply-To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] BIRT - How do you keep a section together

Hello!



I have a problem with the page breaking functionality for PDF reports. I
have a report that should print a fixed table or a grid for collecting data;
some has 4 rows, another 5, etc. But they should be kept together since it
has the title of a table or the label and the table itself but when printing
they are torn apart by page breaks. The Report looks bad if the title is at
the end of one page and the body (a table or a list) is on the next page.

I cannot find anywhere on how to keep them together. If you know how to do
this, could you please let me know?



Thanks!



Martin






From: Jagan Rajan (2011-07-29 07:29)

Can you help on this pleaseee
From: "planschd@yahoo.com" <planschd@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, July 28, 2011 1:56 PM
Subject: Re: [MAXIMO List] Birt Question
Ok Jagan. Thanks.
To me this looks good.
But you need to make sure somehow that the Workorder.Location value is driving this "sub query" which will change as you read each new WONUM
Sent on the Sprint® Now Network from my BlackBerry®
-----Original Message-----
From: Jagan Rajan <lensman511@yahoo.com>
Sender: MAXIMO@yahoogroups.com
Date: Thu, 28 Jul 2011 10:52:46
To: MAXIMO@yahoogroups.com<MAXIMO@yahoogroups.com>
Reply-To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Birt Question
this is the fetch code
 
 
longDesclocationDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), "longDesclocationDataSet");
 longDesclocationDataSet.open();
 
 longDesclocationSQL = "select longdescription.ldtext  "
 + "from longdescription "
    + "where longdescription.ldownertable='LOCATIONS' and longdescription.ldownercol='DESCRIPTION' "
    + "and longdescription.ldkey=" + row["locationsid"];
 
 
 longDesclocationDataSet.setQuery(longDesclocationSQL);
 if(longDesclocationDataSet.fetch()) {
  row["longdesclocation"] = longDesclocationDataSet.getString("ldtext");
 }
 
 longDesclocationDataSet.close();
From: "planschd@yahoo.com" <planschd@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, July 28, 2011 1:36 PM
Subject: Re: [MAXIMO List] Birt Question
Can you copy/paste that section of the BIRT code?
Sent on the Sprint® Now Network from my BlackBerry®
-----Original Message-----
From: Jagan Rajan <lensman511@yahoo.com>
Sender: MAXIMO@yahoogroups.com
Date: Thu, 28 Jul 2011 10:34:32
To: maximo@yahoogroups.com<maximo@yahoogroups.com>
Reply-To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Birt Question
    helloo all,
 
   
   I just updated the work order details report in BIRT, added location long Description to the report. We store the address of the location in the location long description field. When I print one work order from the work order itself it prints the correct address.
 
 But if I print more than 1 work order from list it will print the first work orders address on all of them. Can you please help me resolve this issue?
 
Any help is appreciated.
 
 
Thanks
Jagan

------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join  : MAXIMO-subscribe@yahoogroups.com
Leave  : MAXIMO-unsubscribe@yahoogroups.com
Cry    : MAXIMO-owner@yahoogroups.com
Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links

------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join  : MAXIMO-subscribe@yahoogroups.com
Leave  : MAXIMO-unsubscribe@yahoogroups.com
Cry    : MAXIMO-owner@yahoogroups.com
Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links