Solved

Print different sales order format by company

Posted on 2014-10-16
3
127 Views
Last Modified: 2014-12-24
We have a custom sales confirmation report design we want to print for a particular company.  The design was added to the same SSRS report as the original sales confirmation.  How can I have this activated by default when someone is printing a confirmation in that company?
0
Comment
Question by:Shawn Thomas
3 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 250 total points
ID: 40386296
I'm not familiar with Dynamics reports but in SSRS (which I believe Dynamics is using) you would specify an expression in the Hidden property of a table to show/hide it based on a certain condition.  In your case that could be something like:

=IIF(Fields!Company.Value = "the particular company", false, true)

This of course assumes that you've got some indication of the company in your dataset.
0
 
LVL 27

Assisted Solution

by:planocz
planocz earned 250 total points
ID: 40389519
Do this to help with unstandard typing in your database.....
=IIF(Trim(Upper(Fields!Company.Value)) = "THE PARTICULAR COMPANY", false, true)
0
 
LVL 5

Expert Comment

by:Damon Repton
ID: 40516415
you can also do this from within AX, using print management, or in the controller class have a simple case statement on this dataareaid, and output which design you want to use.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question