I am newbie to configuring tns names file. For example, what entry line would indicate the ORACLE instance for the dynamic cascade prompt datasource? Please excuse my ignorance. I looked for the Server menu item under Database in Crystal but it was not an option.
When I try running the report with a dynamic parameter prompt, I encounter an error 'UNKNOWN DATABASE CONNECTOR - Prompting Failed with the following error message Error Code: 0x80004005. When I run the report without the dynamic parameter prompt, the report runs fine. I am using Crystal Xl...
I have created a dynamic prompt list of values. My value field is the key field and my description field is the title field. For example, the value field is 1001 and Title Field is 'Maintenance'. I would like to display the description field 'Maintenance' on the report versus 1001, the value...
CR XI / Oracle
What I want to do is that when the report runs, the dynamic cascading prompt would only show the list of organizations or personnel that the user has access to. For example if User "A" logs on, he will be able to see only the organizations or personnel that’s link to his...
If you solution fits our need, I would love to give up on the cascading prompt. Because we have been pulling our hair out by trying to figure out a way to dynamically sort a pick list.
Could you give me the method of using the static prompt for sort order and then dynamic pick lists? I'll see...
I guess my question is if I can dynamically sort the List of Values (LOV) based on the user imput?
For example: a list of values (LOV) with two options 'Sort By UIC' - 'Sort by Organization' If the User selects 'Sort By UIC' The pick list below it will be sorted in UIC order or if he selects...
I am familiar with using the sort option parameter within the report formula but is there a way to get the user entry and sort the pick list in response to their sort option selection? How do you pass that parameter to a dynamic cascading prompt because I want to change the way the pick list is...
What I would like to do is to have a static parameter giving the user the option to determine how to sort the pick list.
For example in the static prompt, I would have'NAME' or 'UNIT CODE'.
If Name is selected, the List of Values would be sorted by NAME. Vice versa, if the Unit Code was...
I would like to know if I can do the following:
I use Crystal XI / ORACLE
I would like to use a three level dynamic cascading prompt. When the user selects the top level organization (level 1), I would like the lower level (2 and 3) pick lists to populate with the divisions and the unit codes...
Crystal Xl/Oracle
Is there a way to conditonally sort a dynamic cascading prompt group. For example, we would like to give the user the option to sort a pick list by a person name or the employee id. If they select person name, they will see the list in name order or if they select employee...
Is there a way to conditonally sort a dynamic cascading prompt group. For example, we would like to give the user the option to sort a pick list by a person name or the employee id. If they select person name, they will see the list in name order or if they select employee id, they will see...
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.