I have been charged with creating a MSSQL query that will produce the data now produced by a Crystal report. The C/R was created 11 or 12 years ago by a guy that is long gone. I have not worked in crystal for probably 6 or 7 years, so I am finding my skills lacking. Two questions...

1) Seems to me that I remember a way to print out all the variables, their formulas and everything you could dream of knowing about a crystal report but I am having trouble finding it CR 2008. Did I make this up in my silly little brain, or does this function really exist?

2) In one of the variables (say @variableName), the definition contains the following lines....

//Subreport Shared Value
WhilePrintingRecords;
Shared numberVar EquipCost;

(I know of no sub-report)

I have searched through the whole report and can not find any other reference to "EquipCost" excelpt one line that sets it to "0", but yet when the report runs, @variableName returns data that proves to be correct. I am thinking maybe this is something that is updated as part of producing the report lines, but if that is the case, I am not finding anything with that name. Can anyone give me some ideas where to look?

Sorry about the vagueness, but I would need some help as to how to be more specific.

Charlie