Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Need to pass a value from Report Designer to MySQL query. Is that possible?

  1. #1
    Join Date
    Mar 2013
    Posts
    2

    Default Need to pass a value from Report Designer to MySQL query. Is that possible?

    Hi Taqua,

    I am trying to make a report for one of our customer's requirement where we have to show the Total Amount in Words for various fields. I can convert number to words in mysql using a function written by us. But the challenge is, I have to sum up the fields of different records and then convert it to words. This summing up can be done easily in Report Designer by using ItemSumFunction (say Total_Sum) while in the mysql query it is equal to impossible. Is there any way of passing this Total_Sum value from the Pentaho to my mysql query.

    Pl note that I am using a Subreport to carry out this part of my logic.

    If you need, I can send youName:  Subreport image.jpg
Views: 20
Size:  40.5 KB the entire file.
    Last edited by Neels; 06-18-2013 at 09:54 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.