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: *

  • Users: Shoot
  • Order by date
  1. Shoot

    Pull and display partial data

    Create a new dataprovider using the excel file as the source to bring in the Country Code and Country name.. MAke sure the data on the file has no leading or trailing spaces in the data columns, match the case of the Country Code data in the excel file and the database.. Once you have the...
  2. Shoot

    i want to use @prompt function in BO Designer

    Hi Eswar, I guess it is something with the syntax that you are using. If you could provide with an example how you are trying to use it, it would be helpful. I have a DB2 environment and the syntax works fine which is something like this.. @Select(Contact\Contact datum) BETWEEN @Prompt('Call...
  3. Shoot

    i want to use @prompt function in BO Designer

    Hi Eswar, Try this it should work for you... Join_Date BETWEEN @Prompt('Call Datum from','D','Contact\Contact datum',mono,) AND @Prompt('Call Datum untill','D','Contact\Contact datum',mono,) Keep Smiling, Shoot
  4. Shoot

    Problems with Prompts AGAIN !!

    You Could Prefix the first parameter in the @prompt with the number. for example for the first prompt "1. Applicant ID" and for the second prompt "2. Location." This way you could manage the order in which the prompts should be displayed. Keep Smiling Shoot
  5. Shoot

    Problems with Prompts

    Try using @prompt function in the place of @variable and also don't convert the date to the left of the operand to "to char" (I mean just do a date comparision rather than string comparision), it might help you. Keep Smiling Shoot
  6. Shoot

    BO Equal Join vs Outer Join

    You can edit the SQL of the report by going to Query panel or say Data Provider. But once you make the modifications to the SQL don't forget to check the "Do not Generate SQL before running." Keep Smiling, Shoot
  7. Shoot

    Filtering a particular entry

    You can also use an Alerter. Keep Smiling Shoot
  8. Shoot

    Deleting Open Mail

    Hi Pascal, I tried using it but it doesn't solve the problem. I still get the same error. Any other suggestions? Keep Smiling, Shoot
  9. Shoot

    Deleting Open Mail

    Hi I am new to Lotus Notes. I am writing code in a button. Once the code is executed or action is performed, I need to close and Delete the Current Mail Document. I am trying to use this code.. Call Workspace.CurrentDocument.Document.Remove(1) It throws an error message saying "Cannot Remove...
  10. Shoot

    Linking Universes

    Hi Steve, We have a DB2 environment and our universes point to the Same Database i.e. DB2 UDB but each using different Connections to the production environment. May be I am confused but wouldn't it be possible to link the two Universes which has the same database environment but different...
  11. Shoot

    Linking Universes

    Hi If we need to link two universes, does it mean that both the universes needed to be created using the same connection or can we use different connections for each and would still able to link the universes. Any suggestions or Comments on Linking Universes? Keep Smiling, Shoot
  12. Shoot

    Security Issues

    Hi Steve, Here is my E-mail address: sskchak@hotmail.com Thanks a lot in Advance. Keep Smiling, Shoot
  13. Shoot

    Security Issues

    Hi Steve, Thanks for the Quick response. But I am unable to find the document, the one I found doesn't open. Could you please provide me with the link where I can find the document or else would it be possible for you to send the document, if you have one? Thanks in Advance. Keep Smiling, Shoot
  14. Shoot

    Security Issues

    Hi, Is there any way of maintaining Column and Row level security at the Universe level but not at the Database level for each user. Using Supervisor is there any way of restricting the end user from the data which he is not allowed to view? We don't want the security to be set up at the...
  15. Shoot

    Avoiding Multiple rows in the section total

    Hi Anu, Try to insert a cell from the menu in the section footer of the department and insert the formula for the calculation into the cell and see whether it works for you. Keep Smiling, Shoot
  16. Shoot

    Avoiding Multiple rows in the section total

    Hi, Try Placing the Department total i.e. "0026 TOTAL 70" in the Department Section footer, rather than in the "Division" Section. Since you have more than one values for Division for a particular department, the value repeats for each division in a department. Shoot
  17. Shoot

    Prompts?

    Hi Sri, It throws an error. As per the requirement, the user should be asked to select a level, ones he selects a level we need to prompt him with the appropriate level of prompt. Is there any way to set the dynamic prompts to the end users. If we can do this, we can cut down the number of...
  18. Shoot

    Prompts?

    Hi, We have two reports, one is prompted by country and the other is prompted by City. But both the reports have the same information. We need to combine the reports to reduce the maintenance time for these reports by making a single report out of them. We are trying to create a new prompt...
  19. Shoot

    Dynamic Dates??

    Hi, I created reports using dynamic date condition objects as per the report requirements. We ar using "Teradata." Everything was working fine but recently the it seems the function is not working fine. When I try to use it, it doesn't retrieve any values for the date. When i hard code the date...
  20. Shoot

    Report template

    Hi Are there any specific requirements that should be taken care for publishing a report template to the corporate documents, So that end users can use it for creating their reports. Thanks in Advance, Shoot

Part and Inventory Search

Back
Top