TurnKey Linux Virtual Appliance Library

pentaho design report error

we are taking employees,departments ,designations,but in every table "name" field type is mentioned there, while we join the tables three tables name field types is showing in sql but while applying these query in pentaho report design it's taking as distinct columns , but in sql it's working fine.please give me ideas.

Query is:-

select employees.employeeid, employees.name,designations.name,d.name from employees INNER JOIN designations ON employees.designation_id=designations.id INNER JOIN departments as d ON employees.department_id=d.id


Thanks,
Nilesh

Choices

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)