CR 2016 Parameter not showing all options

[former_member1356320]

I have a query that pulls a field called "Program_Type". This field has 3 options: [value not entered], Industrial, and Municipal. I set up the parameter to be dynamic and be a drop down that lets the user choose between the 3 options. I sorted the data, in the SQL query, by Program_Type. There are way more that 1000 rows in this query, if this is an issue. The Municipal option is the one not showing up. Again, if this is due to the 1000 row limitation, the Municipal program type in the results starts after row 1200. What do i need to do to make the municipal type appear? BTW i am very new to CR, and the report is being pulled using a SQL query i made in MS SQL Server. Also, the fixes i found on the forum only address CR 2008, or CR 2011, not CR 2016.

[DellSC]

How are you running the report?

By default, Crystal will only show 1000 rows in a dynamic prompt. However, you can use a registry setting you found for Crystal 2011 to adjust this.

If you're just running the report from Crystal itself, in 64-bit Windows, go to HKEY_LOCAL_MACHINE\Software\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV and create the key "MaxRowsetRecords" if it's not already there. Set this to the maximum number of rows you think you'll ever had.

In 32-bit Windows, the path is HKEY_LOCAL_MACHINE\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV

If you're running your report through another means, let me know and I'll point you to the right spot for the key.

-Dell

[venkateswaran_k]

Dear Paul,

If your dropdown field is filled in based on your query data selected, then it is impact of your 1000 rows limitation.

Better you do a separate query - select distinct program_type from your table and link this dataset to your parameter dropdown.

Regards,

Venkat