I been in a situation where the client wanted to get his company logo loaded in his reports whenever he adds new companies and without calling the IT guys to modify the reports.
Due to Dexterity limitations, logo cannot be loaded from the database into the report writer, instead we were getting around multi-companies reports by adding a section in report writer for each logo and managing the appearance of each section using VBA.
My client has allot of companies and those companies are increased day after day! Where he asked to have the company logo as a setup and loaded to his reports dynamically, I had to customize this through the VS Toolkit, I added a new form linked to the company setup form:
Where you can setup the logo for each company, the logo will be saved directly to the database, and then I developed 15 Crystal Reports linked to the forms to display the data along with predefined logo’s instead of the original GP reports:
Each report of our reports will have two main commands, first one will hold the SQL Statement and the other one will hold the company related information, we’ll be discussing each command in its related report, but the company command will be one for all reports, to avoid any issues when creating our crystal report, we’ll need to add the statement as a “Command” instead of direct tables as the command does not store the database name along with the statement, the report will need to be designed to look like the original GL edit list:
SELECT * FROM Dynamics.dbo.SY01500
INNER JOIN Dynamics.dbo.CompanySetup ON Dynamics.dbo.SY01500.InterID = Dynamics.dbo.CompanySetup.IntercompanyID
I am willing to share the complete steps as a series of posts based on the below schedule (Links will be active on the specified dates):