Skip to Content
0

Crystal reports Problem

Nov 21, 2016 at 11:55 AM

51

avatar image

Hello,

While adding oracle procedure in oracle server then after we are giving parameters Report Date parameter then down it is showing null value in check box("set to nul") in down. But we don't want to show the check box with Null value. Kindly may I know the solution for this.

Thanks Regards,

Ramesh.P

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Abhilash Kumar
Nov 21, 2016 at 02:12 PM
0

Hi Ramesh,

Please use one of the two workarounds listed below:

Workaround 1:

1) Create a report with any datasource (you do not need to use the fields in this source)

2) Create a parameter in this report with the same datatype as the sub-report's parameter.

3) Insert a sub-report (Insert > Subreport) and select the stored procedure as the datasource. It will prompt you for a value once. Place the subreport on the Report Header.

4) Suppress all other sections of the Main-report

5) Right-click the Sub-report and select 'Change sub-report links' > Move the Main report parameter to the 'Fields to Link to' area and from the drop-down that says 'Subreport parameter field to use' choose the sub-reports parameter.

Workaround 2:

Another way to do this is to call the stored procedure via a command object. So, once the connection to the database has been established from the Database Expert, you should see an option called 'Add Command'.

Write this command:

Exec Procedure_Name {?Parameter_name}

Here, {?Parameter_name} is created at the command level and you can create it like this:

On the right-hand side where it says Parameter List, click on the 'Create' button and create the parameter with the same datatype as the stored procedure's. Give it a name and use the same name in the Command Object.

Hope this helps!

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
ram esh Nov 22, 2016 at 11:04 AM
0

Hello Abhilash,

Thanks you very much for reply. I will prefer the workaround 2 as this won't impact my excel export. But when I tried "Exec Procedure_Name {Parameter_name}" in Oracle 11g SP and it is showing erro as ORA-00900: invalid statement. Can you please help me with the currect syntax for oracle in stored procedure.

Thanks Regards,

Ramesh.P

Share
10 |10000 characters needed characters left characters exceeded