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
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,
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
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
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...
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.