Search results for query: *

Anybody experience this problem before?

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...

thanks

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...

I got it to work, not exactly like this, cause my data is coming directly from the database on a SQL statement. But using what you have given me, I got it to work. Thanks Again.

okay cool. Forgive me, I'm kinda new to this whole BO thing, how would I go about deleting a record with multiple conditions, eg. = <productcode> <> '999' && <amount> > 0 thanks

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

This worked!, thanks for the help.

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

Does anybody know how to solve this? I need a solution to this ASAP.

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 (&quot;c:\BalancsvSheet.rep&quot;)...

I need to know how to run the macro automatically every the report refreshes, does anybody know how? thanks

Would it be possible to edit my code and do the following: Application.Documents.Open(&quot;E:\TEMP.rep&quot;) Application.Documents.Open(&quot;E:\TEMP.rep&quot;).Refresh Application.Documents.Open(&quot;E:\TEMP.rep&quot;).Save Application.Documents.Open(&quot;E:\TEMP.rep&quot;).SaveAs...

VBA ??? A Macro currently does this, is it the same thing? sorry, I'm pretty new to all this, code of Macro: Application.Documents.Open(&quot;E:\TEMP.rep&quot;) Application.Documents.Open(&quot;E:\TEMP.rep&quot;).Refresh Application.Documents.Open(&quot;E:\TEMP.rep&quot;).Save...

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.