katepassaro
-
Posts
36 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by katepassaro
-
-
Hello -
I have a crosstab that is displaying data with summary totals being passed from a dataset. All summary totals are calculated within the dataset and passed directly. I would like to highlight the row field and data field if the row field equals a certain value.
Here are the steps that I have taken to try to achieve this:
- Created a style inside the crosstab
- Created a conditional style with a different back color and the conditional expression like this: $V{Region Name1}.equals("Total")
- Applied this style to the row group field in the row group header, and also to the measure field
So far, I have not been able to have the style work. Am I missing a step to allow the fields to be styled? Is this even possible?
Solved! Murphy's law that as soon as it's posted I would solve it - you need to apply the "is styled" value and also set the field to be non-translucent.
-
A co-worker pointed out that multiple detail bands were not introduced until 3.5.2. After updating the compatibility mode settings, this is now working.
-
Hello -
I am working in ireports 5.6, but in compatibility mode as one jasperserver we use needs to be at version 3.5 ireports.
When I create a report with multiple detail bands, after compiling in compatibility mode back to 3.5, all detail bands are erased after the first detail band is included in the report.
Any ideas?
-
Hello -
I am familiar with Jasper for non-Hibernate data sources, but this is giving me a lot of trouble. I cannot get the connection to test successfully from within ireport, even though the configuration data is correct within the application. Here are the steps I've taken.
- Added Jars
- Added Classpath of configuration file to classpath
What am I missing here? Did I add too many jars? I am receiving the following error:
org.springframework.jdbc.datasource.DriverManagerDataSource cannot be cast to org.hibernate.SessionFactory
Here are the jars I've added:
- hibernate-annotations-3.4.0.ga.jar
- hibernate-commons-annotations-3.1.0.GA.jar
- hibernate-core-3.3.2.GA.jar
- hibernate-validator-3.1.0.GA.JAR
- spring-aop-3.0.5.jar
- spring-asm-3.0.5.jar
- spring-beans-3.0.5.jar
- spring-context-3.0.5.jar
- spring-core-3.0.5.jar
- spring-expression -3.0.5.jar
- spring-hibernate3-2.0.1.jar
- spring-jdbc-3.0.5.RELEASE.jar
- spring-jms -3.0.5.jar
- spring-orm -3.0.5.jar
- spring-tx -3.0.5.jar
- spring-web -3.0.5.jar
And here is the text from my xml file (de-identified)
I appreciate any help you can provide.
Code: <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:lang="http://www.springframework.org/schema/lang" xmlns:p="http://www.springframework.org/schema/p" xmlns:util="http://www.springframework.org/schema/util" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.0.xsd"> <bean id="DataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@ip.ip.ip.ip:port:dbname" /> <property name="username" value="username" /> <property name="password" value="password" /> </bean> <bean id="SessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"> <property name="dataSource" ref="DataSource" /> <property name="annotatedClasses"> <list> <value>ourplace.model.Applicant</value> <value>ourplace.model.Person</value> <value>ourplace.model.Agency</value> </list> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean></beans>
-
I had this problem as well. I found that if I made changes to a report, it saved both instances and ran multiple times. We were unable to get an answer to our problem when we reported it. All we could do was delete out that file on the server, re-upload the file and schedule it one time without making changes.
-
I have been battling this report for about a week and it's not that difficult(!)
When I run this report against my datasource, sometimes the "Upcoming" field prints, sometimes it doesn't. Within the same report, it may show up for some groups, and not for others.
I've checked it against the database and can see that there is data present that is not showing up.
Any ideas?
-
I am having a similar problem. I'd like to generate multiple rows of data to fill a page and then go to the next page. For some reason it's refusing to see the white space as usable, but if I remove the white space, it only prints half of the page and then goes to the next one.
-
Hello -
I have a main report with 4 sub reports. The report runs fine when housed locally. I just uploaded and redirected the links to the appropriate places on the server. When I run from within the administrative jaspersoft, the report runs, also if I run the repository version on the server. However, when I try to run via html.flow as I've done successfully with all other reports, I receive a null pointer error.
This is the format I am using that has worked for all other reports.
*I have the correct IP address in place of those zeroes
Any ideas?
-
Just a quick update as I found a solution.
I created three smaller queries to combine the group header element, and a row count from each of the queries and then unioned/summed them. Using this as a where clause for my main report query helped only display headers that had sub query data.
-
Hello -
I have a main report that includes a group header band, and then three sub-reports that are housed in three detail bands. I'd like to not print the group header if all three of the subreports are blank, but I can't figure out how to write a print when expression because it really is the data from three separate queries.
Any ideas?
-
I would think that you would have to cast fake/null data into all the measured columns, and then cast the headings into the appropriate columns.
-
Hello -
I'm not sure if this is possible, I am hoping it is.
I would like the value inside of a crosstab to be a hyperlink that passes the row and column headings as parameters to a detailed report. I have built the hyperlink to the report without parameters, but when I attempt to add in the parameters for the row heading, it says the field isn't found. Is this a limitation of crosstabs?
-
Hm...
So you want that column to show up no matter what, but it may sometimes show up?
Could you provide a bit more of the details of the data? I know I've used fake columns to create such things. (null as "Blue" for instance.
-
I found the answer - so I wanted to post it back here for other people that come across this problem.
I right-clicked on the text field and selected hyperlink.
In the Anchor Name Expression - I entered the field id: $F{Field}
In the Hyperlink Type I selected Reference, and then in the reference field entered in the following:
"https://www.sample.com"+$F{Doc ID#}+"?nav=1"
-
Hello -
One field of my report contains a link to another page. Currently, I have this in the text field expression:
<a href="https://www.sample.com/"+$F{Doc ID#}+"?nav=1">Report Link</a>
Where the three pieces concatenate to create the full link. I have selected "html" in the mark-up drop-down. I am receiving an error because of the format in the text field expression - could you help me identify which piece I'm missing?
Post Edited by katepassaro at 02/27/2012 19:39 -
Yes - this is definitely possible with Crosstab - The order of your columns is alphabetical so they could generate dynamically without a problem.
If you want to have them show up in a certain order that isn't alphabetical - you can add a helper column to the query, and use that as the first column/row grouping, and then put the titles as the second grouping - but then show the width/height of the first grouping as 0.
-
Did you ever get a response to this -
The format I use is "&output=pdf" and that works
-
Hi Raphael -
I apologize - I missed your response. I am using a new version of ireport now - but the xml files are identical from the looks of csdiff.
To further triage the problem, I did the following -
1. Took the working file from the old server
2. Removed all subreports (5)
3. Compared the xml files to ensure they were still identical
4. Uploaded to the old repository and new repository
5. Re-ran from the old and new server
I've posted a top/bottom graphic of the working and non-working version.
I have to cover identifying information (teal) - but the concept is still there that it's not formatting correctly from the same exact file.
The two points I called attention to are where the left header piece is two lines writing over itself - and the project name is printing outside of the background band.
I appreciate any help you can provide to me.
Kate
-
Hello -
I had a report working 100% perfect on an oracle based jasperserver.
I recently did a new server installation on the PostgrSQL database (out of box configuration)
I opened all of the files from the previous repository and then uploaded them as they were onto the new repository. All files run fine with the exception of one report that has several sub reports.
The data is printing over itself even within the same text box and no settings have changed whatsoever. They are the exact same files.
Any ideas why this would happen?
-
Good Morning -
We have about 10 reports on our JasperServer being emailed daily. They all have the same time/date settings and format settings. I have validated that all reports are set to run through at least next year and to start immediately.
Sequential File Names= Checked
Timestamp = Default
Overwrite Files = Checked
PDF = Checked
Output Locale (Default)
Email/Subject/Message all filled out.
Attach Files = Checked
Skip Empty Reports = Not Checked
Some reports are being sent multiple times, and others are not being sent at all. How can I go about researching the problem?
Thank you in advance for your assistance.
Kate
-
Hello folks -
I am trying to find out if there is an option for a crosstab to restrict printing unless all rows can print.
I can change the column widths so that only three columns print, but when the crosstab starts printing a second crosstab for the 4th, 5th and 6th columns, I'd like it to start on a new page.
Am I overlooking something simple?
-
(Bump.)
Any ideas on this? I haven't been able to find a solution.
-
Hello -
I have finally gotten conditional formatting to work within a crosstab based on the help of this thread - http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=47374
My problem is that the formatting is only working in cells for a row header where the cell is not blank - so it's not very neat. I would like all cells for a certain row to highlight (or not highlight) regardless of it they are blank.
Here is what I'd like Column A Column B Column C Column D
Row Header A - Row Sub-Header 1 x x x (No format in all)
Row Header A - Row Sub-Header 2 x (no format in all)
Row Header B- Row Sub-Header 1 x x (all columns color)
Row Header C - Row Sub-Header 1 x x
Row Header C - Row Sub-Header 2 x x
Row Header C - Row Sub-Header 3 x (no format)
Right now it's highlighting the appropriate rows, but leaving the blanks unformatted. I have attached my XML.
Any help would be greatly appreciated.
-
Hello -
I am attempting to use this for my crosstab.
I created a variable in the main report using the main 'row header' field named "row_count"
Then I created a measure named "row_count" with the information you suggested.
Then I created a conditional style with this expression - but I was not able to edit the style name, so I am not able to add this to the drop-down as the style.
When I attempt to compile it says, "Field not found [field name]"
This is fixed.
Post Edited by katepassaro at 07/25/2011 14:13
Printing Pro Chart Widgets
in Products
Posted
Hello,
I have written a report that includes several Pro-Widget Chart Sparklines and Sparkbar charts. They render correctly on the screen when exported to PDF, however when I print the page they are scaled down to maybe 1/3rd the original size. Is there a setting that I can modify on the report side so that these charts remain the correct size when printed?
Thank you in advance for any assistance you can offer.