while iam running a 10g report using the following code : declare repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(50); BEGIN repid := FIND_REPORT_OBJECT(‘REPORT1′); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, ‘rep_app_oracle_forms’); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, ‘HTML’); v_rep := RUN_REPORT_OBJECT(repid); rep_status := REPORT_OBJECT_STATUS(v_rep); message(rep_status); message(rep_status); WHILE rep_status in (‘RUNNING’,'OPENING_REPORT’,'ENQUEUED’) LOOP rep_status := report_object_status(v_rep); END LOOP; IF rep_status = ‘FINISHED’ THEN –Display report WEB.Show_Document(‘/reports/rwservlet/getjobid’ ||substr(v_rep,instr(v_rep,’_',-1)+1)|| [...]
Answer Question | February 16, 2011 11:58 AM
Oracle 10g, Oracle 10g error messages, SQL Server Report Builder
I am writing a report that breaks on the first 4 fields. That part is working fine. I also want a count for each Group (the 4 fields), and a grand total. Since I want to break on all 4 fields as if they are one combined field, I made a concatenated column (called Break_key) [...]
Answer Question | July 9, 2009 3:51 PM
Report Builder 9.0, Report Builder 220.127.116.11.33, SQL Server Report Builder
I have a SQL Server database of customers that called our company, and now i want to prepare a report that indicates which ones are new to our database. How would I do this?
Answer Question | March 4, 2009 7:52 PM
SQL Server database, SQL Server Report Builder, SQL Server reporting, SQL Server Reports
I am trying to use Report Model in SQL Server Report Builder, but when I run the created report I am getting the following error: “Cannot create a connection to data source ‘dataSource1′. —————————- An error has occurred during report processing.” What can I do to avoid this error?
Answer Question | December 2, 2008 2:58 PM
Report Model, SQL Server errors, SQL Server Report Builder, SQL Server reporting