-
field is a list of comma separated values
I have a dataset created from a stored procedure. The procedure returns 3 fields. Life_Ins, Empl_name, Bens. Life_Ins contains a list of comma seperated values such as "Ins1,Ins2,Ins3". Bens contains a list of comma seperated values such as "Spouse,Son,Daughter,Aunt,Uncle" How can I get the values in Life_Ins and Bens to…
-
set Parameter default using SQL
Is there a way I can I set my parameter default using SQL ?? I have 2 input date parameters (Start_Date and End_Date) that are binded to a Dataset. The dataset is then displayed on my report. I would like to set the default date to a date selected from a table such as: "Select Max(PERIOD_END_DATE) from PERIOD_DATES where…
-
use dataset item for parameter default value
I am working on a report that lists employee information returned from a stotred procedure. We'll call this dataset "dsEmpl_Info". dsEmpl_Info is linked to parameters "Start_Date" and "End_Date" both of which are input Date type parameters. They each have a date picker to select dates. I also have datasets "dsSTART_DATE"…
-
Aggregation cell is blank
I have a report with a table binded to a dataset. The dataset is populated via a stored procedure. I then inserted a grid under the table and binded it to the same dataset. I did this so I can display text labels and summary totals after a pagebreak without displaying the table header. The table displays data for customers…
-
Group page break fproblem using BIRT 3.7.0
I am having a problem with page break inside a group. I have a report with 1 group in it. I would like to print as many groups as possible per page and if the entire group does not fit at the botom of the page, that group should start on the next page. In the body I have a table binded to a data set. Below the table I have…
-
convert datetime to string
Hi I am new to BIRT and am working on a report that uses a stored procedure for my dataset. One of the fields being returned "Date" is returned as a datetime field in the format "MMM dd, yyyy hh:mm AM". Another field being returned is a string field we'll call "Type". I need to create a computed column that is of string…
