nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Problem with page header

Birt_Manu

Hi,

I want to create a report which will show a set of SAME information in the starting of each page,so the best way would be to include that information in the MASTER PAGE header,this information will be obtained through a query,for which I have created corresponding DATASET.

Now the problem is that in MASTER PAGE header only grid is allowed and when trying to obtain the information through the dataSetRow["column name"] in grid, it is showing only first row of the result generated through the query.I have to show the entire result obtained,but couldnot find any solution.

Please let me know the solution.

Find more posts tagged with

Comments

mwilliams

Hi Birt_Manu,

Tables and lists are the only items that will iterate through your dataSet to display all results, so if those aren't allowed, this can't be done with data elements. I haven't tried this, but you might try building an HTML table in your dataSet script as you access the rows of the database and use it in the header. As long as the dataSet is called prior to the masterpage being created, you should be able to do this.

Birt_Manu

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="69870" data-time="1288361778" data-date="29 October 2010 - 07:16 AM">
Hi Birt_Manu, 
 
Tables and lists are the only items that will iterate through your dataSet to display all results, so if those aren't allowed, this can't be done with data elements. I haven't tried this, but you might try building an HTML table in your dataSet script as you access the rows of the database and use it in the header. As long as the dataSet is called prior to the masterpage being created, you should be able to do this. </blockquote>
 
Thanks ,But if you could just explain with an example how to build an HTML table in dataset,and how the data set can be called prior to the master page. 
 
I am new to birt,so unaware of these things.Please help me out with this.

Birt_Manu

Please if anyone knows any solution of this problem,kindly share that with me.

I am stuck on this.

mwilliams

Birt_Manu,

You'd build the HTML table as a string of HTML as the data is retrieved from the database by the dataSet in the onFetch method. You would then recall the variable that you stored the HTML table string into in a text element of type HTML in the masterpage header. Again, I'm not sure if this is possible in the MP header, but it's worth a shot. If you need help testing this idea, let me know.

Birt_Manu

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="69905" data-time="1288626181" data-date="01 November 2010 - 08:43 AM">
Birt_Manu, 
 
You'd build the HTML table as a string of HTML as the data is retrieved from the database by the dataSet in the onFetch method. You would then recall the variable that you stored the HTML table string into in a text element of type HTML in the masterpage header. Again, I'm not sure if this is possible in the MP header, but it's worth a shot. If you need help testing this idea, let me know. </blockquote>
 
Thanks Williams, 
 
Could you please help me out with a small example as I am still not sure how to proceed with this . 
 
many thanks in advance!!

Birt_Start

<blockquote class='ipsBlockquote' data-author="'Birt_Manu'" data-cid="69929" data-time="1288683004" data-date="02 November 2010 - 12:30 AM">
Thanks Williams, 
 
Could you please help me out with a small example as I am still not sure how to proceed with this . 
 
many thanks in advance!! </blockquote>
 
Hi everyone, 
 
I too have a similar problem with my reports.Its frustating not to be allowed to add table in the masterpage header,it would have saved a lot of trouble.If anyone know any possible solution,please share it.

Birt_Start

<blockquote class='ipsBlockquote' data-author="'Birt_Start'" data-cid="69975" data-time="1288779955" data-date="03 November 2010 - 03:25 AM">
Hi everyone, 
 
I too have a similar problem with my reports.Its frustating not to be allowed to add table in the masterpage header,it would have saved a lot of trouble.If anyone know any possible solution,please share it. </blockquote>
 
Hi All, 
 
Please share if you have any solution for this,I am not able to find any solution. 
 
Need your help guys. 
 
Many Thanks

mwilliams

Sorry for the delay, I was out of town all last week at Actuate Customer Days in San Francisco. What is your BIRT version? I will make an attempt to see if it can be done with the HTML table made out of the dataSet.

Birt_Manu

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70127" data-time="1289320240" data-date="09 November 2010 - 09:30 AM">
Sorry for the delay, I was out of town all last week at Actuate Customer Days in San Francisco. What is your BIRT version? I will make an attempt to see if it can be done with the HTML table made out of the dataSet. </blockquote>
 
Hi Mwilliams, 
 
I am using Birt 2.1.2 
 
Thanks for all your help.

mwilliams

Ok, my version of 2.1.2 isn't working correctly too see if this works, but I tried this in 2.6.1 and it works correctly. I'm attaching my 2.1.2 report in case it works for you, but below is what I did. 
 
In the initialize method of the report, I put: 
 
htmlTable = ""; 
 
