Using a parameter to authenticate against a database

kbog

Hi,

I'm new to Birt and I'm looking for general advice on how to take a url parameter and use it to authenticate access to a report and then possibly send an HttpRedirect upon failure.

I found an example of accessing the parameter in the beforeFactory event. I think I'm good with getting the parameter. But my question is from where (which event) do I access the database and then send a redirect.
My other option if I can not send a redirect is to print on the report the url with a message to go and login first before accessing this report. But I'd prefer to do the redirect.



Do I create a data Source/Data Set and then redirect from there off the return value from the database in a fetch?

Sorry if this is covered somewhere already and I missed it. Thanks in advance

kclark

Is there a reason you need to redirect over other methods? You should be able to use a redirect script to move away from the page. Another way to keep the user from viewing the report is put the entire report in a grid named mygrid and you could do something like this.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
if(params["username"].value != "kclark") {
reportContext.getDesignHandle().findElement("mygrid").drop();
</pre>