Boot.ini file: format

Showing posts with label format. Show all posts

Tuesday, March 20, 2012

bug? DeviceInfo ColorDepth ignored for TIFF image

Hello!
I have a problem generating report (format = IMAGE) using following
DeviceInfo settings:
<DeviceInfo>
<ColorDepth>1</ColorDepth>
<OutputFormat>TIFF</OutputFormat>
</DeviceInfo>
Using this settings, generated report (TIFF) always has 24 bit color
depth which is default value, and I wanted to generate black & white
report (1 bit)
Documentation states that ColorDepth could be changed only for TIFF,
but it is not true, it always applies the default value and ignores
user settings ?!
Is this a bug in reporting server?
Any ideas on how to generate TIFF 1-bit with Reporting Server are
welcome...
Thanks,
JohnYour observation is correct and yes, this is a known bug. I have passed your
comments along to the appropriate parties.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Smith" <ng950@.yahoo.com> wrote in message
news:de84550e.0408200420.287ad689@.posting.google.com...
> Hello!
> I have a problem generating report (format = IMAGE) using following
> DeviceInfo settings:
> <DeviceInfo>
> <ColorDepth>1</ColorDepth>
> <OutputFormat>TIFF</OutputFormat>
> </DeviceInfo>
> Using this settings, generated report (TIFF) always has 24 bit color
> depth which is default value, and I wanted to generate black & white
> report (1 bit)
> Documentation states that ColorDepth could be changed only for TIFF,
> but it is not true, it always applies the default value and ignores
> user settings ?!
> Is this a bug in reporting server?
> Any ideas on how to generate TIFF 1-bit with Reporting Server are
> welcome...
> Thanks,
> John

BUG: Leading Spaces in PDF stripped

Hello
We are currently generating reports in PDF format and leading spaces are now
being stripped from printed reports. This started to happen when when we
applied SP2. Has anyone else encountered this problem and if so how did you
get around it.
Much appreciated,
Kevin Weir
DirectWest PublishersI'm a little surprised no one has had a similar problem. Leading spaces are
definetly stripped from ALL strings when rendering to PDF. This started to
happen after SP2 was installed.
If someone from Microsoft sees this post are you aware this is an actual bug.
Regards
Kevin Weir
DirectWest Publishers
"Kevin Weir" wrote:
> Hello
> We are currently generating reports in PDF format and leading spaces are now
> being stripped from printed reports. This started to happen when when we
> applied SP2. Has anyone else encountered this problem and if so how did you
> get around it.
> Much appreciated,
> Kevin Weir
> DirectWest Publishers
>|||Kevin,
I have experienced the same thing, I posted a few oddities after applying
SP2 and I have not received any help. Unfortunatley I don't have a
workaround for this one except to redesign. This is very aggravating as I
had to go in to a number of reports to fix once this SP was applied. It was
the only way I could combine bold font with normal and now that does not work
either.
I will continue my search, if I found I will update this post, please do the
same.
"Kevin Weir" wrote:
> Hello
> We are currently generating reports in PDF format and leading spaces are now
> being stripped from printed reports. This started to happen when when we
> applied SP2. Has anyone else encountered this problem and if so how did you
> get around it.
> Much appreciated,
> Kevin Weir
> DirectWest Publishers
>|||Hello
I will certainly let you know if I find a solution.
Now if I could just find link/e-mail address where I could let Microsoft
know about this bug.
"DigitalVixen" wrote:
> Kevin,
> I have experienced the same thing, I posted a few oddities after applying
> SP2 and I have not received any help. Unfortunatley I don't have a
> workaround for this one except to redesign. This is very aggravating as I
> had to go in to a number of reports to fix once this SP was applied. It was
> the only way I could combine bold font with normal and now that does not work
> either.
> I will continue my search, if I found I will update this post, please do the
> same.
> "Kevin Weir" wrote:
> > Hello
> >
> > We are currently generating reports in PDF format and leading spaces are now
> > being stripped from printed reports. This started to happen when when we
> > applied SP2. Has anyone else encountered this problem and if so how did you
> > get around it.
> >
> > Much appreciated,
> >
> > Kevin Weir
> > DirectWest Publishers
> >

Sunday, March 11, 2012

Bug in SSIS?

I am trying to convert a string to a specific date format by using a simple select like this:

SELECT CONVERT(VARCHAR(3), CONVERT(DATETIME, ?, 103),107)

First of all the Parameter ? is not recognized and when i run the Preview it would trought the following error even if i change the ? with '20050101' for example:

===================================

There was an error displaying the preview. (Microsoft Visual Studio)

===================================

Undefined function 'CONVERT' in expression. (Microsoft JET Database Engine)

Program Location:

at Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.Connections.SQLTaskConnectionOleDbClass.ExecuteStatement(Int32 resultType, Boolean isStoredProc, UInt32 dwTimeOut)
at Microsoft.DataTransformationServices.Design.PipelineUtils.ShowDataPreview(String sqlStatement, ConnectionManager connectionManager, Control parentWindow, IServiceProvider serviceProvider, IDTSExternalMetadataColumnCollection90 externalColumns)
at Microsoft.DataTransformationServices.DataFlowUI.DataFlowConnectionPage.previewButton_Click(Object sender, EventArgs e)

Anyone experiencing this kind of problem? Solutions?

Best Regards,

Luis Sim?es

Well the error clearly indicates that Jet doesn't support the function so this would not be an SSIS bug. Have you attempted to look at the Jet docs to see if it supports convert. The last time I used jet it did not.

Thanks,

Matt

|||

Yes you are right.

I have figured it out pretty quickly and i tried to delete this post without success sorry...

It was my mistake! Not really looking into it :P

But thanks :)

Best Regards,

PS: Merry Christmas to All of YOU!

Thursday, February 16, 2012

Breaking up parametersT

One of my parameters is a particular date (in the datetime format 11/05/2002 12:00:00 AM) and I wanted to display only the month and year. How can I do this to just display November 2002 on my report.Try using the DATENAME function. Here's an example using the current date:

declare @.CurrentDate datetime
set @.CurrentDate = GetDate()

select DATENAME(m, @.CurrentDate) + ' ' + DATENAME(yy, @.CurrentDate)

|||Im using visual basic business intelligence. I did figure out the year...

=Year(Parameters!reportdate.Value)

I want the month to be displayed as November, January, July...etc not 11, 1, 7 '

=Month(Parameters!reportdate.Value) gives me 10 which I dont want

and

=MonthName(Parameters!reportdate.Value) gives me an error. I am using SQL 2000.

|||Try the code that I gave above. My output from running the statement

select DATENAME(m, @.CurrentDate) + ' ' + DATENAME(yy, @.CurrentDate)

is:

Column1
-
April 2006
No rows affected.
(1 row(s) returned)

That gives the month name (not number), as you requested...|||Have a look at:
http://msdn2.microsoft.com/en-US/library/ms174395(SQL.90).aspx

It's the documentation for the TSQL DATENAME command.|||

try the following

Switch(Month(Parameters!BeginDate.Value)=01,"January" & Year(Parameters!BeginDate.Value),Month(Parameters!BeginDate.Value)=02,"Feb" & Year( Parameters!BeginDate.Value) )

|||The DATENAME function should also work in SQL Server 2000 - have a look here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_1dph.asp

Also have a look at this article for some further examples:
http://www.sqljunkies.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

Tuesday, February 14, 2012

Breaking up parameters