December2000
asked on
Crystal to SSRS Expressions
Hi Experts,
What would this expression be translated to in SSRS
{@LineSelection} and
{Order.OrderId} = {?OrderId}
What would this expression be translated to in SSRS
{@LineSelection} and
{Order.OrderId} = {?OrderId}
ASKER
OrderID parameter and lineSelection is
{OrderLine.LineNumber} <> 100008
AND
(
{OrderLine.LineType} = "TRACER" OR
{OrderLine.LineType} = "TECH" OR
{OrderLine.LineType} = "FREIGHT" OR
{OrderLine.LineType} = "EQUIP" OR
{OrderLine.Quantity} <> 0 OR
{OrderLine.UnitPrice} <> 0 OR
{OrderLine.ExtPrice} <> 0 OR
{OrderLineExt.ShowOnReport } = true
)
AND
(
// Rehab Only Items
{Order.ApplicationType} = "R"
OR
(
{OrderLine.LineNumber} <> 10070 AND
{OrderLine.LineNumber} <> 10071 AND
{OrderLine.LineNumber} <> 10072 AND
{OrderLine.LineNumber} <> 100006 AND
{OrderLine.LineNumber} <> 100007 AND
{OrderLine.LineNumber} <> 100103
)
)
AND
(
(
// US Forms
({Order.FormType} = "fsa" OR {Order.FormType} = "fsd" OR {Order.FormType} = "int") AND
(
// Exclude Canada Only Items
{OrderLine.LineNumber} <> 100004 AND
{OrderLine.LineNumber} <> 100005 AND
{OrderLine.LineNumber} <> 100006 AND
{OrderLine.LineNumber} <> 100007 AND
{OrderLine.LineNumber} <> 100008 AND
{OrderLine.LineNumber} <> 10055 AND
{OrderLine.LineNumber} <> 10056 AND
{OrderLine.LineNumber} <> 10017 AND
{OrderLine.LineNumber} <> 10015 AND
// 2008.07.01.00 Legacy
(
(
{OrderLine.LineNumber} <> 10040 AND
{OrderLine.LineNumber} <> 10060 AND
{OrderLine.LineNumber} <> 10080 AND
{OrderLine.LineNumber} <> 10090 AND
{OrderLine.LineNumber} <> 9010 AND
{OrderLine.LineNumber} <> 9020 AND
{OrderLine.LineNumber} <> 9030
) OR
{Order.FormVersion} = "2008.07.01.00"
)
)
)
OR
(
// Canada Forms
{Order.FormType} = "fsc" AND
(
// Exclude US Only Items
{OrderLine.LineNumber} <> 100003 AND
{OrderLine.LineNumber} <> 100009 AND
{OrderLine.LineNumber} <> 10072 AND
{OrderLine.LineNumber} <> 9040 AND
{OrderLine.LineNumber} <> 9041 AND
// 2008.07.01.00 Legacy
(
(
{OrderLine.LineNumber} <> 10040 AND
{OrderLine.LineNumber} <> 10060 AND
{OrderLine.LineNumber} <> 10080 AND
{OrderLine.LineNumber} <> 10090 AND
{OrderLine.LineNumber} <> 9010 AND
{OrderLine.LineNumber} <> 9020 AND
{OrderLine.LineNumber} <> 9030 AND
{OrderLine.LineNumber} <> 10055 AND
{OrderLine.LineNumber} <> 10056 AND
{OrderLine.LineNumber} <> 10017 AND
{OrderLine.LineNumber} <> 10015
) OR
{Order.FormVersion} = "2008.07.01.00"
) AND
// 2008.12.05.000 Legacy
(
(
{OrderLine.LineNumber} <> 100004 AND
{OrderLine.LineNumber} <> 100005
) OR
{Order.FormVersion} = "2008.12.05.000"
)
)
)
)
{OrderLine.LineNumber} <> 100008
AND
(
{OrderLine.LineType} = "TRACER" OR
{OrderLine.LineType} = "TECH" OR
{OrderLine.LineType} = "FREIGHT" OR
{OrderLine.LineType} = "EQUIP" OR
{OrderLine.Quantity} <> 0 OR
{OrderLine.UnitPrice} <> 0 OR
{OrderLine.ExtPrice} <> 0 OR
{OrderLineExt.ShowOnReport
)
AND
(
// Rehab Only Items
{Order.ApplicationType} = "R"
OR
(
{OrderLine.LineNumber} <> 10070 AND
{OrderLine.LineNumber} <> 10071 AND
{OrderLine.LineNumber} <> 10072 AND
{OrderLine.LineNumber} <> 100006 AND
{OrderLine.LineNumber} <> 100007 AND
{OrderLine.LineNumber} <> 100103
)
)
AND
(
(
// US Forms
({Order.FormType} = "fsa" OR {Order.FormType} = "fsd" OR {Order.FormType} = "int") AND
(
// Exclude Canada Only Items
{OrderLine.LineNumber} <> 100004 AND
{OrderLine.LineNumber} <> 100005 AND
{OrderLine.LineNumber} <> 100006 AND
{OrderLine.LineNumber} <> 100007 AND
{OrderLine.LineNumber} <> 100008 AND
{OrderLine.LineNumber} <> 10055 AND
{OrderLine.LineNumber} <> 10056 AND
{OrderLine.LineNumber} <> 10017 AND
{OrderLine.LineNumber} <> 10015 AND
// 2008.07.01.00 Legacy
(
(
{OrderLine.LineNumber} <> 10040 AND
{OrderLine.LineNumber} <> 10060 AND
{OrderLine.LineNumber} <> 10080 AND
{OrderLine.LineNumber} <> 10090 AND
{OrderLine.LineNumber} <> 9010 AND
{OrderLine.LineNumber} <> 9020 AND
{OrderLine.LineNumber} <> 9030
) OR
{Order.FormVersion} = "2008.07.01.00"
)
)
)
OR
(
// Canada Forms
{Order.FormType} = "fsc" AND
(
// Exclude US Only Items
{OrderLine.LineNumber} <> 100003 AND
{OrderLine.LineNumber} <> 100009 AND
{OrderLine.LineNumber} <> 10072 AND
{OrderLine.LineNumber} <> 9040 AND
{OrderLine.LineNumber} <> 9041 AND
// 2008.07.01.00 Legacy
(
(
{OrderLine.LineNumber} <> 10040 AND
{OrderLine.LineNumber} <> 10060 AND
{OrderLine.LineNumber} <> 10080 AND
{OrderLine.LineNumber} <> 10090 AND
{OrderLine.LineNumber} <> 9010 AND
{OrderLine.LineNumber} <> 9020 AND
{OrderLine.LineNumber} <> 9030 AND
{OrderLine.LineNumber} <> 10055 AND
{OrderLine.LineNumber} <> 10056 AND
{OrderLine.LineNumber} <> 10017 AND
{OrderLine.LineNumber} <> 10015
) OR
{Order.FormVersion} = "2008.07.01.00"
) AND
// 2008.12.05.000 Legacy
(
(
{OrderLine.LineNumber} <> 100004 AND
{OrderLine.LineNumber} <> 100005
) OR
{Order.FormVersion} = "2008.12.05.000"
)
)
)
)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the delayed response! Is there a easy way to translate crystal VB to SSRS Microsoft Expressions?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What is the formula for LineSelection?
mlmcc