jndh90
-
Posts
16 -
Joined
-
Last visited
jndh90's Achievements
-
Is this patch now included in the newer versions of Jasper Studio? I downloaded a community edition 6.3 yesterday. I created a basic report with a page header with a couple of text fields but when I export the report to Word the page header is not a Word header. Please assist. Thank you, Jenelle
-
Are you referring to the Left and Top Margins of the Table Property? That would work if the table were static but the other piece of this is that the number of columns in the table can change depending on that the user selects to print on the report.
-
There is functionality to horizontally center in the styles as in: <style name="table" hAlign="Center" vAlign="Middle"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table_TH" mode="Opaque" backcolor="#F0F8FF" hAlign="Center" vAlign="Middle"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_CH" mode="Opaque" backcolor="#BFE1FF" hAlign="Center" vAlign="Middle"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_TD" mode="Opaque" backcolor="#FFFFFF" hAlign="Center" vAlign="Middle"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> Then when I right click on the table element on the design view there is an option to position and center horizontally but this does not seem to do anything. How do I horizontally center the table in the report?
-
Implemented this and works very nicely, thanks again!
-
This is similar to the suggestion from ecanaveras, it works quite nicely. Thank you!
-
Ok, I'll give that a try. Thank you!
-
I don't know what columns the user will select to print. It can be any variation of columns A through F.
-
I am using the table component so that the user can select what columns he wants to see on the report and hide the columns not selected. I am doing this by implementing a boolean parameter for each column and if the value is selected or true then it is printed . Based on what columns he wants to see, I want to sum across those printed columns. So say the columns he selects are A, C, and D and the value for A is 2, C is 4, D is 3 the total should be 9.
-
Thank you for the post, your blog looks to be very helpful and informative.
-
Thank you for commenting. I have made changes within the report query to do what I need it to do.
-
I have a report that shows provider information and client information, when the user selects what client status to see on the report I don't want this to effect how the rest of the report runs. If the user selects Active then I want Active clients to print on the report, if the user selects All I want all clients to print regardless of client status, but if the user selects None this means do not print any clients on the report (but I still want the provider information to print). I am not sure 1) if I need to pass parameter to the report query, 2)if I do how write the sql to not use the expression when the client status is none, 3)if I don't and use the print when expression how to I define the parameter so it knows what All means?
-
For any that are wanting a solution, this is what I ended up doing. I created the header file first and saved it on my local machine. I also loaded the file as a jrxml file to the repository. On my report I add the header file as a subreport. Load the report to the repository and it creates a resource with the subreport. Then I log into Jasper server, search for the report in the repository, right click and edit. I go to control & resources, click on the name of the subreport, this brings me to another page where I can select a file from the repository. I search in the repository for the .jrxml file that I had loaded, save and submit. This replaces the subreport in the resources under the report to the file that is stored directly on the repository and creates a linked file. If I go back into iReports and look at the subreport under the reports resource folder there is an icon with a chain link next to the name of the subreport. Now when I make a change to the file, it will update in my report.
-
Thanks for the response. Not quite following however. Where do I put the full path. I have the ltr_hdr.jrxml loaded to the repository. I've added a subreport to my letter and in the subreport expression put "repo:ltr_hdr.jrxml". I upload the letter to the repository but it won't load the subreport in to the resources folder. Should it load it there? I've tried running the report on the server but I get the same error I've been getting: Error opening input stream for URL: repo:ltr_hdr.jrxml.
-
Here are things I have tried: create a header file and load it to the repository as a jrxml file. On my report reference the jrxml file as a subreport in the subreport expression. Create a header file and load it to the repository as a report. On my report reference the report as a subreport in the subreport expression. I get net.sf.jasperreports.engine.JRException: Error opening input stream from URL in both cases. Must the header file to referenced within the report and loaded to the resource folder or can the header file be referenced outside the report but still in the same location on the repository as where the report resides? Most information I have found says it must be loaded as a resouce under the report. I would like to use this header file on several reports and be able to update the header file once and the reports using this file will also get updated. If I have to load the header file as a resource under each report then this defeats the purpose of updating the file in one location.
-
I would like to create a header file that can be used on several reports in Jasper that are loaded on the JasperServer. In turn I would like to update this header file in one location which inturn will update all the reports in Jasper without having to manually go into each report to update it.
