Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Problem with Jasper/Microsoft SQL/Pentaho w/Variables

  1. #1

    Default Problem with Jasper/Microsoft SQL/Pentaho w/Variables

    Hallo all,

    I am having a problem creating reports that accept string type variables; I am using Pentaho 1.2.1 Build 625 GA, iReport 2.0.0, and Microsoft SQL 2000.

    I can create reports that accept numerical values as parameters passed via the URL, but I'm at a loss as to how to make String parameters work.

    My working SQL Code looks like this:

    Code:
    SELECT  Key, Make, Model, Year, Class
    FROM    dbo.Equipment
    WHERE Class like 'A51%'

    Notice that the string on the last line is enclosed by single quotes. This works fine in the Microsoft Query analyzer.

    Yet, when I go to create a report using iReport, it wants double quotes, which Microsoft SQL doesn't like, and if I put single quotes, it gets treated as a single character.

    Any ideas?

    Thanks,

    -Daniel
    Have you hugged your computer geek today?

  2. #2
    Join Date
    Nov 1999
    Posts
    459

    Default

    Hi Daniel,

    string parameters in SQL work like this:

    where QUADRANT_ACTUALS.REGION={PREPARE:REGION}

    Hope that helps,
    Jens

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.