Alternate to sql web assistant

I am currently with sql 2k5 and using web assistant to generate some HTML files and email the same automatically to a set of users.

these html files that are generated are processed via a JOB in sql server.

I am in process of replacing of the web assistant procedures.

Is this possible to make this with XQuery of SQL Server 2K5 and convert it into HTML files with Stored Procedure.

Is there any other possible way to do it?

Hi Brinda,

I have similar stored procedures that use web assistnant to generate xls files and then email them. I have heard that web assistant can be replaced with reporting services in SQL2K5, but I am unaware of the details of how to do this-if anyone has details on this I am interested to learn about it.

Thanks,

-Dave

All that extra whitespace that displays in HTML

So I have a footer row in a table that is set to 0 height. Actually it is set to 0.03125in because SSRS doesn't allow a 0 height, but whatever.
When I view this in the designer preview, life is good. The amount of whitespace on each footer is minimal and a minor nuisance.

But after deploying to the server and viewing in the web browser, the whitespace is much more pronounced. Any special reason why these display differently, and any way to shrink down that HUGE row whitespace?

Can't you just select the whole footer row and delete it if you are not using it for anything? That would eliminate the space on the report.|||

Please give me a little credit. I know how to delete a row.

No that won't work. This is a sweet little workaround for other major deficiencies that exist in SSRS.

But now the new problem is that the way HTML is rendered in the Report Viewer is different than the display in the Visual Studio environment. Namely all that extra whitespace and no way seemingly to control it by specifically setting the size of the row or assigning css styles.