Sage 100

Is there a way to print the report setting, i.e. STANDARD, on a Crystal report?

It's not in the worktable, formulas or special fields in Crystal. Maybe just hard-code it into each Crystal form?

Lee - That's a partial fix. But I would love to know what setting my clients are choosing when I get calls. A lot of times they switched back to STANDARD without knowing, and my policy is not to touch the STANDARD report setting.

I guess do a screen-share with the operator and see what form the system ""defaults"" to, which should be the most recent.

The 'File Path and Name' Special Field contains the Report Setting.

...but I guess that 'File Path and Name' field will only help if you place it on each applicable form.

Maybe you can leverage the sy_reportsetting.m4t file.

In a Crystal Formula field (ReportSetting?), paste this: Mid(Filename,InStrRev(Filename,""\\"",InStrRev (Filename,""\\"", -1)-1)+1,InStrRev (Filename,""\\"", -1)-InStrRev(Filename,""\\"",InStrRev (Filename,""\\"", -1)-1)-1)

Then you can place that at the top/bottom of the form, and maybe Suppress if it's not standard. I'm sure a Split would be more efficient, but I just banged that out.

Yeah, the split's better: Split(Filename,""\\"")[Ubound(Split(Filename,""\\""))-1]

Is there a way to hijack the Print Report Settings setting?

@steve - your method works great IF you have modified the STANDARD report setting. I am hoping to leave the STANDARD unchanged. I tried modifying the default report in the Reports folder, but it returns ""REPORTS"" as the report setting. If there is only one company, it might be OK, otherwise you would have to modify STANDARD in each and every company code for this to work.

My workaround: Local StringVar Setting := Split(Filename,""\"")[Ubound(Split(Filename,""\""))-1]; If Uppercase(Setting) = ""REPORTS"" then Setting := ""STANDARD""; Setting This will work as long as you don't create an actual report setting called ""REPORTS