Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

find delay date if I have only 1 date column in query based report(ssrs)

Posted on by 40

find delay date if I have only 1 date column in query based report(ssrs) and i column of issue date 

if product is ship so the "column of issue date =0" and when procut is received so the "column of issue date =1"

how to differ date(of delay time)

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 225,783 Super User on at
    RE: find delay date if I have only 1 date column in query based report(ssrs)

    Okay, it seems that you want to want two related rows. But I know nothing about your table and the business process, therefore I can't tell you how the rows are related. It's something you should tell us.

  • asadfaiq Profile Picture
    asadfaiq 40 on at
    RE: find delay date if I have only 1 date column in query based report(ssrs)

    I have 2 columns

    1 is product issue and

    2 is transdate

    if product is "ship" to so  product issue is "0"

    and

    if product is "received" to so  product issue is "1"

    and I have 1 column of transdate when product is ship transdate create and when product is received transdate is created find out duration of ship to received product

    but the problem is that ship is  row

    and received is another two different rows how to find out difference?

  • Martin Dráb Profile Picture
    Martin Dráb 225,783 Super User on at
    RE: find delay date if I have only 1 date column in query based report(ssrs)

    Unfortunately it's still not clear what you need from us.

    Are you asking how to subtract two dates? If so, simply use the minus (-) operator in X++ or DateDiff() function in SSRS.

    Or are you asking how to get the dates? Unfortunately we can't answer that, because we don't know which tables you're using and how.

  • asadfaiq Profile Picture
    asadfaiq 40 on at
    RE: find delay date if I have only 1 date column in query based report(ssrs)

    can someone help me

  • asadfaiq Profile Picture
    asadfaiq 40 on at
    RE: find delay date if I have only 1 date column in query based report(ssrs)

    status =>0 (product shiped) and date 14-01-2021

    status =>1(product received) and date 19-01-2021

    how to find? in above eg delay time is 5 days but how to calculate difference

  • Martin Dráb Profile Picture
    Martin Dráb 225,783 Super User on at
    RE: find delay date if I have only 1 date column in query based report(ssrs)

    What is the delay time and what do you mean by finding it in a report?

  • asadfaiq Profile Picture
    asadfaiq 40 on at
    RE: find delay date if I have only 1 date column in query based report(ssrs)

    I have 1 column status when status 0 so its means product is ship

    and when status 1 so its means product is received

    and I have one column of date

    for eg:

    status =>0 (product shiped) and date 14-01-2021

    status =>1(product received) and date 19-01-2021

    I want to find out delay time(date) in ssrs query based report (visual studio)

  • Martin Dráb Profile Picture
    Martin Dráb 225,783 Super User on at
    RE: find delay date if I have only 1 date column in query based report(ssrs)

    I'm sorry, but I don't understand what you're saying. Can you give us a concrete example, please?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans