To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=115145
                 Issue #|115145
                 Summary|[SRB] Report based on a querie could not open if there
                        | to much datasets
               Component|Database access
                 Version|OOo 3.3 RC1
                Platform|PC
                     URL|
              OS/Version|Windows XP
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|SRB
             Assigned to|dbaneedsconfirm
             Reported by|ud





------- Additional comments from u...@openoffice.org Wed Oct 20 13:56:05 +0000 
2010 -------
I ran the second time (with different databases)in the same problem. I createed
a report based on a querie with SRB and it worked well. But after the last time
i run the report succesfull, i inserted a new dataset. The next time i execute
the report i got an error message >>the document "...." could not be opened<<.
If i create a "tableview" from this querie and bind it to the same report as
datasource, the report could run without any problem. (So there is a work 
around)

After a little investigation, if i delete the last dataset (Nr. 45), the report
runs again. But if i delete different datasets, the report fails. I have no idea
what is so special at dataset Nr. 45.

It is the same with ooo 3.2 SRB 1.2 and 3.3m11 with SRB 1.2.1

To see what i mean

-open attached database

-go to queries
-double click on "qry_Rezeptbuch"
querie runs without any problem 

-run report "Rezeptbuch" (based on querie "qry_Rezeptbuch")
=> error
-run report "Rezeptbuch_tabelle1" (based on view "tabelle1")
=> successfull

-open Forms
-execute Form "RezeptEingabe" by double click
-delete first record "ID 13"

-go to reports
-run report "Rezeptbuch"
=> error

-open Forms
-execute Form "RezeptEingabe" by double click
-go to last record "ID 45"
-delete this record

-go to reports
-run report "Rezeptbuch"
=> successfull

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

Reply via email to