1. 

   Deepak, Member

   Hi,

   I went through the manual on How to add serial numbers in the report output for user to identify easily but couldn't find one. Could you suggest if myDBR has any such function to dynamically allocate serial numbers alongside the output.

   Thanks
2. 

   myDBR Team, Key Master

   What serial number are you referring to and where you wish to show it?

   --
   myDBR Team
3. 

   Deepak, Member

   I wish to show the serial number(line number) in the report UI.
   For example:
   when i execute my report it should display with line number(dynamic based on the result set),

   No Name Age Department
   1 AA 26 Software
   2 BB 27 Support
4. 

   myDBR Team, Key Master

   Hi,
   Use dbr.rownum for this.

   select 'dbr.rownum' as '#', Name, Age, Department
   
   from mydata;
   
   

   --
   myDBR Team
5. 

   Deepak, Member

   I can use '@curRow := @curRow + 1 AS No' the mysql function, but i was thinking if myDBR has an inbuilt function.
6. 

   Deepak, Member

   Fantastic that works..

   Thanks

Reply

You must log in to post.