Table not show any data

Deat Admin & Experts,

I try to call group name under sundry debtors & in second line call ledger List under sub group how belongs to sundry debtors. Pls guide me.


Mani

[#Menu : Gateway of Tally]
Add : Key Item : After @locQuit:Class Result : L : Display: Result
;;@@locVouchers
[Report : Result]
Use : DSP Template
Form : Result
Title : Student Result Report
Object : Ledger
[Form : Result]
Use : DSP Template
Part : Class Name
Height : 50% Page ;;else 100% Page
Width : 50% Page ;;100% Page
;;Button : STUDENT NAME
;;Button : SCHOLLER NUMBER
[Part : Class Name]

Lines : ClassName, StudentName, ;;schollerNumber
[Line : ClassName]

Field : ClassNameH
Right Field : ClassName
[Field : ClassNameH]
Use : Name Field
Set as : "Class Name"
Width : 50
style : EnvStyleBOLD
Align : Left
;; Object : Ledger
Space Left : 10 mms
;; Storage : RClassName
[Field : ClassName]
Use : Name Field
Table : StudentName, Not applicable
Show Table : Always
Set as : $Name
;; Storage : CLassNM
Width : 50
style : Large Bold ;;EnvStyleBOLD
Align : Left

[Collection: StudentName]
Title: $$LocaleString:"Student Name"
Type: Ledger
Child Of:"Students"
Fetch : *.*

 

Hi Mani,

Your code has some errors,

1. You dont need to specify Object association in the report unless, if you want to retain anything in this repot. Even so, if you want to retain values in this report, you need to mention the following object
   
   Code:

    
   [Report : Result]
   Use : DSP Template
   Form : Result
   Title : Student Result Report
   ;Object : Ledger
   Object : Company
   

2. Your part class name has two lines, but in your post you missed to mention the "StudentName" line definition., but according to the screenshot, I assume you have written the definition in your code. Towards the solution for this code, I'll suggest this following code., lets check if this works for you..
   
   Code:

   [Line : StudentName]
   Field : StudentNameH
   Right Field : StudentName
   [Field : StudentNameH]
   Use : Name Field
   Set as : "Student Name"
   Width : 50
   style : EnvStyleBOLD
   Align : Left
   ;; Object : Ledger
   Space Left : 10 mms
   ;; Storage : RClassName
   [Field : StudentName]
   Use : Name Field
   Table : StudentName, Not applicable
   Show Table : Always
   Set as : $Name
   ;; Storage : CLassNM
   Width : 50
   style : Large Bold ;;EnvStyleBOLD
   Align : Left
   
   

• You said that you call group in the class name, whereas your code showing the ledger collection which should be in the students name....I can see some confusion with your code... here I share the full corrected code., you may use that or change it according to your usage
  
  Code:

  [#Menu : Gateway of Tally]
  Add : Key Item : After :@@locQuit:Class Result : L : Alter: Result
  ;;@@locVouchers
  [Report : Result]
  Use : DSP Template
  Form : Result
  Title : Student Result Report
  ;Object : company
  [Form : Result]
  Use : DSP Template
  Part : Class Name
  Height : 50% Page ;;else 100% Page
  Width : 50% Page ;;100% Page
  ;;Button : STUDENT NAME
  ;;Button : SCHOLLER NUMBER
  [Part : Class Name]
  Lines : ClassName, StudentName, ;;schollerNumber
  [Line : ClassName]
  Field : ClassNameH
  Right Field : ClassName
  [Field : ClassNameH]
  Use : Name Field
  Set as : "Class Name"
  Width : 50
  style : EnvStyleBOLD
  Align : Left
  Skip:Yes
  ;; Object : Ledger
  Space Left : 10 mms
  ;; Storage : RClassName
  [Field : ClassName]
  Use : Name Field
  Table : Class Name, Not applicable
  Show Table : Always
  Set as : $Name
  ;; Storage : CLassNM
  Width : 50
  style : Large Bold ;;EnvStyleBOLD
  Align : Left
  [Line : StudentName]
  Field : StudentNameH
  Right Field : StudentName
  [Field : StudentNameH]
  Use : Name Field
  Set as : "Student Name"
  Width : 50
  style : EnvStyleBOLD
  Align : Left
  Skip:Yes
  ;; Object : Ledger
  Space Left : 10 mms
  ;; Storage : RClassName
  [Field : StudentName]
  Use : Name Field
  Table : StudentName, Not applicable
  Show Table : Always
  Set as : $Name
  ;; Storage : CLassNM
  Width : 50
  style : Large Bold ;;EnvStyleBOLD
  Align : Left
  [Collection: ClassName]
  Title: $$LocaleString:"Class Name"
  Type: Group
  Fetch : *.*
  [Collection: StudentName]
  Title: $$LocaleString:"Student Name"
  Type: Ledger
  Child Of:#ClassName
  Fetch : *.*