PDF renders group incorrectly

I have a report which is rendered to PDF. When the report was run recently, the PDF showed the grouping incorrectly. When the report was run again, the grouping was correct.
Is there any way to avoid having the PDF render the groups incorrectly?

Here's an example of what I'm seeing in the PDF - in the first run, 2 items which should be displayed with id002 are displayed under id001 instead, but the total of items is shown correctly.

Run #1 - wrong

id001 name1 item 1a$1.00 item 1b$1.00 item 2b$1.00 item 2c$1.00$2.00

id002 name2 item 2a$1.00$3.00

Run #2 - right

id001 name1 item 1a$1.00


item 1b$1.00$2.00

id002 name2 item 2a$1.00

item

2b$1.00

item

2c$1.00$3.00

Is this only happening in the PDF output? What about HTML?

PDF Rendering bug

We are trying to publish a group of financial reports using SQL Server
Reporting Services. We have hit a snag when we try to render the reports in
PDF format. The leading spaces of each line are stripped in the output
file. For example:

Department 10.7240 - ICU

Expenses SubDepartment
-- -
1,200 100
454 150

Becomes:

Department 10.7240 - ICU

Expenses SubDepartment
-- -
1,200 100
454 150

Does anyone know a solution for this problem? By the way, we did upgrade to SP2.
That did not correct the problem.

This blog entry (actually the comments for the entry) discusses same. Long story short, the PDF extension strips leading spaces in this version of SSRS, and there is no workaround :(

http://blogs.msdn.com/bimusings/archive/2005/06/15/429607.aspx

It sounds like you are "artificially" adding these spaces to make things line up. Can you re-position the textboxes which show the values and/or use the alignment settings to make the same thing happen?

|||

Thanks for the information. Actually we are moving a fully formatted report from an old DEC Alpha system to .pdf files. Currently this is done manually. It is a process that involves cutting and pasting hundreds of pages of the original report into output for individual departments. The SSRS report consists of a single text box to hold the lines of the source report. That is why we have leading spaces.

We are able to do all the breakout of individual sections using SQL Server, but It looks like we will have to find another product to do the final conversion from text to .pdf. Actually, tiff files come out great, but they are huge and slow.

Thanks again for the good information.

PDF Export and extra pages

I'm having a problem exporting a report to PDF. In the viewer, the report looks great. When I export to PDF, all the group totals end up on a separate page. This inflates the pages by a great deal for a good size report.
I'm using SQL Server 2005 beta2 but I have also read about this problem in 2000 SP2. Does anyone have a solution to this? I'm going crazy trying to figure out the answer!!!
Thanks fir any replies,
Bill
The report width is too large.
Click on the main area of the report and observe the size in the properties.
Now click on the gray area outside the report and look at the PageSize and the Margins properties.
The width of the report itself must be less than or equal to the width in the PageSize property minus the sum of the left and right margins.|||Have you read the following blog article:
http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx

It explains some of the "magic" related to page breaks and logical vs. physical page rendering.

-- Robertsql

PDF Byte Error?

I've been reading through the group and seems like a lot of people
have been trying to display the report as a PDF in IE. However, the
byte stream is wrong so it won't allow it.
Does this happen in both methods that generate the output: the SOAP
Render method, and the URL Access (Format='PDF')?
Also, can someone tell me what the correct btye order/size needs to
be. We will use the render method, and then try to correct it by
writing a program. We'll then use the 'corrected' file and display in
a web browser.
Thanks,
rwiethornActually, it displays correctly in IE (which just launches Acrobat to
display the file).
The problem is that third-party tools for post-processing PDF aren't as
forgiving as Acrobat and might have trouble with our noncompliant format.
(We are, however, aware of the bug and have it in the queue to get fixed...
No estimate on when)
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"rwiethorn" <rwiethorn2002@.yahoo.com> wrote in message
news:553a0349.0408061300.54ad3e7d@.posting.google.com...
> I've been reading through the group and seems like a lot of people
> have been trying to display the report as a PDF in IE. However, the
> byte stream is wrong so it won't allow it.
> Does this happen in both methods that generate the output: the SOAP
> Render method, and the URL Access (Format='PDF')?
> Also, can someone tell me what the correct btye order/size needs to
> be. We will use the render method, and then try to correct it by
> writing a program. We'll then use the 'corrected' file and display in
> a web browser.
> Thanks,
> rwiethorn|||Hello,
I've found in this group that you have to set Language property of your
report to an expression which contains a '-'.
Fr is not supported but Fr-fr is Ok.
This problem occurs only when you want to generate PDF format.
Jerome Berthaud (MCSD)
http://www.winsight.fr
"rwiethorn" <rwiethorn2002@.yahoo.com> wrote in message
news:553a0349.0408061300.54ad3e7d@.posting.google.com...
> I've been reading through the group and seems like a lot of people
> have been trying to display the report as a PDF in IE. However, the
> byte stream is wrong so it won't allow it.
> Does this happen in both methods that generate the output: the SOAP
> Render method, and the URL Access (Format='PDF')?
> Also, can someone tell me what the correct btye order/size needs to
> be. We will use the render method, and then try to correct it by
> writing a program. We'll then use the 'corrected' file and display in
> a web browser.
> Thanks,
> rwiethorn

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.

Password validation failed

Hello Group,
we got the following message when running execute sp_adduser
Server: Msg 15118, Level 16, State 1, Line 1
Password validation failed. The password does not meet Windows policy
requirements because it is not complex enough.
Server: Msg 15007, Level 16, State 1, Procedure sp_adduser, Line 15
is there a way to turn this off on sql server(2005sp2) level.
Thanks in advancedTal shalom
Firstv of all in SQL Server 2005 using CREATE USER ... is recommended way
instead of sp_adduser.
Now regarding to the error you are getting, it is because you created LOGIN
with 'weak' password.
Please run in query builder (take a look at CHECK_POLICY=OFF parameter in
the BOL)
create login tal with password ='t',
go
create user Joe for login tal
drop user joe
drop login tal
"Tal Bar-Or" <tal_baror@.hotmail.com> wrote in message
news:%23sZnW6gkHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hello Group,
> we got the following message when running execute sp_adduser
> Server: Msg 15118, Level 16, State 1, Line 1
> Password validation failed. The password does not meet Windows policy
> requirements because it is not complex enough.
> Server: Msg 15007, Level 16, State 1, Procedure sp_adduser, Line 15
> is there a way to turn this off on sql server(2005sp2) level.
> Thanks in advanced
>
>
>
>|||Shalom Uri,
Thanks for the answer. I understand that CHECK_POLICY=OFF can be done per
individual login . However can it be done on the SERVER level for ALL
logins. This would help us not nodify the
code when migrationg from SQL 2000 to SQL 2005
Thanks in advanced
Tal,
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eApc3BhkHHA.2272@.TK2MSFTNGP02.phx.gbl...
> Tal shalom
> Firstv of all in SQL Server 2005 using CREATE USER ... is recommended
> way instead of sp_adduser.
> Now regarding to the error you are getting, it is because you created
> LOGIN with 'weak' password.
> Please run in query builder (take a look at CHECK_POLICY=OFF parameter in
> the BOL)
> create login tal with password ='t',
> go
> create user Joe for login tal
> drop user joe
> drop login tal
>
>
> "Tal Bar-Or" <tal_baror@.hotmail.com> wrote in message
> news:%23sZnW6gkHHA.3452@.TK2MSFTNGP04.phx.gbl...
>|||Hi Tal
By default CHECK_POLICY=ON.CHECK_POLICY are only enforced on Windows Server
2003 so I have no idea how to change it .
"Tal Bar-Or" <tal_baror@.hotmail.com> wrote in message
news:%23n$ddThkHHA.4904@.TK2MSFTNGP05.phx.gbl...
> Shalom Uri,
> Thanks for the answer. I understand that CHECK_POLICY=OFF can be done per
> individual login . However can it be done on the SERVER level for ALL
> logins. This would help us not nodify the
> code when migrationg from SQL 2000 to SQL 2005
> Thanks in advanced
> Tal,
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eApc3BhkHHA.2272@.TK2MSFTNGP02.phx.gbl...
>

Passing the User ID and AD group as Parameter

Hi...
I have a requirement where I need to pass the Users Windows userID and the AD group through which he is associated to the database so that I can get appropiate data.

Is there a way I can pass the Windows user ID and the AD group(through which he is authenticated in Reporting Serivces) through the Reporting Serivces as a parameter so that it can be used in the Reporting Query.

Thanks,
siaj

The UserID parameter in the report holds the username information including the logged on domainor machine. getting the AD Group in which the user is authenticated to view the report is a bit different as the user can be in multiple groups, though it can′t be identified which group the user has granted the effective permissions to the report. (if you are hit by a machine gun you probably won′t know which bullet killed you at the end :-) )

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

As Jens says, UserID is just available using the internal object. For the AD group you should consider writing a custom assembly that performs the operation according to your business rules to decide which is THE group among the ones the user may pertain. I've not checked how difficult it will be to write such code in .Net but sounds not much complicated.

Best regards,
Jordi Rambla
MVP SQL Server
SolidQualityLearning|||Hi Siaj,

Were you able to figure this out? I am in need of the same functionality. I undertand .Net has a 'IsInGroup()' function that can check if a user is in a group but I am not sure how it goes...

Thanks,
Ben|||test|||Have you figured this out? I am in the same situation...

Thanks,
Ben

Passing the User ID and AD group as Parameter

Hi...
I have a requirement where I need to pass the Users Windows userID and the AD group through which he is associated to the database so that I can get appropiate data.

Is there a way I can pass the Windows user ID and the AD group(through which he is authenticated in Reporting Serivces) through the Reporting Serivces as a parameter so that it can be used in the Reporting Query.

Thanks,
siaj

The UserID parameter in the report holds the username information including the logged on domainor machine. getting the AD Group in which the user is authenticated to view the report is a bit different as the user can be in multiple groups, though it can′t be identified which group the user has granted the effective permissions to the report. (if you are hit by a machine gun you probably won′t know which bullet killed you at the end :-) )

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

As Jens says, UserID is just available using the internal object. For the AD group you should consider writing a custom assembly that performs the operation according to your business rules to decide which is THE group among the ones the user may pertain. I've not checked how difficult it will be to write such code in .Net but sounds not much complicated.

Best regards,
Jordi Rambla
MVP SQL Server
SolidQualityLearning|||Hi Siaj,

Were you able to figure this out? I am in need of the same functionality. I undertand .Net has a 'IsInGroup()' function that can check if a user is in a group but I am not sure how it goes...

Thanks,
Ben|||test|||Have you figured this out? I am in the same situation...

Thanks,
Ben