I am out of the office until Tuesday April 1st. If you have a Brio or InSite issue then please contact Chris Solomon or Peter Houghton. Regards, Steve Hearne ...
Dear All: Has anyone tried the "Prior" function in Brio pivot function? The problem I met is: if I have created a pivot with a side label and a measure, the...
Hello, I searched past messages, but I could not find an answer to this question... Through code, how can I include nulls when creating a limit? Essentially, I...
Give this a shot.... var lim = ActiveDocument.Sections["Query"].Limits["Unique Id"] lim.IncludeNulls = true Thanks - John Morgan Keypulse.com ... From:...
We have a couple opportunities available for consultants with Brio experience. 1. We have a position available for a consultant with BrioONE (Portal, SQR, and...
I am designing an EIS and am trying to decide whether to have users query back to the Database each time they hit a command button (after they have made...
Simplest I can think of is to keep you bqy at the minimal. Do not save data with the file that way it will be downloaded to the client much faster if you are...
Yes, the end user will still be looking at a pretty big file but atleast they won't be waiting for the file to open for a long time. They can cancle the db...
Thanks again, Rami. I think we want to shoot for the best case scenario where the user processes back to the db each time and we get a relatively fast...
Hi everyone I hope somebody can answer me this question. I have Brio version 6.230 and Sybase 11. The OCE was created with the native openclient. Here is the...
I had a strange thing happen. I updated a test file to the new Brio version which uses arrays. Ex: Descp 1, Descp 2 are no longer separate fields but an array...
Sarah, Yes, you can create a query on a sql view. The view will show up as a table that you can drag onto the brio Query window. (assuming that your ID has...
If you are talking about opening a shared doc from a shared drive or something, you should be able to use the solution below. However, if you are accessing the...
Another alternative is to set up variable limits on the query to popup with your choices. Have your EIS logon and process after the user makes his variable...
Vickie, Can;t explain other than "folklore" ;-) Just out of curoisity, what version are you using? I have had simular problems, but this was bac kin version...
Gary, I am working with version 6.5 and reverse programming back to 6.3. What I had to do was rename the original columns (Brio would not let me delete them)...
hi, i have a simple query thats fetches me some rows in the results section when i pass 2 dates as input parameters in the EIS section. These dates are passed...
Vickie, This is sounding familiar. First question, when you say, "Brio won't let me delet them?" What do you mean exactly? Now, I can't substantiate this...
I am looking into configure my existing ODS (version 6.5.1) to use the identity server for authenication. Any suggestion on how to integrate it. How do I...
Hello! I have a simple report that is using an import file to retrieve data. The import file is updated daily. When I go into the report and hit the process...
Hi There, If you add something after using the prior or next function, it should be added 'inside' the prior (or next) label. If you add something outside the...
Thanks Gary and Rodney! I can't see my view in the brio, only see those tables. Do you think that's because of oce setup? Would that be only thing I need to...
Hi There, The first possible option I can think of is to check that the dates you are passing aren't actually compared to timestamps in the database. For...
Might be worth checking the permissions on the view to ensure that the userid that you're using has access to it. Alternatively the view may have been created...
Re Problem 2. If you have two limits on the same day then perhaps the data records have a time stamp. Therefore to collect all records for the same day you may...
Gary, I'm super user of SQL database, I guess I didn't explain my question clearly. My point is that I'm using metatable definition in my oce setup, this way I...
