Report writer 1

[swabunn]

Great plains 7.5
SQL server 2005

Is there any way to place conditional logo in customer statement being modified in report writer. for example if user put condition then it would print one else other one

Thanks

Swabunn

 

[winthropdc]

Yes and No

You can overlay a logo with a conditional field which either has a space or nothing entered into it. Then set the background colour to white and set the field to hide when empty.

Then the conditional field can be turned on and off to expose the logo based on some condition.

The downside is that this method will only work if the 2 or more logos used are not in the same positions on the layout.

Another idea is to use a tool link

http://www.fineprint.com

which can add logos based on the printer driver used. You can then use Named Printers to automatically select the printer driver based on company.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

http://blogs.msdn.com/DavidMusgrave

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[swabunn]

I can't see logo as field to put the condition. I set up calculated conditonal field called 'logo' and overlaid logo on the field and want to palce condition if address id = 'RG1' Then '1st Logo' else 'empty'
and then second calculated conditional field '2ND LOGO' if address id <> 'RG1' Then '2nd Logo' else 'empty'

Please help?

 

[winthropdc]

The actual logo must be sent to back, so that the conditional field is above it.

Make sure the field's background is set to white.

It should cover the actual logo so that it will either show white or disappear (due to the hide when empty).

The calculated field should be something like

if AddressID = "RG1"

Then " " (note space inside quotes)

Else "" (note empty quotes)

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[swabunn]

I have done all three steps on conditional calculated field and placed these field covering logos at diffrent locations, set background to white and hide when empty on both conditional calculated field. Still when I am running the statement it is displaying both logo(s).

I don't know what I am missing.Please advice.

Thanks in advance

Swabunn

 

[winthropdc]

Please email me at david dot musgrave at microsoft dot com and I will send you an example.

This example will be soon available from my blog

http://blogs.msdn.com/DevelopingForDynamicsGP

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[winthropdc]

I think I found the issue.

Change your fields to make the foreground color white as well.

Then make the conditional formula show "" or ".". You must use a character as a space is still classified as empty.

The example code is now posted on my blog.

http://blogs.msdn.com/DevelopingForDynamicsGP

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.