• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

Print different sales order format by company

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
Shawn Thomas
Asked:
Shawn Thomas
2 Solutions
 
ValentinoVBI ConsultantCommented:
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
 
planoczCommented:
Do this to help with unstandard typing in your database.....
=IIF(Trim(Upper(Fields!Company.Value)) = "THE PARTICULAR COMPANY", false, true)
0
 
Damon ReptonOwner\DirectorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now