PDF Rendering Problem

I started to develop a pdf rendering problem when switching to my new Dell
830 notebook. The same matrix type report now have text running over cell
boundary lines - it never happened before. I even tried to change the
resolution back to 1024x768 - using 1920x1200 now - it didnt have any affect.
I use Adobe 8 and SQL Reporting Services as part of the SQL 2005 Express
edition, Windows XP Professional SP2.On Jul 24, 6:34 am, Dawie <Da...@.discussions.microsoft.com> wrote:
> I started to develop a pdf rendering problem when switching to my new Dell
> 830 notebook. The same matrix type report now have text running over cell
> boundary lines - it never happened before. I even tried to change the
> resolution back to 1024x768 - using 1920x1200 now - it didnt have any affect.
> I use Adobe 8 and SQL Reporting Services as part of the SQL 2005 Express
> edition, Windows XP Professional SP2.
If you are not using the SP2 version of SQL Server 2005 Express
Edition w/Advanced Services, this might help. Also, if there are
updates available for Adobe Reader, you might want to look into those.
Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

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.

patindex that I can use in RS?

Basically, I am trying this in a table cell expression:
=iif(patindex('%-%', Fields!courseName.Value) <>
0,left(Fields!courseName.Value, patindex('%-%',
Fields!courseName.Value)-1),Fields!courseName.Value)
It errors because it says patindex is not declared. I tried doing this part
in my query in a stored proc instead but was unable to get the results I
needed, so thought I would try in RS instead.
Is there any way for me to do this in RS? Basically in my stored proc I was
trying to do:
Query where patindex <> 0
Union
Query where patindex = 0
The field I am trying to fix is basically: â'Name â' explanationâ' and all I
want is the name before the â?...â'. But there are some fields with just â'Nameâ'
and no dash or explanation. With my union statement, instead of getting:
Name1
Name2
Name3
I get
Name1
Name1 â' Explanation
Name2
Name2 - Explanation
Name3
Name3 â' Explanation
The query I am using now gives me the results I want (correct records) and I
am trying to split out the name in RS.
Thank you for your time and help!WHen you are in an expression you are talking VB.NET...
Instr is the function you are looking for...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"SharinDenver" wrote:
> Basically, I am trying this in a table cell expression:
> =iif(patindex('%-%', Fields!courseName.Value) <>
> 0,left(Fields!courseName.Value, patindex('%-%',
> Fields!courseName.Value)-1),Fields!courseName.Value)
> It errors because it says patindex is not declared. I tried doing this part
> in my query in a stored proc instead but was unable to get the results I
> needed, so thought I would try in RS instead.
> Is there any way for me to do this in RS? Basically in my stored proc I was
> trying to do:
> Query where patindex <> 0
> Union
> Query where patindex = 0
> The field I am trying to fix is basically: â'Name â' explanationâ' and all I
> want is the name before the â?...â'. But there are some fields with just â'Nameâ'
> and no dash or explanation. With my union statement, instead of getting:
> Name1
> Name2
> Name3
> I get
> Name1
> Name1 â' Explanation
> Name2
> Name2 - Explanation
> Name3
> Name3 â' Explanation
> The query I am using now gives me the results I want (correct records) and I
> am trying to split out the name in RS.
> Thank you for your time and help!
>

Password field (very important)

A collegue from me used the MySQL database before (I haven't done this before). He asked me, if it is possible to store a MD5 hash in a cell.

He telled me that MySQL has got a special function wich computes the hash value. Can someone help me?

Thanks for help

This isn't a MySQL forum so you're fairly unlikely to get an answer here.

-Jamie

|||Sorry for my bad writing. I've forgotten to ask, whether it is possible to make this with the MSSQL.|||

I don't know if its possible in SQL Server but its possible to do it in SSIS (this is a SSIS forum after all).

Donald Farmer's book has a chapter telling you how to generate MC5 values in SSIS. Search for it on Amazon.

-Jamie