Jump to content
We've recently updated our Privacy Statement, available here ×

shuhovivan

Members
 View Profile  See their activity

  • Posts

    13

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by shuhovivan

  1. shuhovivan
    I need that the report could be exported to excel format with the autofilter and a crossbar on separate sheet. So for that purpose i set a "Break Before" property on one of the cells in first row in a crosstab. Works great - crosstab moves to separate sheet, but autofilter dissapears. I use the following properties to place crosstab on the separate sheet: <property name="net.sf.jasperreports.export.xls.break.before.row" value="true"/><property name="net.sf.jasperreports.export.xls.sheet.name" value="Summary"/>[/code]
  2. shuhovivan
    I have a list of tasks groupped by an employee (and every employee has an email). Is there a way to configure the sending of reports so that each employee receives a report containing only his tasks?
  3. shuhovivan
    I'm creating a report with a crosstab. I have a dataset representing a people, regions in which people live and a date of settling in the house. I need to count a number of people by region with the date is today. The report will be exported in excel file. So the result should be (example for today date): 22/03/2017 Region1 123 Region2 162 Region3 323 How could i do that with jasper studion 6.3? Is it possible to remove a "Total" column from crosstab? Or maybe i can apply .XLSX template to report with all formulas?
  4. shuhovivan
    I created a report with a pivot table on a "Summary" band and set "Summary on a new page" in the report properties because i want to summary was on a separate excel sheet. Further i set "Ignore pagination" because i want to all my data was on one page. And in the end I got the pivot table still places on the same sheet with the main data. How could i place the pivot table on a new excel sheet, separate from data?
  5. shuhovivan
    I have a field in my report whose value generated by expression - new SimpleDateFormat("EEEE dd MMMMM yyyy").format(new java.util.Date()). How to make that day of the week was in Russian (or other language, except English)?
  6. shuhovivan
    del
  7. shuhovivan
    >> I guess it is bad idea. You can't understand when your report is empty or when it is broken (error?) I can set up notifications for this purpose, doesn't it?
  8. shuhovivan
    I made a report, put it in the schedule, and set up sending the report to an email. But I do not want to come empty report, if there is no data in the dataset. I've tried to set When No Data Type into No Pages and <NULL>, but it doesn't work.
  9. shuhovivan
    It's a strange that there is no such an obvious feature. Great film, btw :)
  10. shuhovivan
    I have a table which cells fill values from 0 to 3 ( from dataset). I need that cell were painted according to the value. Now I know that a can create a conditional styles for every field in dataset: $F{MONDAY}.doubleValue() == 0$F{MONDAY}.doubleValue() == 1$F{MONDAY}.doubleValue() == 2$F{MONDAY}.doubleValue() == 3So create the same for the rest days of week. But this way is extremly ineffetive and comlicated. What should i use instead of $F{<DAYOFWEEK>} to include all columns into expression? So i could create one style with the four conditional styles and apply it for every column.
  11. shuhovivan
    Unfortunatly, style mode="Opaque" doesn't work. May be i did something wrong? <style name="StyleVacation" backcolor="#A6D3A6"> <conditionalStyle> <conditionExpression><![CDATA[$F{DAY_8}.doubleValue() == 0]]></conditionExpression> <style mode="Opaque" backcolor="#F0F04D" fill="Solid" radius="4" hTextAlign="Left" vTextAlign="Top" pattern="" isBlankWhenNull="true" fontName="DejaVu Sans Mono" fontSize="1"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[$F{DAY_8}.doubleValue() == 1]]></conditionExpression> <style mode="Opaque" backcolor="#94EBB2"/> </conditionalStyle></style><jr:detailCell style="Table_TD" height="30"><textField> <reportElement key="" style="StyleVacation" x="0" y="0" width="50" height="30" backcolor="#FFFFFF"/> <textElement markup="none"> <font fontName="DejaVu Sans"/> <paragraph lineSpacing="1_1_2"/> </textElement> <textFieldExpression><![CDATA[$F{DAY_8}]]></textFieldExpression></textField></jr:detailCell>[/code]
  12. shuhovivan
    Would you explain how can i set color in IF ELSE statement?
  13. shuhovivan
    I created a few conditional styles for a text field in a table cell. The styles contains custom font formatting and background color setting. So the font formatting works great, but background color is not. When i created the styles, i followed these steps: Create the style;In that style create two conditional styles with all settings (font and background);The conditions are:$F{DAY_OF_WEEK}.doubleValue() == 0$F{DAY_OF_WEEK}.doubleValue() == 1Apply the style to my Text Field ($F{DAY_OF_WEEK}).Please help me figure out what is wrong here.
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore