-
Mater Pages with Header/Footer.
I have a report with a table tied to a dataset. each record in the dataset prints on 2 pages. I would like the header and footer to display only on page 1 of each record. Is this possible? Thanks for the help. Henry Morales Birt 4.5
-
Duplex Report
<p>I need to create a report that has paragraphs with fields from a dataset inserted within the paragraphs. Part of this report is duplex. Is there a way to tell the report when to print on the front side and when to print on the back side of each page ?</p> <p> </p> <p>Thanks</p> <p> </p> <p>Henry Morales</p> <p>Birt…
-
Is there a wild card option in expression builder or suppress.
<p>I am trying to suppress some fields in a row if the first field contains 'NP'. such as.</p> <p> </p> <p>field1 == '%NP%'</p> <p> </p> <p>I also want to use this as a filter in an aggregate group total to exclude the row from the group total.</p> <p> </p> <p>How can I do this ?</p> <p> </p> <p>Thanks</p> <p> </p>…
-
Multiply Integer Value times Float Value
<p>I have a report written in BIRT 4.5 .</p> <p> </p> <p>The table is tied to a dataset which comes from a stored procedure.</p> <p> </p> <p>I have grouped the table by Employee_ID. At the group footer I am trying to multiply 2 aggregations</p> <p> </p> <p> </p> <p>Field 1 "REQS" Data Type = Integer (117) * Field 2…
-
Group table by parameter value.
<p>I have a BIRT 4.5 report with a table from a dataset with 12 fields.</p> <p>The report has a parameter with a list box listing these 12 fields.</p> <p>I would like to group the table by the chosen field in the parameter.</p> <p>How can I do this ?</p> <p> </p> <p>Thanks</p> <p> </p> <p>Henry</p> <p> </p> <p> </p>…
-
Birt 4.5 export xlsx
<p> I have a report in BIRT 4.5 that is grouped by JE#. (Journal Entry Number)</p> <p> </p> <p>Lets say the JE# is 45.</p> <p>When I export the report to PDF, it will print 50 lines per page. So if the Journal Entry has say 70 lines, it will print 50 lines on page 1 and 20 on page 2.</p> <p> </p> <p>If I export it xlsx, It…
-
BIRT 4.5 Radio Buttons
<p>I have a report In BIRT 4.5 with multiple parameters using Radio Buttons for Yes and No choices.</p> <p> </p> <p>How can I display the Radio Buttons Horizontal instead of Vertical.. Parameters currently display:</p> <p> </p> <p>Display JES ?</p> <p> Yes</p> <p> </p> <p> No</p> <p> </p> <p>I would like them dis…
-
Birt 4.5 spacing problem
<p>We went from BIRT 3.7 t0 4.5 . I have a table bind to a dataset. In the detail rows I have text elements with paragraphs. The spacing between the lines of these paragraphs has grown with BIRT 4.5 . The text fields are HTML Dynamic Text . Is there an easy way to fix this or a way to specify the spacing ?</p> <p> </p>…
-
Column sizing question
<p>I have a report with 10 columns. The first 4 columns will always be displayed. The last six coulmns can be hidden via 6 parameters. I would like for the first three columns to always stay the same size when any of the other columns are hidden and for column 4 to stretch across the page in place of any hidden…
-
Print records down and accross in 2 columns
<p>I have a report with a dataset returned from a stored procedure. The data set has 5000 rows with three fields : Car_No Empl_name Empl_Number. I would like to print 2 columns (with all three fields in each) per page. The first column will have rows 1-43</p><p>and the second column will have rows 44-86. The next page will…
-
print 2 columns per page
<p>I am working a on a report with a dataset that comes from a stored procedure. The data set returnd 3 fields with about 1000 records. I would like to have 2 columns per page with each column having the 3 fields.</p><p>the first column will have records 1 - 40 and the second column would have records 41 - 80. This would…
-
Conditional Sorting
<p>I have a report with multiple fields and 2 groups.</p><p>If the second group = "A" I would like to sort by column 3 ascending.</p><p>if the secong group = "B" I would like to sort by column 3 descending.</p><p> </p><p>Is this possible ? How can I accomplish this ?</p><p> </p>
-
hide page header/footer
I have a report that has a table with page breaks. The report is 10 pages long. The Master page has a Header and a Footer with a image in each that print on every page. The page number at the bottom just above the Footer. I would like to hide both the Header and footer on pages 2-8 only. Is there an easy way to do this ???…
-
Page break problem
I have a report with a table tied to a dataset. It is grouped by field 'Group' . There are 6 possibilities, so I added 6 group headers and 6 detail lines (one for each possible group). I did this because each group requires different fields to be displayed in the center of the report. I use the visibility to hide the…
-
Time stamp format problem
I have a dataset tied to a stored procedure. I then have a table tied to this dataset. When I do a Preview Results on the dataset the TimeStamp field shows 'Apr 1, 2008 5:59 AM' In the table I format the field as 'MM/dd/yyyy HH:MM a' but it shows up as '04/01/2008 05:04 AM' The time is not correct. Is this a a problem in…
-
How do I print a check mark
How can I print a check mark using BIRT 3.7.0 ??
-
RUNNINGSUM Question
I have a table with 10 fields. Field "Current_Balance" is what I need to compute. Field "BEG_BALANCE" holds my starting balance which I will use to initialize "Current_Balance" to start. Fields "Debit" and "Credit" must be added or subtracted from Current_Balance in each detail line. Where do I initialize "Current_Balance"…
-
spaces in record are not printing
I have a dataset with 3 records. one field has data such as: ' Vendor Part Number 106B' ' Vendor State Texas' ' Account Number' I have left aligned the field in the detail section of the report. When I print the report, the spaces are ignored and all three fields line up on the left. If I do a 'Preview Results' in the…
-
show percent with 4 decimal places
I have a report displaying a percent amount as '0.009' I would like it to display '0.0090' The formula I am using in the expression builder is : BirtMath.round( ((row["T_NET"]/row["FUNDED_AMT"]) * 100) ,4) What am I mising ?? Thanks BIRT 3.7.0
-
Suppress row based on fields of previous row
I have a table binded to a dataset with 9 fields. In the detail section, I would like to suppress the row if 3 fields are equal to the same 3 fields of the previous row. How can I how this ? Thanks BIRT 3.7.0
-
Column heading in crosstab
I have a report with a crosstab. The column headings have a border that BIRT put in automatically when I created the crosstab. How do I remove or hide this border ?? Thanks BIRT 3.7.0
-
Format currency withHTML
I have a text box with Dynamic Text HTML "The amount you owe is : <VALUE-OF>row._outer["INV_TOTAL"]</VALUE-OF>." where INV_TOTAL is a currency value. What is displaying is "The amount you owe is : 166.6." I would like it to display "The amount you owe is : $166.60." What syntax do I need to get it to format INV_TOTAL as…
-
parameter default
I have a report with 2 parametes. SecurityUserId and Employee_Id. The report runs on a server which passes the SecurityUserId to the report based on who is running the report. Where in the report can I set the default for Employee_Id to SecurityUserId ? The Employee_ID parameter is used as an input parameter for stored…
-
Display groups horizontal
I have a dataset that contains the following data. Plan_Code Plan_Name Amount Start_Date AAA PLAN_A 2.20 1/1/2012 AAA PLAN_A 4.15 2/1/2012 AAA PLAN_A 6.80 3/1/2012 BBB PLAN_B 8.90 1/1/2012 BBB PLAN_B 7.60 2/1/2012 BBB PLAN_B 4.15 3/1/2012 CCC PLAN_C 6.19 1/1/2012 CCC PLAN_C 5.14 2/1/2012 CCC PLAN_C 6.28 3/1/2012 DDD PLAN_D…
-
embedded table
I have a report with 2 tables binded to 2 different datasets. Table_1 has a header section and a detail section. In the detail section of Table_1, I embedded Table_2. Table_2 has a filter equating a field to a field in table_1. The dataset for table_2 has a computed column of Row_Count to count the number of rows. How can…
-
Link 2 datasets
I have 2 datasets that are based on stored procedures. The First dataset has: Employee_ID and Plan_Name. The second dataset has: Employee_ID, Plan_Name, Dependent1 Employee_ID, Plan_Name, Dependnet2 Employee_ID, Plan_Name, Dependent3 Employee_ID, Plan_Name, Dependent4 The second dataset may have any or all of Dep1, Dep2,…
-
display/hide parameter based on another parameter.
I have a report with three parameters. 1. System_ID 2. Employee_ID 3. Employee_Number The report will be called from 2 different systems. (ABC and XYZ) The system calling the report will send the first parameter System_ID a default value (either 'ABC' or 'XYZ' ) If System_ID = 'ABC' then I want the other 2 parameters…
-
suppress tables based on records in first table
I have a report with 4 tables. each table is binded to different datasets. The first table has a computed column called ROW_COUNT to count the number of rows returned. If ROW_COUNT = 0 the table is suppressed and a message is displayed. I would like to use ROW_COUNT to suppress the other 3 tables if the first table is…
-
XML tag for paragraph alignment
I have a table binded to a dataset. In the detail section I have a text box. Inside the text box I have HTML text that has a paragraph. I have a <p> tag at the begining with <BR> at the end of each line of text and a </p> at the end of the paragraph. I would like the paragraph to be lined up on both the Right and Left…
-
Merge Datasets
I have 3 datasets that are created using 3 stored procedures. The 3 data sets have 1 common field. How can I create a forth data set that combines all 3 datasets?? Example: The first dataset has fields Insurance_Name, Coverage_Opt, Coverage_Type The Second data set has fields Insurance_Name, Insured Name The Third data set…
