Problem In report

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

 

Give some fix width to each column then define Line : 0

 

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

 

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

 

Use Command
in Part
Scroll : Both

 

Already used sir ...

 

What happen sir...

 

Thank

You sir for your kind help...
Thank u very much..

 

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

 

Thanks a lot sir now it's working fine...