79202324

Date: 2024-11-19 06:47:54
Score: 1.5
Natty:
Report link

To see the stored procedure fields in the crystal report, follow the below steps:

  1. Right click in the report, and from the vertical tab select (Field Explorer) enter image description here

  2. Right click in the stored procedure that you selected before, and from the vertical tab select (Verify Database)

enter image description here

  1. You will see page that show the default value as null as showing in the below image enter image description here
  2. Uncheck the (Set to Null) checkbox and enter the correct values that once you enter it; It will retrieve data using your stored procedure.
  3. In my case, I should put the data for both parameters as shown in the below image: enter image description here
  4. Then click ok button, you will see dialog message as shown in the below image: enter image description here
  5. Click (Ok) button and another dialog message will be shown to you (The database is now up to date.); Click (Ok) button for this dialog also. enter image description here
  6. Now, you should see the full selected columns as shown in the below image: enter image description here
Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: ali