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; } } }

Dynamically selecting dataset and hide/unhide column

lexthang

I see another thread (http://www.birt-exchange.org/org/forum/index.php/topic/25317-pass-parametervalue-to-data-set-by-drop-down-list/) with some similar points, but I have more questions which may not be the same as his, and plus I don't want to hijack his thread, so here goes. I have one report, with 2 problems:

Problem 1:
Upon starting the report, I need to read an environment value (something pretty easy to do in Java) to pick the right dataset (there are 2), and also to hide/unhide a particular column in a table (to match the dataset selected). I only know how to set dataset parameters, and don't know how to read the runtime variable and then make the dataset "adapt" to it (as well as hide/unhide a column)

Problem 2:
Once the report is already displayed, I need to show a combo box (dropdown selector) where users can select a value and then click "Run Again", at which point I should do the dataset-selecting and hide/unhide of column again. The dropdown should be on the same page as the main report (with the table) itself.
(This problem is a bit similar to the problem in the post I quoted above).

I guess this is a bit too much for a fully-working set of (sample) code, so I'll appreciate any pointers. My guess is that some javascript will be required, but I'm not sure where to start. The docs don't have anything close to this (at least not that I know of).

Thanks!

Find more posts tagged with

Comments

ANNKRUSE

<blockquote class='ipsBlockquote' data-author="'lexthang'" data-cid="99722" data-time="1335493858" data-date="26 April 2012 - 07:30 PM">
I see another thread (<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/25317-pass-parametervalue-to-data-set-by-drop-down-list/'>http://www.birt-exchange.org/org/forum/index.php/topic/25317-pass-parametervalue-to-data-set-by-drop-down-list/</a>) with some similar points, but I have more questions which may not be the same as his, and plus I don't want to hijack his thread, so here goes. I have one report, with 2 problems: 
 
Problem 1: 
Upon starting the report, I need to read an environment value (something pretty easy to do in Java) to pick the right dataset (there are 2), and also to hide/unhide a particular column in a table (to match the dataset selected). I only know how to set dataset parameters, and don't know how to read the runtime variable and then make the dataset "adapt" to it (as well as hide/unhide a column) 
 
Problem 2: 
Once the report is already displayed, I need to show a combo box (dropdown selector) where users can select a value and then click "Run Again", at which point I should do the dataset-selecting and hide/unhide of column again. The dropdown should be on the same page as the main report (with the table) itself. 
(This problem is a bit similar to the problem in the post I quoted above). 
 
I guess this is a bit too much for a fully-working set of (sample) code, so I'll appreciate any pointers. My guess is that some javascript will be required, but I'm not sure where to start. The docs don't have anything close to this (at least not that I know of). 
 
Thanks! </blockquote>
 
You can select all the fields but only populate report with needed output fields.

lexthang

<blockquote class='ipsBlockquote' data-author="'ANNKRUSE'" data-cid="99744" data-time="1335531018" data-date="27 April 2012 - 05:50 AM">
You can select all the fields but only populate report with needed output fields. </blockquote>
 
That doesn't really help. It's not that I have one single dataset that I need to show/not show a column. It's two distinct datasets with different queries. They may differ only slightly in the output columns, but they're still quite different in their content

Tubal

Problem 1: 
 
I would probably have both datasets, two completely different tables, one for each dataset, put them each in a grid, and hide the one you're not going to use. Name the first grid something like 'firstGrid' and the second one 'secondGrid'. 
 
Where are you getting this environment variable? Will it be passed in the report url? 
 
You can do something like: 
 
"<a class='bbc_url' href='http://www.myhost.com/birt/frameset?__report=report/myreport.rptdesign&__user=6'>http://www.myhost.com/birt/frameset?__report=report/myreport.rptdesign&__user=6"</a> 
 
And this passes the parameter called 'user' and the value at '6'. 
 
In your beforeFactory event for your report, something like this: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>importPackage( Packages.javax.servlet.http );
var request = reportContext.getHttpServletRequest();

user=request.getParameter("__user");

if (user!='6')
{
var firstGrid = reportContext.getDesignHandle().findElement("firstGrid");
firstGrid.drop(); //this line removes the grid from the report object model just for this run}
} else {
var secondGrid = reportContext.getDesignHandle().findElement("secondGrid");
secondGrid.drop(); //this line removes the grid from the report object model just for this run}
}
</pre>
 
Basically, you are creating your report for both datasets, but getting rid of the one you don't want at runtime.

lexthang

Yeah that sounds like a good direction. Thanks Tubal.

The environment variable is something I need to read in Java code just prior to executing the report. I cannot pass it to the URL. Using the same method as your sample code, can I just read the parameter in that beforeFactory block?

Tubal

<blockquote class='ipsBlockquote' data-author="'lexthang'" data-cid="99823" data-time="1335811068" data-date="30 April 2012 - 11:37 AM">
Yeah that sounds like a good direction. Thanks Tubal. 
 
The environment variable is something I need to read in Java code just prior to executing the report. I cannot pass it to the URL. Using the same method as your sample code, can I just read the parameter in that beforeFactory block? </blockquote>
 
I don't see why not. Good luck.

lexthang

<blockquote class='ipsBlockquote' data-author="'Tubal'" data-cid="99818" data-time="1335808602" data-date="30 April 2012 - 10:56 AM">
Problem 1: 
 
I would probably have both datasets, two completely different tables, one for each dataset, put them each in a grid, and hide the one you're not going to use. Name the first grid something like 'firstGrid' and the second one 'secondGrid'. 
 
Where are you getting this environment variable? Will it be passed in the report url? 
 
You can do something like: 
 
"<a class='bbc_url' href='http://www.myhost.com/birt/frameset?__report=report/myreport.rptdesign&__user=6'>http://www.myhost.com/birt/frameset?__report=report/myreport.rptdesign&__user=6"</a> 
 
And this passes the parameter called 'user' and the value at '6'. 
 
In your beforeFactory event for your report, something like this: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>importPackage( Packages.javax.servlet.http );
var request = reportContext.getHttpServletRequest();

user=request.getParameter("__user");

</pre>
 
Basically, you are creating your report for both datasets, but getting rid of the one you don't want at runtime. </blockquote>
 
I need to correct this a bit. The above only works when you're passing some HTTP parameters on the URL. If you want to read the parameters defined in the report, then you'll simply do this instead: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
var user = params["User"]; // Assuming your report has a parameter called 'User'

</pre>