After upgrading to Brio 6.6.0.51 from Brio 6.5 I receive the following error in all my scripted reports using the -jscript command and a windows based...
Hey Tony, I just tried the -jscript tag in 6.6.0.51 with a file that simply had: Alert(1) ...and saw no problem with it. Just a thought, but it may be that...
Hi Adam, Thanks for the suggestion. I was able to find the errors in my code doing what you suggested. I had duplicate connection code (in my - jscript text...
hi , We are using Brio Enterprise 6.6.2 with Portal 7.0.2 and SQL server 2000 on Windows . Of late whenever we use Brio Insight, Designer or even ODS ...
... FROM ... Don't use a custom sql query. Just limit the second table on the 'otherfield', use the custom sql there (in the limit box) and put in the outer...
Has anyonwe noticed that when you perform a left or right out join of two tables when one of the constraints is "Column_name IS NULL" that Brio is not...
Hi, We are looking for people with hands-on expertise in DSP/Wireless/Telecom/MF/AS400/VC++/C++ Data Structures/.NET/Terradata/Corba/Documentum/ Content...
... Custom ... TABLE_A.field=TABLE_B.field ... Andre, The above example doesn't work. I tried many variations of the Custom Limit SQL on the field in TABLE_B....
Mark, I am ignorant on DB2. That said, (+) is not SQL-92 compliant and is old-school for Oracle. Brio still generates (+) for outer join notation. So, I am...
Ahh, I see your point now. Captuerd SQL below shows the fields on which I want the outer join to occur are specified in the ON portion of the outer join...
Mark, Have you been able to pull off your GOAL via SQL outside of Brio? I am not sure you can do this "AND" on a joined column. ABTW, I have recently run into...
Yes. Can definitely get the extra condition into the FROM using Custom SQL, AND in straight SQL without touching Brio. Results are as I suggested they would...
Ok...found an old post from Adam Franz (Thanks Adam) on using CustomSQLFrom() and CustomSqlWhere() methods of a query section to set the custom sql using...
Is there a way (please!) to globally change the field names in the request line of the query? Here's my problem - We have a slew of applications based upon db2...
joanneci, Once a solution is determined, this is exactly why I stress to my clients the need and use of Meta Topics. It eases the pain of a changing tables and...
joanneci, follow-up .... :-) You can write a script or a VB application that opens each BQY and updates the "Display Name" for a specific request item name. I...
joanneci, This should help you get started. However, if you are referencing the OLD name ANYWHERE in the BQY, you will need to update those references as...
What you're going to want to do is set up loops within each other to go through each request within each query section within each document and look for the...
Hey Gang, I am a newbie when it comes to using Local Results. I am currently in a situation where I have to locally join 5 queries. Anyhoooo ...... I have...
absolutely agree, try not to hardcode the column names wherever possible to avoid this problem. IN fact i would suggest take the time now to set up an ...
i'm a young woman, 20 years old, and looking to get into the porn movie business. i've heard it's easier to get into the biz if you make an amateur movie...
Thanks to all who responded for your help. We definitely need to rethink our strategy. Will probably be changing to generic field names in our DB2 tables. ...
Hi,everyone: I want to know is there a tools in Brio Ondemand Server 6.6 to Count the times of one user log on the Brio Web?Such as it can tell us that user ...
The log files roll over based on the entry in the ODS.ini file (if i recall). Check out the .old file it should have more than 1 record. Also, in order for...
