Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
nikhilchawla Absent Member.
Absent Member.
137 views

idm_rpt_cfg.idmrpt_identity_v fields are not read in IReport


Hi,

I'm trying to create custom report via IReport.
But when i'm writing this query :

SELECT
idmrpt_identity_v."first_name" AS idmrpt_identity_v_first_name,
idmrpt_identity_v."last_name" AS idmrpt_identity_v_last_name
FROM
"idm_rpt_cfg"."idmrpt_identity_v" idmrpt_identity_v


It is not able to read the selected fields. Do i need special
permissions to read from views ? This view contains 6 Rows of data.


--
nikhilchawla
------------------------------------------------------------------------
nikhilchawla's Profile: http://forums.novell.com/member.php?userid=124409
View this thread: http://forums.novell.com/showthread.php?t=454873

Labels (1)
0 Likes
2 Replies
Anonymous_User Absent Member.
Absent Member.

Re: idm_rpt_cfg.idmrpt_identity_v fields are not read in IReport

nikhilchawla,

It appears that in the past few days you have not received a response to your
posting. That concerns us, and has triggered this automated reply.

Has your problem been resolved? If not, you might try one of the following options:

- Visit http://support.novell.com and search the knowledgebase and/or check all
the other self support options and support programs available.
- You could also try posting your message again. Make sure it is posted in the
correct newsgroup. (http://forums.novell.com)

Be sure to read the forum FAQ about what to expect in the way of responses:
http://forums.novell.com/faq.php

If this is a reply to a duplicate posting, please ignore and accept our apologies
and rest assured we will issue a stern reprimand to our posting bot.

Good luck!

Your Novell Product Support Forums Team
http://forums.novell.com/

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: idm_rpt_cfg.idmrpt_identity_v fields are not read in IReport

On 04/20/2012 07:16 AM, nikhilchawla wrote:
>
> Hi,
>
> I'm trying to create custom report via IReport.
> But when i'm writing this query :
>
> SELECT
> idmrpt_identity_v."first_name" AS idmrpt_identity_v_first_name,
> idmrpt_identity_v."last_name" AS idmrpt_identity_v_last_name
> FROM
> "idm_rpt_cfg"."idmrpt_identity_v" idmrpt_identity_v
>
>
> It is not able to read the selected fields. Do i need special
> permissions to read from views ? This view contains 6 Rows of data.
>
>

Greetings,
When a report is running you can only utilize the views not the
tables. Also you have to do it as the "View" user => idmrptuser



--
Sincerely,
Steven Williams
Lead Software Engineer
NetIQ
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.