?
Solved

Print different sales order format by company

Posted on 2014-10-16
3
Medium Priority
?
137 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 750 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 750 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

770 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