on 10-12-2018 1:11 PM
I am creating a custom report based off of a stored procedure from SQL Microsoft Studio. The report is complete but now I want to add parameters and a selection key. Before it prompts me to log into the server when i create a select expert all the values show up. Example below:
But once I log into the server all but three of the values are not available anymore:
I have changed the NTablesMax Registry to 2000000 just incase but that did not fix it. I desperatly need some help this is my first time using crystal reports and I can not figure out what the problem is.
is a dynamic parameter to exhibit??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If the source of the report is a Stored Proc, then the dynamic parameter you've created would need another 'source' to fetch its list of values.
Try this:
1. Go to the Database Expert > Expand the connection > Click Add Command and type in the SQL to get ALL departments:
Select distinct table.Department from table
2. Click OK. Delete any Joins that CR automatically sets up between this command and the stored proc. Ignore the warning CR generates.
3. Go to the Field Explorer > Edit the parameter > Under "Choose a datasource" select "New" and then select the Department field from the Command SQL as the "Value".
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No such thing a CR 2019.
Try editing the parameter and then select all values.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It is a dynamic parameter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is this a Static or Dynamic parameter?
If it's a Static parameter, could you re-load the values in the list from the database field.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Abhilash Kumar yes I have done what but when I do it does not give me the option to select all of the values. It only gives me the option to select the three shown in the second picture. This is after it prompts me to connect to the Server
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am using SAP Crystal Reports 2019
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Which version of Crystal are you using?
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you want the user to be prompted to enter or select a parameter value, you should set the Record Select expert as:
usp_CourseSelection Equal to {?MyParameter}
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.