Recent content by binboy77

Thanks everyone for your responses. This really throws more light into the issue that there is no straight forward method to achieve the above objective. What i had tried was to use object level security on the field say ssn. but the problem was that when the report is set as refresh on open...

I need to hide some columns in a report that some users don't have the rights to view. e.g if i have a report with SSN along with other columns, only the admin user should be able to see the SSN column in the report while a normal user should not see this column. This should be done in the same...

Universe design is always through the BO Designer(fat client). The reports use this Universe. Now the reports can be generated by either using the BO Reporter(fat client) or the WebI(using IE). Infoview does not support Universe design. Its used to design WebI reports, schedule them, view them...

Full Client(or Fat Client or Thick Client) - Software would be installed on the local PC. These include, BO Supervisor(for administration), BO Designer(for Universe creation), BO Reporter(for creating Reports). BCA(BroadCast Agent) can be configured for scheduling refresh of the Reports...

You should be able to see your local DSN when you try to create a new connection for the Universe fron the File -> Parameters -> Connection option. Make sure that you have a DSN created as System DSN in your local machine and is working fine. Bin

Hi, This feature should work with the Wrap Text feature. Can you elaborate on how you are trying to do this. Bin

Thanks Steve for the valuable tips and the answer to my Q. Thanks Bin

Hi all, I have a very bulky report that has lots of individual tables, filters and formaules (can't avoid). When i change the value of even a single cell, it shows the message at the bottom "Computing Data" and then "Computing Display" and this whole process takes upto 5 mins (100% CPU usage) on...

Hi Steve, In my VBA sql, this field is being fetched as it is from the database where it is a date field. Also i tried to do some string function on it like the substr() function to check if its being returned as a string, but that dosen't work. Even i tried checking if its a date by using the...

hi, i am using the BO ver 6, formatdate() function to convert a date to a string. i am passing a dimension which has date value as the first parameter and "mm/dd/yyyy" as the second. the dataprovider is VBA and the database is DB2. FormatDate(<datedimension>,"mm/dd/yyyy") however, this is...

thanks all, I am using business objects. I suppose this is not the right forum that i have placed my question. i would be putting this Q in the BO forum. Bin

hi, i am using the BO ver 6, formatdate() function to convert a date to a string. i am passing a dimension which has date value as the first parameter and "mm/dd/yyyy" as the second. FormatDate(<datedimension>,"mm/dd/yyyy") however, this is giving me #ERROR. any suggestion on how to rectify this...

Hi all, I am also facing the exact problem as mentioned in this thread. For each section I need to display Page # of #. If I have two section values and first has three pages and the second has two, then i need to display Page 1 of 3, Page 2 of 3, Page 3 of 3 and then again Page 1 of 2, Page 2...

Hi all, I have a cross tab report that goes accross the page and below based on the section delimiter. I have a cell and a table on top of the cross tab to display the section delimiter value and other parameter. I am able to make this cell and table repeat below on every page but not accross...

Can anyone send me a sample code to include the FileWatcher class in my Reoprt in VBA? I need to automate reports based on the presence of a file. Also wanted to know if i can pass report parameters in this file and make BO read them. I was trying with the follwing code in VBA...