BIRT Exchange Forum: BIRT - Adding Dataset on Master Page - URGENT PLS - BIRT Exchange Forum

Jump to content


 

No Latest Open Poll.

  • (2 Pages)
  • +
  • 1
  • 2
  • You cannot start a new topic
  • You cannot reply to this topic

BIRT - Adding Dataset on Master Page - URGENT PLS How can I add two column table on BIRT master page Rate Topic: -----

#1 User is offline   CuriousTec Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 9
  • Joined: 21-November 11


Posted 13 December 2011 - 06:22 AM

Hi all,
I have created a BIRT report which is working fine. I am now having a problem with adding a table on the Master Page with 6 rows. I need to have this information on the masterpage because it has to appear on every page - giving description of the Acronyms used in the report. I know that you can not add a dataset on the master page so how else can I accomplish this task? Please help. I am in a very tight schedule. Thank you.
0

#2 User is offline   kabilan_n Icon

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 49
  • Joined: 16-August 11


Posted 13 December 2011 - 06:41 AM

Hi,

I think there is no option for inserting table in a master page.[not sure - upto my knowledge i am saying].
but you can do that by dragging grid into the masterpage header and within that you can insert dataset data's and also provide label for that. By this way you can create a table structure.
Hope this will help you.

-- Kabil
0

#3 User is offline   piwya Icon

  • Senior Member
  • Group: Members
  • Posts: 106
  • Joined: 28-April 11


Posted 13 December 2011 - 06:43 AM

You have to drag a grid on master page header or footer then you can able to create a grid which looks like table report that will show on every page.

hope this helps.
0

#4 User is offline   CuriousTec Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 9
  • Joined: 21-November 11


Posted 13 December 2011 - 08:26 AM

View Postpiwya, on 13 December 2011 - 06:43 AM, said:

You have to drag a grid on master page header or footer then you can able to create a grid which looks like table report that will show on every page.

hope this helps.

0

#5 User is offline   CuriousTec Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 9
  • Joined: 21-November 11


Posted 13 December 2011 - 08:32 AM

Thank you for your prompt response. The acronym descriptions I have are in a dataset and when I add the dataset to a grid it only display the first row of 6 rows. Tables cannot be dragged into the master page (this is why it is making this task hard to accomplish). Does someone out there have a suggestion on the workaround?

Thank you for your response.
0

#6 User is online   mwilliams Icon

  • BIRT Guru
  • Icon
  • View blog
  • Group: Administrators
  • Posts: 12971
  • Joined: 16-May 08


Posted 13 December 2011 - 08:34 AM

Take a look at this devShare post:

http://www.birt-exch...terpage-header/
Regards,

Michael

Twitter
Facebook
Blog
Yahoo: mwilliams_actuate@yahoo.com
Google: mwilliams.actuate@gmail.com
0

#7 User is offline   CuriousTec Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 9
  • Joined: 21-November 11


Posted 14 December 2011 - 06:04 AM

View PostCuriousTec, on 13 December 2011 - 08:32 AM, said:

Thank you for your prompt response. The acronym descriptions I have are in a dataset and when I add the dataset to a grid it only display the first row of 6 rows. Tables cannot be dragged into the master page (this is why it is making this task hard to accomplish). Does someone out there have a suggestion on the workaround?

Thank you for your response.

0

#8 User is offline   CuriousTec Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 9
  • Joined: 21-November 11


Posted 14 December 2011 - 06:13 AM

Birt Guru,
Thank you for sending me the DevShare link. I have used this example once before but it did not work for me. I have added all the information required (initialize the HTML table) create HTML table etc, but when I preview the report the HTML table is not displayed. This is what I have so far:
This is added under onFetch)
if (htmlTable == ""){
htmlTable = "<table border=\"1\"><tr><td>" + row["ACRONYM"] + "</td></tr>"
}
else{
htmlTable = htmlTable + "<tr><td>" + row["ACRONYM"] + "</td></tr>"
}
My table has only one column with not heading.

This is the information that I have on the masterpage textbox: <VALUE-OF format="HTML">htmlTable + "</table>";</VALUE-OF>.

Please let me know what I am doing wrong. I am using "birt-eclipse-designer-3.7.1
0

#9 User is online   mwilliams Icon

  • BIRT Guru
  • Icon
  • View blog
  • Group: Administrators
  • Posts: 12971
  • Joined: 16-May 08


Posted 14 December 2011 - 07:03 AM

Did you bind the text box to the dataSet so that the dataSet is ran? If not, it won't show because your code will not run.
Regards,

Michael

Twitter
Facebook
Blog
Yahoo: mwilliams_actuate@yahoo.com
Google: mwilliams.actuate@gmail.com
0

#10 User is offline   CuriousTec Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 9
  • Joined: 21-November 11


Posted 14 December 2011 - 08:09 AM

Birt Guru,
You are very right. That is what I needed - bind the textbox to the dataset. It is now working. I really appreciate your timely response.
0

