Need help for Genarte HTML with Rowspan.

Question

Need help for Genarte HTML with Rowspan.

panneermca35

Mr or Mrs. 500

Points: 504
More actions
June 27, 2016 at 1:26 am

#319591

Hi All,
I want to generate the HTML with rowspan and colspan using sql query.
I can create HTML table but unable to give rowspan to TD tags.
Please give me the suggestions.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 1

panneermca35 (6/27/2016)
Hi All,
I want to generate the HTML with rowspan and colspan using sql query.
I can create HTML table but unable to give rowspan to TD tags.
Please give me the suggestions.

Can you please elaborate further with sample data and what you have tried so far.

😎

panneermca35 Mr or Mrs. 500 Points: 504 More actions · Answer 2

Hi,

Unable to paste sample table format here.

I want to generate html like below

--------------------------|

No | name | Department |

--------------------------|

1 |Ram | Payroll |

------------| |

2 |John | |

---------------------------

3. |Peter | HRM |

---------------------------

But i generated the below HTML

--------------------------|

No | name | Department |

--------------------------|

1 |Ram | Payroll |

------------|-------------|

2 |John | |

---------------------------

3. |Peter | HRM |

---------------------------

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 3

Quick though, count the null columns in each row and add the count to the colspan of the last cell.

😎

panneermca35 Mr or Mrs. 500 Points: 504 More actions · Answer 4

thanks you for the quick reply.

I have done the colspan i want to do rowspan?

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 5

Add the count of each department as the rowspan to the first department cell of each department, easy with count and row_number over (partition by department)

😎

lda.190 SSC Rookie Points: 28 More actions · Answer 6

panneermca35 - Monday, June 27, 2016 1:26 AM
Hi All,I want to generate the HTML with rowspan and colspan using sql query.I can create HTML table but unable to give rowspan to TD tags.Please give me the suggestions.

I need the same. Can you found the solution?

lda.190 SSC Rookie Points: 28 More actions · Answer 7

panneermca35 - Monday, June 27, 2016 1:26 AM
Hi All,I want to generate the HTML with rowspan and colspan using sql query.I can create HTML table but unable to give rowspan to TD tags.Please give me the suggestions.

I need the same. Can you found the solution?