In the onFetch of the dataSet, I put: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (htmlTable == ""){
htmlTable = "<table border=\"1\"><tr><th>Order Number</th><th>Order Date</th></tr>" +
"<tr><td>" + row["ORDERNUMBER"] + "</td><td>" + row["ORDERDATE"] + "</td></tr>";
}
else{
htmlTable = htmlTable + "<tr><td>" + row["ORDERNUMBER"] + "</td><td>" + row["ORDERDATE"] + "</td></tr>";
}
</pre>
 
Then, in my master page header, I put a text box that I bound to my dataSet with the following contents: 
 
<VALUE-OF format="HTML">htmlTable + "</table>";</VALUE-OF> 
 
Let me know.

Birt_Manu

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70206" data-time="1289418673" data-date="10 November 2010 - 12:51 PM">
Ok, my version of 2.1.2 isn't working correctly too see if this works, but I tried this in 2.6.1 and it works correctly. I'm attaching my 2.1.2 report in case it works for you, but below is what I did. 
 
In the initialize method of the report, I put: 
 
htmlTable = ""; 
 
In the onFetch of the dataSet, I put: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (htmlTable == ""){
htmlTable = "<table border=\"1\"><tr><th>Order Number</th><th>Order Date</th></tr>" +
"<tr><td>" + row["ORDERNUMBER"] + "</td><td>" + row["ORDERDATE"] + "</td></tr>";
}
else{
htmlTable = htmlTable + "<tr><td>" + row["ORDERNUMBER"] + "</td><td>" + row["ORDERDATE"] + "</td></tr>";
}
</pre>
 
Then, in my master page header, I put a text box that I bound to my dataSet with the following contents: 
 
<VALUE-OF format="HTML">htmlTable + "</table>";</VALUE-OF> 
 
Let me know. </blockquote>
 
 
 
Hi Mwilliams, 
 
Thanks a lot for your reply, 
 
The report is showing the data in the header in the Birt Preview but not in the pdf,when trying to generate the report through the application.Please let me know what is needed to be done. 
 
Once again thanks for your help.

mwilliams

Like I said, I wasn't able to test it in 2.1.2, but it does show up in PDF in 2.6.1. There must have been a change that allowed the HTML table to show somewhere between there. Obviously there have been many improvements to the PDF emitter, but I don't know what version this changed in. I'm also guessing that if the table won't show, that a list probably wouldn't either. I'm guessing you're not able to upgrade?

Birt_Manu

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70223" data-time="1289486798" data-date="11 November 2010 - 07:46 AM">
Like I said, I wasn't able to test it in 2.1.2, but it does show up in PDF in 2.6.1. There must have been a change that allowed the HTML table to show somewhere between there. Obviously there have been many improvements to the PDF emitter, but I don't know what version this changed in. I'm also guessing that if the table won't show, that a list probably wouldn't either. I'm guessing you're not able to upgrade? </blockquote>
 
Hi Mwilliams, 
 
You guessed it right,I am not allowed to upgrade.Also I tried it in 2.6.1 its giving invalid input stream error.Is their any way to obtain the solution in 2.1.2? 
 
once again thanks for your replies

mwilliams

I created a new report in 2.6.1 to do this. I didn't try to use the same file. Updates from 2.1.2 to 2.6.1 are probably the cause of this, I would guess. It for sure works in 2.6.1 in PDF as long as the masterpage header height is set to fit the height of the table. I think I'll have to download an old version of Java for me to get 2.1.2 to work, so I'll have to do that before I can test anything out in it.

Birt_Manu

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70250" data-time="1289543939" data-date="11 November 2010 - 11:38 PM">
I created a new report in 2.6.1 to do this. I didn't try to use the same file. Updates from 2.1.2 to 2.6.1 are probably the cause of this, I would guess. It for sure works in 2.6.1 in PDF as long as the masterpage header height is set to fit the height of the table. I think I'll have to download an old version of Java for me to get 2.1.2 to work, so I'll have to do that before I can test anything out in it. </blockquote>
 
Thanks a lot Williams, 
 
I tried to generate this with a new report in 2.6.1 it still gives the same error,this may be because the application is compatible with 2.1.2,Can you please check it with 2.1.2 as in any case I will have to do it with 2.1.2. 
 
Thanks for all your help.

mwilliams

I tried to download Java 1.4, which is what I think I need for 2.1.2 and it told me that my platform was unsupported for 1.4. I am running Windows 7. Without that, I won't be able to test in 2.1.2.