Solved

Print different sales order format by company

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
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…
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…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…

717 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