Brio provides Document scripts which allow to autorun reports. I don't have any documentations about this and the help doesn't provide to much help for this...
briolist is a discussion list for users of the Brio reporting tool. <br><br>This list is owned by Paul Taylor. Send any questions you have about the list to...
I have a remote user who gets only a blank report when he tries to open an intranet query. I can open the same queries successfully at this end. We've tried...
I found this information, it might be usefull for what you are trying to accomplish.<br><br>Brio added a way to have an auto-logon link to the ods. This is a ...
Is there anyway to get the audit options set in 5.5.6 (or 6.x) without the user opening an existing data model or query? I'm think maybe there might be ...
Ken,<br><br>I did a little testing on this and found the problem lies in how you have the datamodel set up. <br><br>Click on 'Datamodel' and 'Datamodel ...
I use the following code in Sybase. Basically, just get the year part YY, add it to '1/1/' to get a string like '1/1/00'. (Sybase date brackets <49 <br>to...
Hey, can I run a question by you, I looked at the explains on append<br>in the group and also in the manual and I don't think there's enough<br>detail on the ...
Ed,<br><br>After you process both queries, go to first query section, right click in the white space under the word 'Table' in the tree control section, and ...
I'm looking for a way to take the results of two querys in a 6.0 file and combine them within the file. For example, I may be quering a premium star schema in...
Hi Raj,<br><br>It's me, Rikki. Here's an alternative. When setting up your limit for WW, instead of loading values from the database, change it to "Load From ...
If the relationship between the workweek for which the report is run and the date you are running it are constant then you can create a custom limit in the...
Hi,<br><br>I am using Brio 5.5.6<br>I have a query which is scheduled to run once a week.All I have to do is change the Workweek to the next new workweek. Eg....
The mail account name is set up in the preferences file for the Admin tool. Open the Admin tool, Edit-Preferences-Mail Tab. Update the user account who sends...
Here is another way to change a julian date back to date format in 6.0:<br><br>(ToDate ( Substr ( ToChar(Julian, "" ), 1, 2 ) + "011" ) ) + ( Mod ( Julian,...
To change a date in month/day/year format to julian in 6.0, use the following:<br><br>ToChar(datefield,"yy") + ToChar( datefield - (ToDate("01/00/" + ToChar( ...
Email sent from the Broadcast server contains "Reply to mailaccount" in the header where mailaccount is the account used by the scheduler to send mail. I do...
You could add sql in the Post Process area of the Audit Options (under Data Model Preferences) that would load the trigger into the repository. <br><br>If you ...
I was asked to post this by another briouser:<br><br>To convert an SQL Server 6.5 5 character string julian date to a Brio Datefield:<br><br>For example, 99003...
Disclaimer: Any opinion/comment expressed here are<br>soley my own. <br>--------------------------------------------------<br>I have a problem with 6.0.2.10...
Cynbad2_99,<br><br>I found the following information. Hope it helps:<br><br><br>Processing Multiple Jobs in a Single Day<br><br>The following applies to ...
Teri,<br><br>I've attached a picture illustrating the drill up / drill down in 6.0. Click on the Photos link on the side. It definately works better than ...
I do however have a question for you on the 5.4.<br>> version On the drill in<br>> capability:<br>> I have a report that displays a category name ...
Mr. Nicknish,<br><br>I am a Brio developer in Houston. I've been working with the tool for about a year and a half, most of which was spent doing tech support...