Home » Developer & Programmer » Reports & Discoverer » report problem
report problem [message #519784] Tue, 16 August 2011 23:13 Go to next message
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
Member

hi all,

what is the meaning of below symbol in below picture that marked in circle

thanks for all in advance.

  • Attachment: Capture.PNG
    (Size: 25.64KB, Downloaded 960 times)

[Updated on: Tue, 16 August 2011 23:19]

Report message to a moderator

Re: report problem [message #519788 is a reply to message #519784] Tue, 16 August 2011 23:47 Go to previous messageGo to next message
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
Member

hi all please help me ,
I have made some modifications to the queey(report) and pasted the modified query in the existing report and all columns names are changed and one new symbol came that i marked with circle in below picture .
what is meaning of symbol marked inside the circle of below picture?

Its urgent..

thanks for all in advance.
  • Attachment: Capture.PNG
    (Size: 25.64KB, Downloaded 944 times)

[Updated on: Wed, 17 August 2011 00:35]

Report message to a moderator

Re: report problem [message #519836 is a reply to message #519788] Wed, 17 August 2011 03:52 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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 #519847 is a reply to message #519836] Wed, 17 August 2011 04:13 Go to previous messageGo to next message
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
Member

thanks for reply littlefoot,

please can u explain clearly it clearly.

but am using only a single select statement in my query (report)

[Updated on: Wed, 17 August 2011 04:29]

Report message to a moderator

Re: report problem [message #519850 is a reply to message #519847] Wed, 17 August 2011 04:27 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Explain what? What did you not understand? Now you have the keyword ("non-linkable query") so - Google for it!
Re: report problem [message #519898 is a reply to message #519850] Wed, 17 August 2011 08:29 Go to previous messageGo to next message
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
Member

hi littlefoot
I made a search in google but i got the same data what yoyu have posted .

and my querry6 is having only single select statement .
am getting this symbol when am trying to place this modified query in place of old query (report).
and one more thing for old report am not having this symbol.

Re: report problem [message #519899 is a reply to message #519898] Wed, 17 August 2011 08:42 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, but that really is not a problem. The report will run successfully, regardless that symbol. What else do you want?
Re: report problem [message #519908 is a reply to message #519899] Wed, 17 August 2011 09:24 Go to previous messageGo to next message
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
Member

The report is running successfully but i want to know the meaning of that symbol just for knowledge purpose (am new to reports just I have started my carrier in reports)
Re: report problem [message #519909 is a reply to message #519908] Wed, 17 August 2011 09:26 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The meaning is described in my first answer to your question.
Re: report problem [message #521913 is a reply to message #519908] Sun, 04 September 2011 01:36 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Quote:

The report is running successfully but i want to know the meaning of that symbol just for knowledge purpose (am new to reports just I have started my carrier in reports).


Please find herewith attached screenshot.
/forum/fa/9315/0/

As my observation.

when you used function in a Report WHERE clause then this symbol 'll appear & when you remove this it'll disappear.Try it.



Regards,
Irfan

  • Attachment: Symbol.PNG
    (Size: 32.53KB, Downloaded 1827 times)
Re: report problem [message #522566 is a reply to message #521913] Mon, 12 September 2011 07:09 Go to previous messageGo to next message
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 #522642 is a reply to message #522566] Tue, 13 September 2011 01:16 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

What do you mean by "which types of functions"?
Re: report problem [message #522697 is a reply to message #522642] Tue, 13 September 2011 03:41 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
I used the above function in where clause of the report query, but the report doesn't displays the special symbol. So can you please tell me the reason why it is not happend...
  • Attachment: Reports.png
    (Size: 316.27KB, Downloaded 933 times)
Re: report problem [message #522714 is a reply to message #522697] Tue, 13 September 2011 05:31 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, functions in WHERE clause have nothing to do with a non-linkable query symbol.
Re: report problem [message #522726 is a reply to message #522714] Tue, 13 September 2011 06:25 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Quote:

As far as I can tell, functions in WHERE clause have nothing to do with a non-linkable query symbol.


Yes.Littlefoot you are right.

Please find herewith attached screenshot.
/forum/fa/9345/0/

Select empno from Emp
where empno < >100 )


I analysis again why this symbol came.
First - Put < > (Not Equal to sign with space)
Second - then Click to Parameter Form
Third - Again click to Data Model then this symbol 'll Show.

Regards,
Irfan

  • Attachment: Symbal.PNG
    (Size: 29.70KB, Downloaded 1728 times)
Re: report problem [message #522743 is a reply to message #522726] Tue, 13 September 2011 07:32 Go to previous messageGo to next message
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
Member

hi all ,
this symbol also comes when you are using case in select statement

ex  :
select case when deptno=10 then 1 else 0 end from emp

and when you are using single row sub query in select statement

ex:
select empno,(select empno from emp where empno=7902) a from emp



Re: report problem [message #523793 is a reply to message #519784] Tue, 20 September 2011 07:51 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: How to remove empty line in output
Next Topic: What will be best design of report?
Goto Forum:
  


Current Time: Thu Mar 28 15:39:42 CDT 2024