#11 User is online   mwilliams Icon

  • BIRT Guru
  • Icon
  • View blog
  • Group: Administrators
  • Posts: 12971
  • Joined: 16-May 08


Posted 14 December 2011 - 09:17 AM

Not a problem. Let us know whenever you have questions! :)
Regards,

Michael

Twitter
Facebook
Blog
Yahoo: mwilliams_actuate@yahoo.com
Google: mwilliams.actuate@gmail.com
0

#12 User is offline   mzeevalk Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 21
  • Joined: 22-September 11


Posted 18 May 2012 - 11:21 AM

The devshare solution does not appear to work when rendering the report to PDF (using frameset URL in BIRT 3.7.1) when multiple reports are generated. We are seeing that if 10 reports are generated in a single PDF file that the data from the last report is being displayed in the master page for all reports. It works fine if a single report is generated. Any suggestions?
0

#13 User is online   mwilliams Icon

  • BIRT Guru
  • Icon
  • View blog
  • Group: Administrators
  • Posts: 12971
  • Joined: 16-May 08


Posted 22 May 2012 - 08:16 AM

When you say 10 reports, do you mean there are 10 groups that you run the report for? Could you use the group header to display your table, instead of the masterpage header? Or do you need it in the masterpage, for sure?
Regards,

Michael

Twitter
Facebook
Blog
Yahoo: mwilliams_actuate@yahoo.com
Google: mwilliams.actuate@gmail.com
0

#14 User is offline   mzeevalk Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 21
  • Joined: 22-September 11


Posted 22 May 2012 - 08:58 AM

Yes, by 10 reports I mean 10 groups. The reason why we went the master page route is that this is a 4 page letter where the first page contains letterhead information and the 2nd-4th pages contain information that we are storing from the onFetch event of the main data set. I guess I can try using the group header, but since we don't want to see the data we are capturing in the table now on page one of each group, we'll have to track group page numbers (or the group data value) and if the page number is equal to 1 (or the group value changes) then hide the group header. Let me know if you are aware of a way to do this at the master page level when generating to PDF through the frameset URL. Thanks in advance.
0

#15 User is online   mwilliams Icon

  • BIRT Guru
  • Icon
  • View blog
  • Group: Administrators
  • Posts: 12971
  • Joined: 16-May 08


Posted 24 May 2012 - 06:54 AM

Take a look at this report. It uses persistentGlobalVariables in the onCreate of the group header and report variables are set in the onPageEnd event. A grid and variable auto texts are used in the masterpage header. Let me know if you have questions.

Attached File(s)


Regards,

Michael

Twitter
Facebook
Blog
Yahoo: mwilliams_actuate@yahoo.com
Google: mwilliams.actuate@gmail.com
0

#16 User is offline   learnbirt1 Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 4
  • Joined: 31-March 12


Posted 30 May 2012 - 07:46 AM

I have implemented persistentGlobalVariables solution in my report.But somehow I am getting null values for page variables.I am attaching the report design.Can you please let me know if i am missing any thing. I really appreciate your timely response.

Thanks in advance.
0

#17 User is online   mwilliams Icon

  • BIRT Guru
  • Icon
  • View blog
  • Group: Administrators
  • Posts: 12971
  • Joined: 16-May 08


Posted 01 June 2012 - 09:32 PM

Can you try attaching the file again? I don't see it. Thanks!
Regards,

Michael

Twitter
Facebook
Blog
Yahoo: mwilliams_actuate@yahoo.com
Google: mwilliams.actuate@gmail.com
0

#18 User is offline   learnbirt1 Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 4
  • Joined: 31-March 12


Posted 02 June 2012 - 05:29 AM

View Postmwilliams, on 01 June 2012 - 10:32 PM, said:

Can you try attaching the file again? I don't see it. Thanks!



Please see the attached file..Thanks alot

Attached File(s)


0

#19 User is online   mwilliams Icon

  • BIRT Guru
  • Icon
  • View blog
  • Group: Administrators
  • Posts: 12971
  • Joined: 16-May 08


Posted 05 June 2012 - 11:11 AM

I don't see where you're setting your global variables, anywhere. Can you point me to where that is? I see where you try to get them, but I don't see where you're setting them. Let me know.
Regards,

Michael

Twitter
Facebook
Blog
Yahoo: mwilliams_actuate@yahoo.com
Google: mwilliams.actuate@gmail.com
0

#20 User is offline   actuser9 Icon

  • Senior Member
  • Group: Members
  • Posts: 107
  • Joined: 11-April 12


Posted 06 July 2012 - 08:33 AM

BIRT Guru,

I tried to implement the page variable solution that you provided for the change of group by means of the global variable. But the group name is not populating on the master page header.

My report is based on the scripted data set that is populating data based on a java pojo object. What might be causing the issue?

Any inputs are highly appreaciated.
0

  • (2 Pages)
  • +
  • 1
  • 2
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users