Solved

Print different sales order format by company

Posted on 2014-10-16
3
119 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
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.
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…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

743 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now