handling the parameters from procedures.!!

[rajrev]

HI,
I'm using CR 8.5, Sql server.

We are using a procedure called Pro1, which is talking care of the parameter, formula codition, etc.
ie once we include the procedure it automatically list out the parameter list.
(without modifing the procedure)
Issue 1:
In the parameter list some of them are not used by the end user (ie) default NULL value. If there's any way to hide that kind of parameters.

Issue 2:
If there's any way to re-order the parameter list in Crystal Enterprise.

Thanks
MK

 

[synapsevampire]

I'm afraid you've very little control over SP params.

I would disable unused parms and change the order within the SP, or create another SP.

-k

 

[rajrev]

You are right! at present i don't have rights to edit the sp. by the way thanks for your response.
If they allow me to edit the sp then its easy to do the needs.
Thanks
MK