Is it possible to call a SmartCut from within Excel which executes an SQR job and returns the data directly into the Execel spreadsheet? Thanks in advance ...
In a Brio Portal/ Brio Intelligence integrated environment the end users portal account is available to the insight documents using the documented ODSUsername...
... an ... Below is an excerpt from MS Excel's help. From the looks of it, there doesn't appear to be a way to do this cleanly. A link in a cell will only...
I do not know about using a "SmartCut" in Excel, but I do know that you can create a SQR program even in Portal, that creates Excel output, but it would be a...
using these components - excell web query - portal smartcut - sqr job producing csv - excell macro/vba you get the solution the limitation i have found is that...
After seeing Franck's remarks, here are a few extra: (1) if you choose to always return csv files as the default output for SQR jobs, you can set this up in...
True -- you can use a csv file or tab delimited file and not need any VBA or macro code, if you want a plain excel file, however, if you want any special...
In my previous Email i mention to use some Macro/VBA this was to have a complete solution where the user download an excell file (with no data) and this excell...
'Bulk Loading' refers to the requirement to publish many objects into Brio.Portal at one time. For instance, there may be a batch process that runs each night...
Hi All, The Connecticut Brio Users Group (CTBUG) will meet on July 24, 2002 from 9:30-1:30pm at the Hartford Hilton in downtown Hartford, CT. Please send an...
Does anyone know if there any user groups in the Westborough MA area??? Even though I still live in CT, it will be very difficult for me to attend a half day...
We have BrioPortal Database 7.0.3. We have the database tables on SQL Server 2000. We would like to see what users have logged on and when. It looks like table...
Hey all, Has anyone used NotesSQL 3.01 to generate a report in Brio.Report Builder 6.2? I am having some errors when it tries to connect. It reports...
I think you might try parsing the service broker log. It writes out a log entry evertime someone logs in (I think). Not the best solution, but it's workable....
Indeed, you can search through the logs and find information. It is possible to write a simple utility to sort this information for you. This is a common...
Hello, I have just installed Brio Portal 7.0.3 to IBM DB2 6.1 database on Windows 2000 Professional...I installed both Service Agents and Knowledge Server into...
Hi all, I want to set up my own report scheduler under windows. I have done the following so far: 1.) Created bqy files. 2.) In document scripting, added for...
Hello. I was wondering if the there was a way for the portal administrator to track whether an individual report is being viewed, and if so, how often and by...
The next New Jersey Brio Users Group (NJBUG) meeting is on August 14th, 2002 from 9:30-1:30pm at the NJHA Conference Center in Princeton, New Jersey. ... The...
I am looking to provide functionality in the hands of users so that they can select the output under the jobs and delete in Portal environment. Outputs are...
Hi Sankar, I would like to attend for this NJBUG meeting, please register my name and let me know the directions and entry details.... I am stayin at...
Hi all, My team is trying to implement a custom / transparent login process and we've become a bit stuck. What we're trying to achieve is the auto creation of...
Has anyone had experience customizing the parameter collection form for SQR jobs with inputs? I would like the user to be able to select multiple choices for...
to do what you want will require jsp or asp form collection pages. you will have to collect the parameters and then pass, as a smartcut, the paramaters for the...
