代碼
一、?報表參數(shù)

????????1.nHotelID???名稱：nHoteId??數(shù)據(jù)類型：Integer??隱藏?????可用值：無查詢???默認值：?無查詢?=2?

?????
????????
????2.Team??名稱：?Team??數(shù)據(jù)類型：Integer??提示：團散??多值????
???????????????可用值：無查詢??標簽：?住客＝2??團客＝1?散客＝0
???????????????????默認值：無查詢??=2

??????????

???????3.VIP??名稱：VIP??數(shù)據(jù)類型：Integer??提示：房型?????多值?
?????????????????????可用值：來自查詢??數(shù)據(jù)集：?GuestKind???值字段：?nId????標簽字段：cName?
?????????????????默認值：來自查詢??數(shù)據(jù)集：?GuestKind???值字段：?nId????

?????????????數(shù)據(jù)集?GuestKind?定義
?????????
??????????SQL語句：?Select?nId,cName?From?B_GuestKind?Where?bIsUse?=?1??And?nHotelId?=?@nHotelId?order?by?nId

????
???????????
??????4.Area??名稱：Area??數(shù)據(jù)類型：Integer??提示：區(qū)域?????多值?
?????????????????????可用值：來自查詢??數(shù)據(jù)集：?Area???值字段：?nId????標簽字段：cName?
?????????????????默認值：來自查詢??數(shù)據(jù)集：?Area???值字段：?nId????

?????????????數(shù)據(jù)集?Area?定義
?????????
??????????SQL語句：?select?nId,cName?from?B_Area?where?bIsUse=1?and?nHotelId=@nHotelId


???????5.RoomKind??名稱：RoomKind??數(shù)據(jù)類型：Integer??提示：房型?????多值?
?????????????????????可用值：來自查詢??數(shù)據(jù)集：?RoomKind???值字段：?nId????標簽字段：cCode
?????????????????默認值：來自查詢??數(shù)據(jù)集：?RoomKind???值字段：?nId????

?????????????數(shù)據(jù)集?RoomKind?定義
?????????
??????????SQL語句：?select?nId,cCode?from?B_RoomKind?where?bIsUse=1?and?nHotelId=@nHotelId

????????5.NightCheckListId?名稱：?NightCheckListId??數(shù)據(jù)類型：Integer??提示：夜核批次?????多值?
?????????????????????可用值：來自查詢??數(shù)據(jù)集：?NightCheckList???值字段：?nId????標簽字段：cName?
?????????????????默認值：空值???

?????????????數(shù)據(jù)集?NightCheckList?定義
?????????
??????????SQL語句：?
??????????select?nId,cName=convert(nvarchar(12),DateAdd(dd,-1,dEndTime),112)?from?C_NightCheckList
??????????????????where?nHotelId=@nHotelId?order?by?nId?desc




?二、?數(shù)據(jù)

?????1.?數(shù)據(jù)集?Title??SQL語句：?select?cName?from?tHotelS?where?nId=@nHotelId

?????2.?數(shù)據(jù)集?HotelDB??SQL語句

SELECT?A.cName?AS?cGuestName,?A.dArrivedTime,?A.dLeftTime,A.nGuestCount,?A.nKidCount,A.cPactCompany,
???????B.cCode?AS?cRoomCode,
???????C.cName?AS?cGuestKindName,
???????D.cCode?AS?cRoomKindCode,??
???????E.cCode?AS?cRateCode,
???????F.cCode?AS?cMarkCode,
???????G.cTeamCode,
???????isnull(dbo.F_GetGuestRoomPriceRM(A.nHotelId,A.nId),0.00)?AS?RoomRate,
???????isnull(dbo.F_Z_GetProductPriceByRentKind(1,dbo.F_GetGuestRoomProduct(A.nHotelId,A.nId),A.nRentKindId,1),0.00)?AS?nPrice,?
???????isnull(dbo.F_GetGuestRoomAllPrice(A.nHotelId,A.nId),0.00)?AS?nTotalPrice,
???????isnull(dbo.F_GetConsumeTolValue_NoCash(A.nId,?2,?A.nHotelId),0.00)?AS?AccountEnd,?
???????isnull(dbo.F_GetPrecashTolValue(A.nId,?2,?A.nHotelId),0.00)?AS?AccountPrecash,
???????num=1
?From?C_NGuest?H?LEFT?OUTER?JOIN?
??????C_Guest?AS?A?ON?A.nId=H.nGuestId?LEFT?OUTER?JOIN
??????B_Room?AS?B?ON?B.nId?=?A.nRoomId?LEFT?OUTER?JOIN
??????B_GuestKind?AS?C?ON?C.nId?=?A.nGuestKindId?LEFT?OUTER?JOIN
??????B_RoomKind?AS?D?ON?D.nId?=?B.nRoomKindId?LEFT?OUTER?JOIN
??????B_RentKind?AS?E?ON?E.nId?=?A.nRentKindId?LEFT?OUTER?JOIN
??????B_MarkCode?AS?F?ON?F.nId?=?E.nMarkCodeId?LEFT?OUTER?JOIN
??????C_Bill?AS?G?ON?G.nId?=?A.nBillId
Where?H.nHotelId=@nHotelId
??????and?H.nNightCheckListId=@NightCheckListId
??????and?(G.bIsTeam?in?(@Team)?or?2=@Team)
??????and?B.nAreaId?in(@Area)
??????and?C.nId?in?(@VIP)
??????and?D.nId?in?(@RoomKind)
Order?BY?cRoomCode


三、布局

??房態(tài)查詢表
???=First(Fields!cName.Value,?"Title")
???="歷史在店"+Parameters!Team.Label+"一覽表"
???=Parameters!NightCheckListId?.Label
???="打印時間："+Now
??1.?插入一行
????團代碼
????VIP
????房型
????房號
????姓名
????合約公司
????抵店日期
????離店日期
????人數(shù)
????小孩數(shù)
????市場代碼
????合約類型
????合約價
????純房租
????房價
????客帳余額


??2.?插入一行
????=Fields!cTeamCode.Value
????=Fields!cGuestKindName.Value
????=Fields!cRoomKindCode.Value
????=Fields!cRoomCode.Value
????=Fields!cGuestName.Value
????=Fields!cPactCompany.Value
????=FormatDateTime(Fields!dArrivedTime.Value,2)
????=FormatDateTime(Fields!dLeftTime.Value,2)
????=Fields!nGuestCount.Value
????=Fields!nKidCount.Value
????=Fields!cMarkCode.Value
????=Fields!cRateCode.Value
????=Fields!nPrice.Value
????=Fields!RoomRate.Value
????=Fields!nTotalPrice.Value
????=Fields!AccountEnd.Value-Fields!AccountPrecash.Value

??3.?總計
??=Sum(Fields!num.Value)
??=Sum(Fields!nGuestCount.Value)
??=Sum(Fields!nKidCount.Value)
??=Sum(Fields!nPrice.Value)
??=Sum(Fields!RoomRate.Value)
??=Sum(Fields!nTotalPrice.Value)
??=Sum(Fields!AccountEnd.Value)-Sum(Fields!AccountPrecash.Value)

??4?頁腳

???="頁："+Format(Globals!PageNumber)+"/"+Format(Globals!TotalPages)



四、函數(shù)

??

轉(zhuǎn)載于:https://www.cnblogs.com/callbin/archive/2010/02/01/1661206.html

總結(jié)

以上是生活随笔為你收集整理的历史客人－报表记录信息的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。