Dear All, I am creating a report with 42 column and every column title is different from other column. problem is that all columns are squeezed. i am attching jpg image of report. pls guide me . how i solve this problem. thanks & Regards Rishi
You need to add REPEAT at all line levels (Title+Data). Repeat : Title1 (the name of column before which you need it to be static.) This is same as Freeze Panes in Excel.
Dear Sir, You are saying right but i am unable to understand how to implement this. Please give me one example how to Freeze Panes. The same is happening is sale Register Columnr Report. i am giving you little coding of report pls tell me where i used to Repeat Attributes and how? [Report:Shipment Report] Form: Shipment Report Title: " Shipment Report" PrintSet : Report Title : " Shipment Report" PrintSet : Report SubTitle : "" ;; if @@Use Export : Yes [form:Shipment Report] Use: DSP Template Full Height:Yes Full Width:Yes Button: Explode Flag, F2 ChangePeriod, ChangeCompany Key: ChangePeriod Parts: DD TB period, DD TB Part PageBreak : DSP ClPageBreak, DSP ColOpPageBreak Background : White, Light Petal Pink [Part: DD TB Part] Lines: Cust SR Title , Cust SR Line Bottom Line: Cust SR Bottom Line Repeat: Cust SR Line: Columnar Vouchers of Company Common Border: Yes Total: Cust LebAmt, Custt Net Qty,Cust Taxable Scroll: Vertical PageBreak : DSP ColClPgBreak, DSP ColOpPgBreak [Line:Cust SR Title] Use: Cust SR Line Local: Field: Default: Type: String Local: Field: Default:Align: Centre Local:Field: Default: Style:Normal Bold Border: Thin Top Bottom Local:Field: Cust Led Amt:Set as : if $$IsEmpty:##SVColumnName then ##SVColumnType else ##SVColumnName Local: Field: Cust Month:Set as: "Month" Local:Field: Cust Inv No: Set as:"Invoice No" Local:Field: Cust Inv Date: Set as: "Invoice Date" [Line:Cust SR Line] Fields:Cust Month,Cust Inv No pls guide me Thanks & Regards Rishi Kumar
Sir there is 41 title column , I have mention only three for ex purpose month,invoice no, invoice date
Thanks Sir, As you know i have three Lines first Cust SR Title,second Cust SR Line and third bottom line:Cust SR Bottom Line I applied " Repeat:Cust Inv No " on all three lines but no result. sir main problem is all Column are adjust in one screen. thats why they are showing squeez manner. pls see the attachment . how i increase the width? Full Width, 100% Screen, 100% Page i applied all but no result. Thanks & Regards Rishi
If you want answers and actual solutions than put up the appropriate section/part of the code. Otherwise it will be just back and forth and back and forth and back and forth. Sometimes a attribute does not work because there is already a SET Attribute at a higher level.
ok sir. I am explaing my report Structure. Report Construction as follow: [Report: Shipment Report] Form: Shipment Report Title: " Shipment Report" [Form: Shipment Report] Use: DSP Template Height:100% Page Width:100% Page Parts: DD TB period, DD TB Part PageBreak : DSP ClPageBreak, DSP ColOpPageBreak Background : White, Light Petal Pink [Part: DD TB period] Line: DD TB Period [Line: DD TB Period] Right Fieldsp MainDateTitle [Part: DD TB Part] Lines: Cust SR Title , Cust SR Line Bottom Line: Cust SR Bottom Line Repeat: Cust SR Line: Columnar Vouchers of Company Common Border: Yes Total: Cust LebAmt, Custt Net Qty,Cust Taxable Scroll: Vertical PageBreak : DSP ColClPgBreak, DSP ColOpPgBreak Title Line--- [Line: Cust SR Title] Use: Cust SR Line Local: Field: Default: Type: String Local: Field: Default:Align: Centre Local:Field: Default: Style:Normal Bold Border: Thin Top Bottom Local:Field: Cust Led Amt:Set as : if $$IsEmpty:##SVColumnName then ##SVColumnType else ##SVColumnName Local: Field: Cust Month:Set as: "Month" Local:Field: Cust Inv No: Set as:"Invoice No" Local:Field: Cust Inv Date: Set as: "Invoice Date" Local: Field: Cust PO: Set as: "PO No." Local:Field: Cust Order Ref.No: Set as:"Order Ref.No." Local:Field:Cust Order Date:Set as: "Order Date" Local:Field:Cust Customer Name:Set as:"Customer Name" Local: Field:Cust Bill To: Setas:"Bill To" Local: Field:Cust Ship To: Setas:"Ship To" Local: Field: Cust Destination: Setas:"Destination" Local: Field:Cust Product: Setas:"Product" Local: Field:Cust Item Desc.: Setas:"Item Descrption" Local: Field:Custt Lenght: Setas:"Length" Local: Field:Custt Width: Setas:"Width" Local: Field:Custt Thick: Setas:"Thickness" Local: Field:Custt Net Qty: Setas:"Net Qty" Local: Field:Custt Gr.Weight: Setas:"Gross Weight" Local: Field:Custt noof Pack: Setas:"No. of Packet" Local: Field:Custt Noof Sheet: Setas:"No. of Sheet" Local: Field:Custt PackMode: Setas:"Pack Mode" Local: Field:Cust LR: Setas:"LR.No" Local: Field:Cust LR date: Setas:"LR.Date" Local: Field:Cust Truck: Setas:"Truck" Local: Field:Custt Transport: Setas:"Transport" Local: Field:Cust Driver: Setas:"Driven Contact No." Local: Field:Cust Payment: Setas:"Payment Terms" Deatils Line:--- [Line:Cust SR Line] Fields:Cust Month,Cust Inv No ,Cust Inv Date,Cust PO,Cust Order Ref.No,Cust Order Date,Cust Customer Name,Cust Bill To,Cust Ship To, + Cust Destination,Cust Product,Cust Item Desc.,Custt Lenght,Custt Width,Custt Thick,Custt Net Qty,Custt Gr.Weight,Custt noof Pack,Custt PackMode, + Cust LR,Cust LR date,Cust Truck,Custt Transport,Cust Driver,Cust Payment, Cust Led Amt, Cust Inv., + Cust HSN,Cust Custo.GST,Cust Custo.Pan,Cust LC [Field: Cust Month] Use : Uni Date Field Set as : $Date Style : Normal ;;Border : Thin Left Width : 40 ;;if NOT $$InPixelMode then 11 else @@ShortDateWidth Border: Thin Right Line:0 [Field:Cust Inv No] Use : Short Name Field Set as : @OptStr + $VoucherNumber OptStr : If $IsPostDated And $Date>@@EntryEndingat Then $$LocaleString:"(Post-Dated) " Else If $IsOptional Then $$LocaleString:"(Optional) " Else "" Width : 40 Style : Normal ;;Bound : 8,15 Align : Right Scroll : Yes Border: Thin Right [Field:Cust Inv Date] Set as:"12/08/23" Width: 20 Border: Thin Right Line:0 [Field:Cust PO] Set as:"15568" Width: 20 Border: Thin Right [Field:Cust Order Ref.No] Set as:"12/08/23" Width: 20 Border: Thin Right [Field:Cust Order Date] Set as:"" Width: 20 Border: Thin Right [Field:Cust Customer Name] Use: Name Field Set as:"" ;;Width: 10 Border: Thin Right [Field:Cust Bill To] Use:Name Field Set as:"" ;;Width: Border: Thin Right [Field: Cust Ship To] Use:Name Field Set as:"" ;;Width: 10 Border: Thin Right [Field:Cust Destination] Set as:"" Width: 10 Border: Thin Right [Field: Cust Product] Set as:"" Width: 20 Border: Thin Right [Field:Cust Item Desc.] Set as:"" Width: 20 Border: Thin Right [Field:Custt Lenght] Set as:"" Width: 20 Border: Thin Right [Field:Custt Width] Set as:"" Width: 20 Border: Thin Right Botton Line: [Line: Cust SR Bottom Line] Border : Flush Totals Space Top : if $$InPrintMode then 0.25 else 0 Fixed : Yes Use:Cust SR Line Local:Field: Cust Led Amt:Set as : If $$IsRemoteCompany then @@AsLedColtotVal Else $$TotalBCLedAmt Local: Field: Cust Month:Set as: "" Local:Field: Cust Inv No: Set as:$$LocaleString:"Grand Total" Local:Field: Cust Inv Date: Set as: "" Local: Field: Cust PO: Set as: "" Local:Field: Cust Order Ref.No: Set as:"" Local:Field:Cust Order Date:Set as: "" Local:Field:Cust Customer Name:Set as:"" Local: Field:Cust Bill To: Setas:"" Local: Field:Cust Ship To: Setas:"" Local: Field: Cust Destination: Setas:"" Local: Field:Cust Product: Setas:"" Local: Field:Cust Item Desc.: Setas:"" Local: Field:Custt Lenght: Setas:"" Local: Field:Custt Width: Setas:"" Local: Field:Custt Thick: Setas:"" Local: Field:Custt Net Qty: Setas:$$Total:CusttNetQty Local: Field:Custt Gr.Weight: Setas:"" Local: Field:Custt noof Pack: Setas:"" Local: Field:Custt Noof Sheet: Setas:"" I have not Pasted all Field but my report structure is as I Paste here. Nothing other than this ... Pls Guide me. Thanks & regards Rishi
If in your Report you need to FREEZE the 2nd column ---- then .... at LINE level --- add the line --- Repeat : {3rd column FIELD name} Also -- If not added or put --- then at PART Level --- Scroll : Vertical
Dear Sir, Repeat Attribute is not working in my report. Some problem I am facing . First I have used scroll : Both in my report and replaced Scroll both to Scroll Vertical. Report squeezed. Pic Attched. Second: I leave scroll as it is and apply Repeat Attribute then Error msg showing . This is part definition [Part: LWHeaderPart] Line : LWTitleline,LWDetailLine Repeat : LWDetailLine : SalesColl Scroll : Vertical Vertical : Yes Common Border : yes Float : No Border : Thin Bottom [Line: LWTitleline] Field : Cust Month , Cust Inv no , Cust Inv Date , Cust PO No ,Cust OrderRef ,Cust OrderDate ;;6 Right Field : Cust Customer Name , Cust Bill To , Cust Ship To, Cust Destination, Cust Product ;;5 Right Field : Cust Item Des , Custt Lenght , Custt Width , Custt Thickness , Cust Net Qty ,Cust Gross Weight, Cust NoofPackets ;;7 Right Field: Cust NoofSheets , Custt Pack Mode , Custt LR,Custt LR date,Cust TruckNo ,Custt Transport , Cust Driver Contact Right Field: Cust Payment Terms , Cust Freight Terms , Cust BasicPrice , Cust TaxableValue , Cust FreightAmt , Cust packingCharge Right Field: Cust InsCharges, Cust SGST, Cust CGST , Cust IGST ,Cust TCS,Cust InvValue , Cust HSN , Cust CustGSTNo , Cust CustPanNo,Cust LC Ref Border : Totals Repeat:Cust PO No [Line:LWDetailLine] Field : Cust Month , Cust Inv no , Cust Inv Date , Cust PO No ,Cust OrderRef ,Cust OrderDate ;;6 Right Field : Cust Customer Name , Cust Bill To , Cust Ship To, Cust Destination, Cust Product ;;5 Right Field : Cust Item Des , Custt Lenght , Custt Width , Custt Thickness , Cust Net Qty ,Cust Gross Weight, Cust NoofPackets ;;7 Right Field: Cust NoofSheets , Custt Pack Mode , Custt LR ,Custt LR date,Cust TruckNo ,Custt Transport , Cust Driver Contact Right Field: Cust Payment Terms , Cust Freight Terms , Cust BasicPrice , Cust TaxableValue , Cust FreightAmt , Cust packingCharge Right Field: Cust InsCharges, Cust SGST, Cust CGST , Cust IGST , Cust TCS, Cust InvValue , Cust HSN , Cust CustGSTNo , Cust CustPanNo,Cust LC Ref Local : Field : Default : Style : Normal Local:Fieldefault:Align:Centre Explode:SLedDup_ReportsDescExp2:Yes Border : Thin TopBottom Option : Alter on Enter Repeat:Cust PO No Exploded part========== [Part:SLedDup_ReportsDescExp2] Line: Shipping Explode Repeat:Shipping Explode: InventoryEntries [Line:Shipping Explode] Field : Cust Month , Cust Inv no , Cust Inv Date , Cust PO No ,Cust OrderRef ,Cust OrderDate ;;6 Right Field : Cust Customer Name , Cust Bill To , Cust Ship To, Cust Destination, Cust Product ;;5 Right Field : Cust Item Des , Custt Lenght , Custt Width , Custt Thickness , Cust Net Qty ,Cust Gross Weight, Cust NoofPackets ;;7 Right Field: Cust NoofSheets , Custt Pack Mode , Custt LR ,Custt LR date,Cust TruckNo ,Custt Transport , Cust Driver Contact Right Field: Cust Payment Terms , Cust Freight Terms , Cust BasicPrice , Cust TaxableValue , Cust FreightAmt , Cust packingCharge Right Field: Cust InsCharges, Cust SGST, Cust CGST , Cust IGST , Cust TCS, Cust InvValue , Cust HSN , Cust CustGSTNo , Cust CustPanNo,Cust LC Ref Border: Thin Bottom Repeat:Cust PO No am I applying right or committing mistake pls advice thanks rishi
For using REPEAT at Line level -- there should not be any RIGHT FIELDS..... both cannot exists together. Make all Fields as LEFT FIELD or just FIELD.