You’re offline. This is a read only version of the page.
Announcements
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)
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.
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?
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.
What is the delay time and what do you mean by finding it in a report?
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)
I'm sorry, but I don't understand what you're saying. Can you give us a concrete example, please?
#1
André Arnaud de Cal...
294,233
Super User 2025 Season 1
#2
Martin Dráb
232,982
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
