| Mike Abrahamson |
|
|
Reply with quote | #1 |
I am trying to create a parameter in a report that pulls all the values from the "Agent" field in the database. At first I tried creating a Dynamic Parameter but it wouldn't work so I just changed it to a Static Parameter. I want the list of values to include all Agents from the SQL database but it only lists up to "Pierce, Thurman B" when I select the Agent field and choose "Append all database values" in the Actions menu. Is there a limit ot he number of discrete values you can enter in a parameter in CR XI? This would be bad. I don't believe I have this limitation in CR 10 since I've always been able to add more Agents to the list of discrete values as they've appeared in the database. Let me know if this is indeed a limitation or if I need to try something different. |
| |
| Bill Owens |
|
|
Reply with quote | #2 |
There is a limit on how many values can be returned, 1000. To increase that amount you will have to add a registry key. If you are not familiar with editing register keys I recommend you reference this linkhttp://support.microsoft.com/kb/256986 (Regedit.exe) Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV Then add a string value “MaxRowsetRecords” and set the value to the maximum number of records you would like for your report. |
| |
| venkatesh |
|
|
Reply with quote | #3 |
If Iam using dynamic parameter in the crystal XI
and when i run the report the drop down shows an empty value as default
instead is there any chance of bringing the first value in the list as the default value(using some Registry key modifications)
thanx
VenkateshG
|
| |
| Bill Owens |
|
|
Reply with quote | #4 |
Offhand I don't know of any way to have a Dynamic parameter without that first blank entry. I will have to see if any of my colleagues have any ideas.
Bill
|
| |
| venkatesh |
|
|
Reply with quote | #5 |
Bill,
Thanx
me too is trying various sources for finding the solution.
hope this will be useful to most of the people.
is there any way to change the date time parameter format in crystal - XI
|
| |
| Bill Owens |
|
|
Reply with quote | #6 |
I'm not quite sure what you mean, what do you want the format to be? Can you give me an example?
Bill
|
| |
| venkatesh |
|
|
Reply with quote | #7 |
Bill,
the default format of the Date parameter in Crystal-XI is yyyy-mm-dd
but i need the format to be mm/dd/yyyy which is the one that all my clients are used to. Can something be done on this
regards
venkateshG
|
| |
| Bill Owens |
|
|
Reply with quote | #8 |
Sorry, I don't think there is anything you can do about that. I did some additional research and was unable to find a work-around.
If I do find an answer I will post it.
Bill
|
| |
| Ben |
|
|
Reply with quote | #9 |
The default Date parameter format can be changed via File | Options.
In the resulting dialog select the Fields tab and then the 'Date..' button.
In the Format Editor select the Date tab and select, or create, the format your require.
|
| |
| Venkatesh |
|
|
Reply with quote | #10 |
Ben,
i was not asking about the format in which a date field appears in the report.
im asking about the format in which it requires a Date Parameter field input
thanx
Venkateshg
|
| |
| Peter Storms |
|
|
Reply with quote | #11 |
The only way I've found is to create the date parameter as type STRING. In the parameter definition, make sure you include in the prompt text how you want the dates to be formatted.
Then, you have to dissect the date that gets entered to calculate a date from the entry. So, if the person enters 10/01/2008, you would then take that and generate a date with a formula that dissects the value entered and creates a date from the different parts, like so:
date(tonumber(right({parameter},4)),tonumber(left( {parameter},2)),tonumber(mid({parameter},4,2)))
|
| |
