Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: can i know wht's wrong with tis query?????? from report designer

  1. #1

    Unhappy can i know wht's wrong with tis query?????? from report designer

    can i know wht's wrong with tis query?????? from report designer
    "set rowcount 10
    select Date,round(sum(roi),2) as ROI,round((sum(cost) * $(adj_cost)),2) as Cost
    from KeyPth a,SummaryPth b,CustomerPth c,DatePth d
    where a.KEY1=b.KEY1 and a.KEY1=c.KEY1 and a.DateKey=d.DateKey
    Group By Date
    order by ROI;"

    i created adj_cost as parameter and given default value as 1.0 (double).

    thx

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    Curly braces:

    ${adj_cost}
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3

    Default

    thx guru...i forgot tht braces...

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.