Search results for query: *

My problem arises when I try to run a free-hand sql statement directly accessing the DB. the BO report hangs there for about 5 minutes, with only 2 notches going up on the progress bar. and with the message 'analyzing' on the bottom. The report then justs displays the New Report and type pop...

I try to run a SQL statement which plugs directly into my DB. However, after about 5 minutes, the BO displays nothing but the 'analyzing' message. The progress bar moves about two notches and then the display screen asking me if I want to create a new report and what type of report comes up...

Problem: I try to run a free-hand SQL script directly accessing the database, it brings back quite a bit of data. All that happens when I click the run button though, s that BO sorts of hangs there with the 'ANALYZING" message displaying. The progress bar moves about 2 notches after 5...

Problem: When I call my data into the BO report, it automatically sorts it by the account number. However, when I generate the SQL inside the DB, it brings back the data all jumble and radomized. The later is what I actually want as sorting may lead to a "User interferance problem&quot...

My new problem: I have records returned from my DB into a BO report, however, I want to delete certain records. e.g All records that have an Product Code of 999, can I do this? If so, how? Thanks

Howdy: If I was to add a column unto my BO report and create a Sequence Number in this column (like a row number). How would I go about doing this? I searched the help docs and found nothing relating to this. Thanks

Can't get this to work, could somebody please help me out, to export my report out as an excel file from the Macro: Sub BANCO_AUSTRAL() Dim Doc As Document Dim Rep As Report Application.Documents.Open ("c:\BalancsvSheet.rep")...

I currently have a BO report which refreshes on a dailly basis and save/re-writes itself back to the server. Is it possible for this file t export to excel/txt/csv automatically as well when it refreshes? If so, how? Thanks in advance.