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.
| Author |
Topic |
|
josephine0629
Starting Member
2 Posts |
 Posted - 2011-10-11 : 16:55:31
|
| I would like to show the headers in my report as follows:Customer 2011-Q3 2011-Q4 Total AmountIn order to come up the Q3 period, I have a field called requested_Ship_date . For example Transaction date between Jan 01, 2011 to March 31, 2011 is in 2011-Q1 bucket. Could you show me how I can do this in SSRS in order to show the Quarterly header by requested_Ship_date field? Thanks,Josephine |
|
|
josephine0629
Starting Member
2 Posts |
Posted - 2011-10-11 : 18:08:51
|
| Below is my SQL query: I would like to get the OrderMonth field (values are 2011-Q3, 2011-Q4) in the header on the reportCustomer: 2011-Q3 2011-Q4 Total:ABC $100,000 105,000 205,000Thanks,Josephine-------------------------------------------------------------------------------------------Select SOP10100.CUSTNAME, CAST(DATEPART(yy, SOP10200.ReqShipDate) AS varchar) + '-Q' + CAST(DATEPART(qq,SOP10200.ReqShipDate) AS varchar) AS OrderMonth,SOP10200.ReqShipDate as Requested_Ship_date,SOP10200.QTYREMAI as QTY_Remaining,SOP10200.UNITPRCE AS Unit_Price,(SOP10200.QTYREMAI * SOP10200.UNITPRCE) as Extended_Pricefrom SOP10100 inner join SOP10200 ONSOP10100.SOPNUMBE = SOP10200.SOPNUMBE where SOP10200.QTYREMAI> '0' andSOP10200.QTYCANCE = '0'andSOP10200.SOPTYPE = '2' andSOP10100.VOIDSTTS = '0' GROUP BY SOP10100.CUSTNAME, SOP10200.ReqShipDate, SOP10100.DOCDATE, SOP10200.QTYREMAI, SOP10200.UNITPRCE, SOP10200.XTNDPRCE |
 |
|
|
rajarajan
Starting Member
48 Posts |
Posted - 2011-10-12 : 12:56:46
|
| u can try like this : place a text box .in that assign the datasource resulted coloumn to the textbox=" Shiping Date " & Parameter.value by doing this when u selected the value in the drop down this value reflect in the text box hope this solve ur issue or let me know |
|
|
|
|
|
|
|
|
Grouping