Contact

Connect: LinkedIn

Website: Pochampalli IT Labs


30 comments:

  1. MFVonBruMonday, 21 March 2016 at 21:43:00 GMT+5:30

    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. Sadakar PochampalliWednesday, 30 March 2016 at 03:21:00 GMT+5:30

      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. Sadakar PochampalliMonday, 21 March 2016 at 22:32:00 GMT+5:30

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

    ReplyDelete
  3. ATuesday, 22 March 2016 at 18:47:00 GMT+5:30

    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. Sadakar PochampalliTuesday, 29 March 2016 at 03:01:00 GMT+5:30

    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. Sadakar PochampalliWednesday, 30 March 2016 at 03:21:00 GMT+5:30

    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. nikith77Thursday, 28 April 2016 at 03:17:00 GMT+5:30

    Hi Sadakar,

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

    ReplyDelete
  7. nikith77Thursday, 28 April 2016 at 03:22:00 GMT+5:30

    Hi Sadakar,

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

    Regards
    Nikith

    ReplyDelete
  8. nikith77Thursday, 28 April 2016 at 03:23:00 GMT+5:30

    Hi Sadakar,

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

    Regards
    Nikith

    ReplyDelete
  9. Sadakar PochampalliThursday, 28 April 2016 at 11:04:00 GMT+5:30

    Nihith, This I have to check.

    ReplyDelete
  10. srinivas adepu's blogFriday, 29 April 2016 at 01:34:00 GMT+5:30

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

    ReplyDelete
  11. Sadakar PochampalliFriday, 29 April 2016 at 09:51:00 GMT+5:30

    Yes,you can.

    ReplyDelete
  12. MFVonBruFriday, 26 August 2016 at 21:45:00 GMT+5:30

    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
  13. UnknownWednesday, 21 December 2016 at 01:31:00 GMT+5:30

    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
  14. VenkataThulasiThursday, 2 February 2017 at 11:31:00 GMT+5:30

    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. Sadakar PochampalliThursday, 2 February 2017 at 11:58:00 GMT+5:30

      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. VenkataThulasiThursday, 2 February 2017 at 12:41:00 GMT+5:30

      Many thanks for your reply. I got it worked.

      Delete
    3. Sadakar PochampalliThursday, 2 February 2017 at 13:08:00 GMT+5:30

      @ 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. VenkataThulasiThursday, 2 February 2017 at 15:24:00 GMT+5:30

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

      Delete
    5. Sadakar PochampalliThursday, 2 February 2017 at 16:14:00 GMT+5:30

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

      Delete
  15. VenkataThulasiWednesday, 8 February 2017 at 17:35:00 GMT+5:30

    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
  16. Sadakar PochampalliThursday, 9 February 2017 at 15:21:00 GMT+5:30

    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
  17. VenkataThulasiFriday, 17 February 2017 at 12:39:00 GMT+5:30

    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
  18. VenkataThulasiWednesday, 22 February 2017 at 14:25:00 GMT+5:30

    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
  19. Sadakar PochampalliWednesday, 22 February 2017 at 14:36:00 GMT+5:30

    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
  20. VenkataThulasiThursday, 2 March 2017 at 13:05:00 GMT+5:30

    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
  21. Sadakar PochampalliThursday, 2 March 2017 at 13:57:00 GMT+5:30

    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
  22. VenkataThulasiThursday, 2 March 2017 at 16:54:00 GMT+5:30

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

    ReplyDelete
  23. Sadakar PochampalliThursday, 2 March 2017 at 18:26:00 GMT+5:30

    Its my pleasure.! Glad I could be of help.!

    ReplyDelete

Subscribe to: Posts (Atom)