Contact

Connect: LinkedIn



30 comments:

  1. Hello Sadakar,

    I have a report which exports data to excel and merges with an existing excel workbook. I would like the rows in a table beginning on row 23. How can I code for this in an expression?

    regards,

    Michael

    ReplyDelete
    Replies
    1. Hi Michael,
      Could you have a look at this solution given by Jasper ? (I had opened a thread on your question)
      http://community.jaspersoft.com//questions/981491/start-excel-export-16th-row-table-output-or-grid-output-created-using-detail-band

      I didn't try it yet, I will test in sometime.

      Delete
  2. Hi Michael, I will give a try and let you know my finding on it.
    Thank you.

    ReplyDelete
  3. Hi ,

    I have to create a new talend job that add a new column in target table. I have to implement auto-incremental logic in the job ...

    So that I have to get the maximum id plus one every time I insert a value in the table for each time running the job ...

    For example , If i run the job first time i have 100 records loaded to target table with max id (key is 100) - (so 100 records inserted)

    Next time if i run the job for next set of data's for inserting 10 new or updating 10 old data, my key should be start as 101 to 110 for insert and same key shud be updated again in case of update job... Not again from 1 to 100 ... How to achieve in talend ... can u you suggest me ?

    in tmap component can be achieved or which component to be used ? and also whether to use context / variable / expression ?? give me steps to achieve

    ReplyDelete
  4. Hi Michael, I tried for it but no luck so far in getting the functionality, Did you find any alternative solution for this ?
    Thanks,
    Sadakar

    ReplyDelete
  5. Hi Michael,
    Could you have a look at this solution given by Jasper ? (I had opened a thread on your question)
    http://community.jaspersoft.com//questions/981491/start-excel-export-16th-row-table-output-or-grid-output-created-using-detail-band

    I didn't try it yet, I will test in sometime.

    ReplyDelete
  6. Hi Sadakar,

    Can we pass a file with list of values(XLS) to a report as parameter in jasper server

    ReplyDelete
  7. Hi Sadakar,

    How can I pass values form a file (xls) to jasper reports as parameter

    Regards
    Nikith

    ReplyDelete
  8. Hi Sadakar,

    How can I pass values form a file (xls) to jasper reports as parameter

    Regards
    Nikith

    ReplyDelete
  9. can i get Quick training on JasperSoft, like with in hours.
    my background is Java/J2EE and Tibco BW/BE

    ReplyDelete
  10. Hello,

    I am attempting to merge an excel exported file from JasperSoft studio 5.6.1 with a macro-enabled excel file. However, when I use the "Add JasperReports Server Resource", other file types are not permitted. What is the proper procedure for uploading macro.xls

    Is the macro file needed in the local studio folder structure and gets compiled together with the .jrxml OR does it exist on the JasperServer as a resource that is retrieved when the report is executed?

    I receive the Error Message

    net.sf.jasperreports.engine.JRException: Input stream not found at : /Folder/Resources/macro.xlt

    thanks again for your help!

    Mike

    ReplyDelete
  11. Hi Sadakar,
    I have created a report. I made a few changes to the sql at jasper studio and published it. I cannot see the applied changes to the dashboard in the browser. i have cleared the browser cache but still i am having the same issue. Now if I create a new report with a the new SQL it is working fine. Any way we can flush the cache memory...? please let me know.

    ReplyDelete
  12. Hi Sadakar,

    Good Morning. I have a requirement wherein I need to show a dynamic progress bar in the report. For example, if there are 100 files present in the system and 65 files were already processed, I need to show a progress bar with how much percentage of files were processed (in this case , 65%). Is it possible to achieve this in Jasper reports?

    ReplyDelete
    Replies
    1. There is no direct component(chart or widget) available in jasper but I would ask you take a look into CVC component and embed progress bar chart from high chart visualizations library or supported java script library.

      Hope this helps you.

      Delete
    2. Many thanks for your reply. I got it worked.

      Delete
    3. @ Venkat : Are you talking about dynamic progress bar or a percentage chart component from existing charts ? What did you do get it worked ?

      Delete
    4. Dynamic progress bar. I used the CVC and there is a default component called "Radial progress".

      Delete
    5. Glad you had get it worked. Hadn't looked into this earlier.

      Delete
  13. Hi Sadakar,

    I am trying to create a hyperlink report using HTML5 Charts. I am using Column Spline chart type and when I click on one of the measures, it should navigate to webpage/subreport. But, for some reason I am not able to get the hyperlink work. I configured the hyperlink property in "Chart data" section for each measure. Could you please help me with the same. ?

    ReplyDelete
  14. Hi Thulasi,
    Take a look at this page : http://community.jaspersoft.com/blog/drill-down-functionality-example-html-5-charts-jasper-ireport

    Check whether these properties configured properly or not.!
    hyperlinkType, hyperlinkTarget, _report parameter for drill down report and other parameters if any.

    ReplyDelete
  15. Hi Sadakar,

    Thank you for your inputs. I got it worked. However, I have another doubt regarding hyperlinks. I can able to hyperlink to other reports present in the Jasper server without any problem. What if I need to hyperlink to third-party application?
    We have an Enterprised business application to which Jasper reports are integrated. Now, we have a requirement wherein we need to hyperlink from Jasper report to one of the Business application page. The Application page URL will change from one environment to another (like UAT, SIT, TST and PROD).
    Is it possible to do hyperlink like this?

    ReplyDelete
  16. Hi Sadakar,

    One of my report uses query that has "WITH" clause in it. The query runs fine in SQL developer tool but when I place the same query in Jasper studio, i am getting error on "WITH" keyword. I know that in Jasper server we need to change the validateSQL property to adopt "WITH" keyword. But, how to set this up in Jasper studio tool ?

    ReplyDelete
  17. I tried looking into Editors from Preferences but could not find a place where we can apply/put similar or same property in studio.

    ReplyDelete
  18. Hi Sadakar,

    One of the report requirement needs multiple subreports to be exported to Multiple sheets in Excel. Though I achieved it, problem arises when any of the subreport has more than one page. What I need is, one sheet per subreport, but it displays multiple sheets for single subreport itself.

    I used net.sf.jasperreports.export.xls.one.page.per.sheet=true in Main report and selected "Ignore Pagination" in all subreports.

    ReplyDelete
  19. Hi Thulasi,
    Refer this blog site : http://jasper-bi-suite.blogspot.in/2013/10/export-report-output-to-multiple-sheets.html

    Download the example I have given and publish it to jasper server and check data is exported to multiple sheets or not.

    If you see data is exported to multiple sheets with the given example, replace table components with your sub reports.

    Hope it helps you.!

    ReplyDelete
  20. Thank you Sadakar !!. I got it resolved from one of your discussions in Jaspersoft community !!

    ReplyDelete