Report Parameter - List is blank

I created a report paramater that returns a dynamic date list. The dataset is just a sql statement that points to a db view that returns a Date value (01-Mar-12)and a Display value (Mar 2012). The problem is that when I run the report on my local machine, the report parameter works fine most of the time. However, when I post the .rptdesign file to the server and run it using the viewer, the report parameter list is blank. I could always hard-code the dates in there but the problem is that when a new month comes up, how can I have it automatically add to the list.

The goal of the report paramater was to allow users to select a Month and based on that selection the data returned would be for that month. I also only wanted about 12 months in the list at all times.

Find more posts tagged with

Comments

mwilliams

Are you using a separate dataSet for the parameter? Or are you using the same dataSet that you use in your report that might be limited by another parameter? Are you getting any errors?

olivia08

I created a simpler example and the dropdown is still empty when I transferred it to another server..

I have 2 DataSets (one that gets date values, the other one is for Active User counts). I have one report parameter that uses the date DataSet to dynamically return a list box of dates. There is a BEGIN_DATE and END_DATE parameter within the Active Users dataset. I have linked the BEGIN_DATE to the "Begin_Date" report parameter and the END_DATE default value has been set to BirtDateTime.addMonth(params["Begin_Date"].value, 1)

When I run the report within birt, it works fine. Then I put the rptdesign file out on the server, and the report parameter list is empty. The server I copy the rptdesign file to is the same server that my DataSouce is defined as within Birt.

I do not get any errors.

Any idea why my list is empty?

PittPolack

Do you think you have a date formatting issue? In BIRT, you can format the date parameter as you want. From the server, is something else passing the date parameter? Maybe it is not passing in the correct format.

mwilliams

Can you attach your design?