Hi, Too bad, that function is not working on thin html on Brio 8.1. There are number of functions stated in release note that will not work ihtml. so you may...
I am running a query in Brio Query Explorer 6.2. I have set the request line properties to return unique rows but I am still getting duplicate rows in the...
You probably have a join that is generating duplicate matching records. thx, mtk ... From: cdippre [mailto:cdippre@...] Sent: Tuesday, July 01, 2003...
matt_krohn@...
Jul 1, 2003 2:41 pm
10653
This is probably very easy for most, but I am missing something. In the example attached, I want to compare the selected item in the dropdown box to the list...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the briousers group. File :...
briousers@yahoogroups...
Jul 1, 2003 3:25 pm
10655
Hi, Once the flag ( view recommendations) has been set, you need to exit the loop. In 1999 example, first flag is set to true .But since you continue to ...
Thanks Balaji. I needed to add a break to get out of the loop when comparison was true. I appreciate the help. Brooks ... Results ... exit the ... to ... ...
Hello there, I migrating brio queries to new database. My Brio Queries uses stored procedures. The company want to rename them to new database naming. I don't...
Tanjore, You need to delete the stored procedure from the query section, attach to the new database and use the Query/Stored Procedures menu option to select ...
Hello Terri, If I delete my stored procedure. It will affect my pivot and report section. Without affecting it can we do any other way. Thanks, Tanjore ... ...
Tanjore, As long as you are using the same column names in the new stored procedure, deleting the stored procedure will not affect any other sections. Please ...
Hello Terri, I got you now. I will try that. It makes sense. Thanks, Tanjore ... procedure, ... Please ... procedure from ... Procedure - ... report ... to ...
I'm trying to use a variable that holds a value to highlight exceptional values using the spotlighter instead of "hard-coding" the actual value. For example,...
I don't think you can use a variable in the spotlighter. There was a similar question a few weeks ago and a work around was suggested. You can create a ...
Hi All, I have a strange problem when scheduling a report in BCS. I have a report with around 13 query sections and results. It has local results and joins....
I'm trying to do it in a table that's created from a Results section. Thanks. ... Section? ... coding" ... 1000 ... follows. ... include ... value ... ...
Hi ! I'm facing problem when using 'OR' instead of 'AND' which is default between the limits. I'm creating limits to the Query Section dynamically using the...
Is there a way in Brio to limit a user to selecting only three items on a list box? There doesn't seem a way to in the OnClick event for a list box to either...
Mike, You should be able to validate against Listbox.SelectedList.Count to get the current number of selections. When this count is greater than 3, then pop-up...
Yes, but how do I get "that item", i.e., the item clicked on that caused the event? In the properties for a list box I can get all of the selected items, but...
Could you stop checking for more selections once you have reached three? e.g. if count <= 3 {save your selections somewhere - in an array perhaps} if count >3...
This example is from the online help under LogicalOperator (property) The following example shows you how to create a first limit equal to "Books" and create a...
Hi, How to get distinct values ( not counts) in Query section? ===== Have a Good Day & Take Care, Regards, S.Vidhyaa __________________________________ Do you...
In the Query section, go to the menu bar and click on Query --> Options. When the dialogue pops up, check the Return Unique Rows check box. This will cause a...
Hi, Since some time we are trying to get the Brio V8 software to test the installation/migration and new features before making the decision to use V8 on our...
At my current job, I have become an expert in a product called MITI SQR3 Workbench. We typically refer to this tool as "SQR." Looking at jobs that are open...
