Sage 100

@DawnAnastasi @AlnoorCassim Have you tried adding custom Crystal report to the Custom Reports menu in 4.45? It prompts for an ODBC login and of course since 4.45 uses OLE DB, there isn't one. The report conversion process fails at that point.

I have not done this. I have added ""Converted to version 4.45"" in the report file info and it never prompted for conversion.

I tried manually adding that text as well but it still prompts for a conversion. Weird!

Another interesting ""feature"" in 4.45 (and I would assume it's the same in 4.5) is that there is no longer a SY0_CompanayParameters table. It's been replaced by a SY_Company table in the MAS_SYSTEM database.

Interesting comment on the ""feature"" I'll check it out in v4.5. Not sure if it would be eliminated because of the legacy modules. In the SQL version, there are no legacy modules so there would be no need for this legacy table.

That makes sense Jeff. The same info is available in SY_Company. So, if we ran a Crystal report outside of MAS that uses the Company Name, I'm not sure how Crystal would know which company to use in SY_Company (assuming you have multiple companies).

Don't you when running Crystal outside of MAS have to login into MAS security for the OLE DB?

Yes, that's correct.

Then is what sets the company code for the report then.

Doesn't seem to be working even though we are logging in to OLE DB using the correct company code.

That's odd. I just looked at my notes and adding ""Converted to version 4.45"" is all I needed to do.

Dawn, I just tried it on another report and it worked. Why it works on one report and not another is a mystery!

I'll chalk that one up to an odd report. Jeff, I'm still working on the printing the Company Name on a report. Even after I added the report to the Custom Reports menu, it still doesn't pull the correct Company Name. It pulls the company that just happens to be the first one in the SY_Company table.

@JohnShaver I would assume you could grab the company name formula from one of the Sage Crystal Reports and paste it in.

They're cheating and using WRK files.

The company name is passed programmatically in providex.

Does that mean I can access it?

You would have to have both reports open in Crystal.

You should be able to copy and paste them from another report.

If you want to freehand them I put a list of the different variables up on 90minds a while back: http://community.90minds.com/2011/05/27/add-user-name-to-mas90-custom-report/

Allright, I give up. Here's a copy of the report. I added the formula and subreport per your article and it's still not working. Probably my stupidity but could be a 4.45 thing.

I don't think I had any reports with subreports, could that be it?

@JohnShaver You don't need the subreport. The only reason for the subreport is to add the user name which you're not trying to do. The field name should be ""CompanyName"" not ""Company Name"". I just sent you back an example via email.

Fascinating. That did the trick. Thanks! I owe you a plate of 'cue!

Glad it worked!