Generate reports in birt using user input. When input is null, everything should be fetched otherwise corresponding data should be shown?

Yes, you can do that. If the parameter is optional you can't use the Dataset Parameter (with a? In your query), because it will be null.

Instead you have to modify your query using JavaScript.

Yes, you can do that. If the parameter is optional you can't use the Dataset Parameter (with a? In your query), because it will be null.

Instead you have to modify your query using JavaScript. Create a Report Parameter like usual, in this case 'stud_no'. Then add a comment in your SQL that you are reasonably sure is unique, I use something like --$stud_no$, wherever you want your clause inserted.

Then add a script like this to your Data Set, in beforeOpen: if (params"stud_no". Value){ this. QueryText = this.queryText.

Replace("--$stud_no$", "and stud_no = " + params"stud_no"); } This replaces the comment with the clause when the parameter has a value. You can use regex in the search string, and then you can also insert it multiple places if you want.

Thanks @ebirkenes....while searching on google I stumbled upon this method only...solved my problem :) – Pranay Jun 28 at 9:18.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.