Crystal to SSRS Expressions

Hi Experts,

What would this expression be translated to in SSRS

{@LineSelection} and
{Order.OrderId} = {?OrderId}
December2000Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Where is the expression used?

What is the formula for LineSelection?

mlmcc
0
December2000Author Commented:
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"                
            )
        )
    )
)
0
mlmccCommented:
This will become part of the SQL for the report.

{Order.OrderId} = {?OrderId}

    {?OrderID} is a parameter.  You need to add a parameter to the query then in the WHERE clause of the query

    Order.OrderId = @OrderId


The other part is a formula which will also have to added to the SQL.  It should work if you just remove the { } around each field name.

Have you looked at the SQL the Crystal Report uses?
It should show the SQL for the where clause

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
December2000Author Commented:
Sorry for the delayed response! Is there a easy way to translate crystal VB to SSRS Microsoft Expressions?
0
mlmccCommented:
What do you mean an easy method?

There is this tool that claims to convert from Crystal to SSRS.  I haven't used it so I don't know if it useful
http://www.ktlsolutions.com/Products/CrystalConverter.aspx

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.