|
|
|
|
| Re: report problem [message #519836 is a reply to message #519788] |
Wed, 17 August 2011 03:52   |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Why do you think that this is an urgent issue? Does your report work? I suppose so, because this "symbol" won't prevent it from being executed. So, it is not urgent at all.
Anyway: here's a copy-paste from (I believe) Reports Help (but I'm not 100% sure; I have it in my "home" library, but I don't have Reports installation here). It is a non-linkable query symbol.
Quote:A non-linkable query is a detail query that contains column objects that prevent the query from being linked to via a column-to-column link (when you create a column-to-column link, Reports Builder adds a WHERE clause to your query). If you attempt to create such a link, a message dialog box displays, which prompts you to choose whether to create a group-to-group query (using the parent groups), or to cancel the operation. A non-linkable query displays a non-linkable icon in its title bar (C/D).
Instead, you can create a group-to-group link (when you create a group-to-group link, Reports Builder does not add a WHERE clause to your query) between the two queries and add a WHERE clause to the child query's SELECT statement, using a bind variable to reference the parent column.
For example, suppose you want to create a column-to-column link between the ADDRESS.STREET column in your child query and the LOC1 column in your parent query. You can create a group-to-group link, and then modify the child query SQL statement to say: SELECT * FROM EMP E WHERE E.ADDRESS.STREET = :LOC1
[Updated on: Wed, 17 August 2011 03:53] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: report problem [message #522566 is a reply to message #521913] |
Mon, 12 September 2011 07:09 |
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
|
Senior Member |
|
|
I created one function and used in where clause of a query in reports 6i, but i didn't get any special symbol..
So please conclude that for which types of functions it will come.
This is the function i have created.
create function siv_test_fun(n in number)
return number
is
begin
return n*n;
end;
/ |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: report problem [message #523793 is a reply to message #519784] |
Tue, 20 September 2011 07:51 |
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
|
Senior Member |
|
|
Hi ranamirfan,
Thanks for your clarification,
I am getting the symbol only when i am placing a space between the not equal symbol(< >) in where clause of the query.
If i am not including the space(<>) then the symbol will not appears.
So can you please tell me the reason why it happens with the space.
|
|
|
|
| Re: report problem [message #523821 is a reply to message #523793] |
Tue, 20 September 2011 08:37 |
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
|
Senior Member |
|
|
Quote:
Hi ranamirfan,
Thanks for your clarification,
I am getting the symbol only when i am placing a space between the not equal symbol(< >) in where clause of the query.
If i am not including the space(<>) then the symbol will not appears.So can you please tell me the reason why it happens with the space.
No Idea.
Regards,
Irfan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
