Recent content by Shoot

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

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

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

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

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

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

You can also use an Alerter. Keep Smiling Shoot

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

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

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

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

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

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

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

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