I have a parameter in my CR but I don't know where it's come from 1

[RSX02]

I have a parameter in my crystal report that gives me the caption of a field. This parameter is call @PackDate. I can see that this parameter is treat in my stored procedure. But I can't understand where it is assign. Here is each line where the field @PackDate appear.

...
DECLARE
@PackDate DateType
...
BEGIN
FETCH PackingSlip1Crs INTO
@PackDate
...
INSERT INTO @ReportSet (...pack_date...) VALUES (...@PackDate...)
...
INSERT INTO @ReportSet (...pack_date...) VALUES (...@PackDate...)
...
INSERT INTO @ReportSet (...pack_date...) VALUES (...@PackDate...)
...


I would also like to know if it's possible to tell in the stored procedure that "if the country is "Canada" take the data from the Tbl1 and if the country is "USA" take the data from the Tbl2"?

Thank you in advance

 

[RSX02]

Okay i'm sorry I found that it was not a parameter but a "formulas field". and in the formulas editor I have only ("sPackDate&quot. So do you have an idea where it could come from? It supposed to come from a TblString in my database but I just can't find where it tells to my Report that it have to take the caption of my fields from this table. If you could help me to find it out I would really appreciate.
Thank you.

 

[Naith]

RSX,

I'm not 100% certain what you're getting at here. @PackDate in your procedure is a variable, which is used to hold the value of PackingSlip1Crs, which is eventually passed into your result set, which I imagine Crystal reports on.

Yes, it's possible to tell a stored procedure how to source data based on data value, like your USA and Canada example - but as for telling you where your report objects come from - we can't exactly do that. Crystal formulas are not derived in any circumstances. They have to be created by a developer - which is what must have happened in your case too. You have not provided any information about what sPackDate does, or what you think it's doing.

If your report is not working, post what you expect it to do compared with what it is currently doing. Post the content of the formula you don't understand, with some sample output if you think it would be helpful. If it's just that you can't read the stored procedure, you might find it'd help to speak to one of your development resources.

Naith