Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. binboy77

    Column Level Security

    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...
  2. binboy77

    Column Level Security

    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...
  3. binboy77

    Full Client, WEBI, ZABO, XI

    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...
  4. binboy77

    Full Client, WEBI, ZABO, XI

    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...
  5. binboy77

    run BO reports locally

    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
  6. binboy77

    Row by Row AutoFit

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

    Improving BO Report frontend performance

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

    Improving BO Report frontend performance

    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...
  9. binboy77

    FormatDate() function error - #ERROR

    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...
  10. binboy77

    FormatDate() function error - #ERROR

    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...
  11. binboy77

    format date function error

    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
  12. binboy77

    format date function error

    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...
  13. binboy77

    Reset Page Number for each section?

    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...
  14. binboy77

    Repeat Cells/Tables accross the page

    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...
  15. binboy77

    VBA and FileWatcher

    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...
  16. binboy77

    VBA and Broadcast Agent

    Thanks Sri, Would this work even if the prompts require an active database connection using the ADO? Would the BCA manage it? I have a command button "Run Report" which when clicked executes the SQL of the dataprovider. Thats when the final VB form is completed. So BCA would make these forms...
  17. binboy77

    Shutting off BO Message Prompt.

    Thanks Sri, We are not having the license for SDK. But this is working with the VBA too. But my issue is that i get the message after all the VBA code has been executed and BO is trying to display the data. So as you suggested, i can not turn interactive off and then turn it on again. I tried...
  18. binboy77

    How to Eliminate Blank Pages in PDFs

    BO allows the section also to be started on a new page when there is a change in the section value. Right click on the section and click "Format Section" and then click the check box "Start on a new page" With this you can do away with the "blank cell" you are using and this would solve your PDF...
  19. binboy77

    BusObj WebIntelligence PDF report, data cut off

    Its always better to have enough breathing space within a cell for the text to be displayed correctly when converted to PDF. Bin
  20. binboy77

    VBA and Broadcast Agent

    We have BO reports with VBA as the dataprovider. I use VB forms for user credential validation and also for them to select the database schema, tablename and other details. When i refresh the BO report, all these forms pop up in an orderly fashion and allow users to enter the data. This is...

Part and Inventory Search

Back
Top