How to remove all references for a field from the report? 2

[ndp]

Hi,
I have a parameter field called Param1 in my report. Later on I changed the stored procedure to add that same parameter in the stored procedure. Now in report I have same parameter with @Param name. I don't need the Param1 parameter. I removed all the references of Param1. But, when I tried to delete the Param1, it gave me message that it could not be deleted since it still has reference somewhere. I checked all formulas and everything in the report. I couldn't find it anywhere.

My question is...
Is there any way to find out where that param1 is used without checking each fields manually? or how can I get rid of Param1?

Any suggestion would be appreciated!

Thanks,
ndp

 

[kchaudhry]

You can try this:

File > Print > Export > Select "Report Definition" from the format drop down list.

This should show you all the details of your report.

Hope it helps!

Kchaudhry

 

[ndp]

Wow!
That was an excellent suggestion! That really helped me.
I am going to give you star.

Thank you so much.
ndp

 

[kchaudhry]

Glad to help.

Kchaudhry

 

[Nuffsaid]

Hi,

You could just change the data type of the parameter.
This will cause formulas that reference them to error out.

Nuffsaid.
"We will...
either find a way,
or make one.

 

[ndp]

That is also a good idea.

Thanks Nuffsaid.
ndp