Date calculation - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Date calculation

Author

Topic

sureshprpt
Starting Member

33 Posts

Posted - 2010-09-17 : 09:20:36

Hi all,

I have data in the table for , Suplier name ,Invoice no , value , invoice date , due date for the payment. I want to download the data with the ageing format. And format also eclosed

Supplier name , Invoice no, Invoice date, Due date , Value.

Output format is

Supplier name
Invoice no , Invoice values , Ageing days < 30Days, >30 Days to 60 days, more than 60 days.

Kindly help me the query to download the data in my requried format.

Thanks
BY
Suresh

Thanks & Regards
Suresh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-09-17 : 12:09:59

you mean you need supplier name on top and everything else coming below it in next level?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sureshprpt
Starting Member

33 Posts

Posted - 2010-09-18 : 00:24:47

Yes , and also i want the summary for the supplier in below of all invoices.

quote:
Originally posted by visakh16

you mean you need supplier name on top and everything else coming below it in next level?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Thanks & Regards
Suresh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-09-18 : 09:05:51

then you need to apply group on supplier and in detail portion add a nested table to add the other details. then in group footer add the summary

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sureshprpt
Starting Member

33 Posts

Posted - 2010-09-19 : 23:52:15

Hi,
KIndly send some examples with Query

Thanks

quote:
Originally posted by visakh16

then you need to apply group on supplier and in detail portion add a nested table to add the other details. then in group footer add the summary

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Thanks & Regards
Suresh

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources