PDF and Merge Cell Border Style Issue

Problem: I have borders that are hidden (Border Style=None) that appear ok in HTML but when Render in PDF they appear when they should not. Basically I am using a few columns like TABS in one Major Column in my report in combination with Merge Cells.

In Sql2000 -> There is no problem in the HTML or PDF rendering.

In Sql2005SP1 -> The problem occurs in two forms:

a) Problem Only Shows up in the PDF Creation call in our ASPX in IIS

b) Problem occurs in both the ASPX call and the Reporting Services Report Upload (Export to PDF)

Is there a fix to this issue or work around?

Solution

1) Reset All Border Styles and Border Colors to Vanilla (I mean every cell)

2) Redo your Border Styles etc but be careful -> It kinda like chess

This is due to that Sql2000 and Sql2005 handles the narly RDL Rendering conflicts differently.

Pb with group and lost of informations in the report

But I have problem with reporting services. Could you help me?

For exemple, I have some informatins who don't appear in my report. For example, I have a list of agricultur who are ranged in three different groups( A,B or C). I want to put their names by grouping them in their departement and their town.

Then, a second group on the departement

And finally, a group on the town. But agriculteurs can have a departement and no town, that's why I put them under the departement, and before, the towns of the departement.

For examples for a group, I want to see :

Group A

Auvergne

Mr smith

Mr nicoli

Mr autain

Aubière

Mr potier

Mr dupont

Clermont-ferrand

Mme Pilla

Mr tilmont

Mr aubigny

But, in fact, with reporting services, you don't see Mr nicoli and Mr autain. And I don't understand why? Could you help me?

Salut,

Si j'ai bien compris, tu aurais une dimension Gographie avec une hirarchie

Groupe|||

what i suggest is...

only group by ur groups i.e A B & C and under that group by department ,

then sort the records by Town wise, display town beside the name of the agricultur and make it display only once .

do not have a group for Town.

hope it works for u

|||Oui, tu as tout compris, je dois mettre le nom des agriculteurs sous le nom de dpartement et/ou de ville.J'ai stock mes donnes dans un tableau, j'ai insr un group 1 sur groupe(A,B,ou C) un group 2 sur dpartement, et un group 3 sur ville. Et entre group 2 et 3, c'est à dire sous dpartement, j'ai des agriculteurs qui n'appartiennent à aucune ville. Et comme ce sont des lignes de groupes, et pas des lignes de dtails, j'ai l'impression que reporting services, ne prend pas tous les agriculteurs. Et là est mon soucis.Comment lui faire afficher les agriculteurs qui me manquent. Tu veux d'autres prcisions?|||

Hum, well,I must display the name of the town before the agricultur sometimes, when I have agriculturs in the town. I can't inverse the town and the agriculturs. But do you know a way to display all the information between two groups? Or is it a bug of reporting services?

Moreover, for another thing, I want not to display an empty line, but I don't find, so I do Iif(condition, " " ,my treatment) and I have big white. Normal, But I can't find anything else to display what I want.

|||

you cannot say it as bug, only it is designed like that, the grouping will always be Hierarchical(vertical). you can have only one group under a group .

practically think , can u have multiple bosses or a single boss. 99% of people will have a single boss. that means only one group under a group.

Unless manual method, i think u never find a reporting tool to support ur cause..

if u do not want to display blank line or empty line. u can use CASE statement in ur SQL query to replace blank or null values in Town Column by whatever u want.