Current Position:Home > No data found when adding column link to classic report

No data found when adding column link to classic report

Update:10-11Source: network consolidation
Advertisement
Hi,
Oracle 11g r2, APEX 4.1.1.00.23.
I have some classic reports.
I go to Report Attributes, then I click Add Column Link in the "Tasks" right menu, it adds me a column link, I just add some text for the link and a page to go to.
Then I run the report and I get :
report error:
ORA-01403: no data foundTested with several classic reports on multiple pages.
Debug mode shows me :
0.43816     0.00240     ...Execute Statement: select distinct [...] order by 3,11 ,4
0.44056     0.00162     print column headings
0.44218     0.04816     rows loop: 25 row(s)
0.49037     0.00141     report error: ORA-01403: aucune donnée trouvée
0.49175     0.00078     Computation point: After Box BodyWhen I run the query in my favorite tool, I get expected results.
Did I missed something ?
Thank you.
Yann.

The Best Answer

Advertisement
Yann39 wrote:
<font size="4">Is it an APEX bug ?</font>
- Create a new Region of type Classic Report, then set Region source as :
begin
return test_return_query;
end;- Run the page, the report works as expected
- Go to Report Attributes and click Add Column Link (and just specify a text for the link and a page to go to).
- Run the page, you should get the error !This might be unorthodox but try wrapping your returned query within an SQL statement, like so:
   begin
      return 'SELECT t.* FROM ('||test_return_query||') t';
   end;
I can reproduce it on oracle.apex.com if needed...If my suggestion doesn't work, I think this might be the only option. You could create a new forum posting with the word "BUG" in the title, along with a link to this thread and the relevant workspace details (with guest developer credentials).
  • No data found when adding column link to classic report Update:10-11

    Hi, Oracle 11g r2, APEX 4.1.1.00.23. I have some classic reports. I go to Report Attributes, then I click Add Column Link in the "Tasks" right menu, it adds me a column link, I just add some text for the link and a page to go to. Then I run the

  • Show / Hide DOWMLOAD link in classical report based on user rights Update:11-30

    Hi, using apex 4.1. How i can display or hide download link in classical report based on user rights . The User who has download rights ,can download the data from classical report Otherwise it should hide. I have passed the code in authorization sch

  • How to insert data into newly added column Update:11-30

    Hi all, i am having a doubt how to insert entries into newly added column.. i created a table with two columns and inserted the data into them then i altered the table by adding additional column.now i want to insert data into that..plz tell me how t

  • Column link in interactive report to run procedure and refresh Update:10-11

    I have an interactive report which displays a report based on a table. This is a summary table populated overnight from some complex spatial analysis, which takes a few hours to run. I have a requirement to allow the user to refresh one row in this t

  • Problem with download link for a BLOB Column in a "Classic report" Update:10-11

    I am having a problem where I cannot make a download link for a blob column function in a "classic" (non-interactive) report. I went through the tutorial on this topic and it was great help it working out the minor bugs, but I get a 404 error (a

  • Execute a DML process after user selects a column link in a report Update:10-11

    APEX 3.2 / RDBMS 10GR2 I have written a non IRR report that displays several rows of data. The first column of each row has a defined column link uniquely identifying the row. When a user selects one of the rows via the column link, a "hi fidelity&qu

  • Column Links in Apex Reports Update:11-30

    I am using version 4.0 of APEX.  My question concerns linking to other APEX pages from a report.  In APEX we link to another page, which may be a form or another report, by using a column in the report as a link column.  Any column may be used to tra

  • Problem adding column in an interactive report Update:10-11

    Hi all I am dealing with many interactive projects in my application. Sometimes I have to add a column to the interactive report. When I do so, the column doesn't appear in the interactive report...On the page I have to click on "Actions" then g

  • Download column link to SQL report Update:11-30

    Hi , I am using apex 4.1. I have a SQL report  with blob image column also . And along with the image i need to add download link as a column can some one please suggest me how to do it. Thanks Raghavraghav1212 wrote: I am using apex 4.1. I have a SQ

  • How to make newly added columns appear In IR report Update:11-30

    Hi. I am using APEX 4.0.1. I've created an IR report and then, subsequently, needed to add several column sto the underlying SQL query. When I save the changes, APEX tells me that it will add the new columns and that I need to run the IR report and e