Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to find the source of Shared variable 2

Status
Not open for further replies.

maulae

IS-IT--Management
Feb 7, 2006
34
US
I am working on crystal 11 with SQL server,
I need to modify a report that was created by an other developer who has left the company, now I have problem to find the source of a shared variable abc which is used in main reports's formula @xyz as
WhilePrintingRecords;
shared stringVar abc ;
.
One of the field in the report contains that shared variable, I tried to find in all active shubreports but could not find that, I will appreciate if somebody tell me how to find the source of this shared variable?
 
Export the report to Export Definition format, it's searchable as it's a text file.

It'll show what section and formula they're in.

-k
 
Thanks for your help.
But I am sorry to say it did not work as I needed actually it shows me only details of main report, but I could not figured out my shared variable where is coming from, I mean which subreport contains that varable abc? there are many subreports and some of them are suppressed and overlapped, so difficult to check all subreports, if I figure out the name of related subreport then I can check what calculations are done in that shared variable which are passing in main report.
 
It does work.

Saying your sorry to say it doesn't work needs to be clarified, could you not export it, you searchedfor the text afterwards and you couldn't find it, or?

Please describe your issue.

-k

 
You might be able to narrow down the source of the formula by suppressing one by one the various sections containing the subreports, since the suppression will cause the shared variable in the main report to return a 0. Or if subreports share the same section, try suppressing the subreport objects one by one and then checking to see if the shared variable is 0 in the main report.

-LB
 
I really liked your explanation and definitely it will help me later sometimes but currently my shared variable is already showing 0 and I need to know what field or formula has been used in that shared variable, I exported my report in text format (as per synapsevampire advice) and tried to find the occurrence of that variable there but it did not show any source,

Any other suggestion will be highly appreciated.
 
Sorry, I see I posted export definition, it should be report definition format.

-k
 
If it is already showing zero, then it is possible that it will be found in a subreport/section that is already suppressed or that the subreport has been removed, but there is a reset formula somewhere in the main report that is setting the shared variable to 0.

-LB
 
Big Thanks for you and synapsevampire for great help, so what I concluded if related subreport has been suppressed/removed we can not figured out what was the name of that subreport and what is the source that shared variable which has been used in the main report?
 
No, if a subreport is suppressed, report definition will still show it.

But yes, if you delete things Crystal won't list them as still being there, or having once been there.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top