Discussions
-
Dynamic Sorting
Hi, One of my report's requirement is to sort some columns dynamically and I know how to do this in BIRT using the Sorting tab from the dataset. But, how can I sort two different columns in BIRT one in Ascending and the other in Descending at the same time ? For example: if (params["SortBy"].value = "Both") { sort by date…
-
Table footer
I am designing a Purchase Order report that has a po and a poline table. If the po has a dozens of lines then the po will require multiple pages. I use a table footer to display the grand total price on the last page. However, how do I display a different table footer at the bottom of the poline table for the other pages.…
-
Custom sort: Data Cube
Hello, I'm trying to custom an attribute in a date cube, but don't allow me, just sort by default ASC, so, I would like to know if this could be possible ? with some script?. I mean by default I got the follow sort A B C D But I would like sort like B D C (No logical sequence.. just custom sequence). Actually I sorted in…
-
Dual group in the same axis for 3D Charts.
Hello, I was wondering if with some java script I could add double group in the same axis, See attach image, Thank you I appreciate your help.
-
Custom sort: Data Cube
Hello, I'm trying to custom an attribute in a date cube, but don't allow me, just sort by default ASC, so, I would like to know if this could be possible ? with some script?. I mean by default I got the follow sort A B C D But I would like sort like B D C (No logical sequence.. just custom sequence). Actually I sorted in…
-
Custom sort: Data Cube
Hello, I'm trying to custom an attribute in a date cube, but don't allow me, just sort by default ASC, so, I would like to know if this could be possible ? with some script?. I mean by default I got the follow sort A B C D But I would like sort like B D C (No logical sequence.. just custom sequence). Actually I sorted in…
-
destroy work queue items
Hi All, How to destroy or delete work queue items which are in Apaused or Dpaused state?r_runtime_state = 4 or 5. I have 1000s of work items like this which need to be deleted. when I use api, it gives me error. DM_WORKFLOW_E_ACTION_NOT_ALLOWED]error: "This operation is not allowed when the state is 'terminated' for…
-
Dual group in the same axis for Charts 3D
Hello, I was wondering if with some java script I could add double group in the same axis, See attach image, Thank you I appreciate your help.
-
Direct publishing to web pages
Excuse the lack of info on my part and the (likely) ignorance of MediaBin terms... I've been working on a project to upload existing images in a SQL database to MediaBin, modify custom metadata, and retrieve the assets to a file share which will be the root of a web subdomain. I've built a loader app which which makes…
-
Colored vertical bar on one side of the report
So I made a report with a vertical yellow bar running down the left side of the report like this:<br /> <br /> <img src='http://i.imgur.com/VfeLIfz.png' alt='Posted Image' class='bbc_img' /><br /> <br /> I did this by inserting a grid and having all my report elements like inside this grid. The I made the grid have a…
-
Need help with passing parameters to BIRT
Hello, I have created several BIRT reports that prompt the user for parameters and then pass them to the sql (using ? placed within the sql). I did this all using the BIRT IDE. BUT, now I need to pass in a parameter in that contains sql, such as myID='1234' and have that placed into the BIRT report sql, and then have the…
-
Auto Legend entry for a Marker Line in a chart
Hi, I am struggling to find a way to automatically add a legend entry for marker lines in my chart. Do we have an easy way out using the designer. Currently my workaround is to add marker line creation using a second series definition with a constant Y Axis value. This automatically adds the legend entry for the center…
-
Scripted Marker Line - How to set Font Size for Caption
Hi all, I have a scripted marker line in one of my charts, which is dynamically set at run time. The marker also has a caption that needs to be set. I am able to setup the caption using getLabel().getCaption.setValue() but unable to control its font. Any suggestions!! inside beforeGeneration function..... center_ml =…