SQL Server Report Builder Questions

1

Oracle 10g terminated_with_error
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
asked by:
65 pts.

SQL Server Report Builder: total at the bottom of the group
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 9.0.4.0.33, SQL Server Report Builder
asked by:
65 pts.

Preparing a report on a SQL Server database
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
2,585 pts.

Error message while running a report created in SQL Server Report Builder
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
2,585 pts.

1