(BUG?)Some JPEGs not showing correctly in PDF-Export

Hi,

we've some pictures from broken machines, they are taken with a digital camera and should be showed within a report.
But some Pictures don't display correctly:
I want to add this image.
In PreviewMode or if exporting to Tif-Images everything looks fine, but if I export to PDF the Image looks like this (resized, but it also looks so if I don't resize it).

If I open the file in Paint.net and save it again everything is okay.. But its strange for the users that this picture shows up correctly everywhere except the PDF-Export. So they say its a problem of PDF export and not of the image..

Does anybody have a similar issue and a solution for this problem?
It doesn't matter if I retrieve the jpeg from a database or from disk, this problem always occurs.
I tried this with and without SP1-> same problem..

Any help would be appreciated
I found the problem by hex-editing the PDF..
Some picutures ( like the one in the link above) get marked as grayscale though they are RGB!!
If you manually change
/XObject /Subtype /Image /ColorSpace /DeviceGray /BitsPerComponent 8 ....
to
/XObject /Subtype /Image /ColorSpace /DeviceRGB /BitsPerComponent 8 ....
and open the PDF the images are okay!

So, thats the bug, but who can give me a solution?
(Editing the PDF afterwards is no solution ;))
|||I analysed the files, the problem seems to occur if the Huffman table marker (FFC4) Header shows up prior the Start of frame marker (FFC0)!
I don't know if the jpegs aren't "well formed" if huffman table marker comes first but other programs process them correctly..

If I manually move the start of frame marker to some position prior the Huffman table marker the pictures show up correctly (the pdf says /DeviceRGB)..
|||We also have noticed this problem, though I don't know my way around Jpeg files well enough to verify the frame sequencing problem you identified above.

I do not believe that we saw this problem until I applied SQL Server 2005 Service Pack 1 last week.

Do you have the service pack applied?
|||

We are also having the same problem and we do have SP1 installed on SQL 2005. Is there still no fix for this issue ? Please help.

|||I've reported that as Bug, take a look at:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109

MS Comment:
This is a duplicate of https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109. It has been fixed for the upcoming Service Pack 2.

It's a duplicate of itself;) But they seem to fix it..

(BUG?)Some JPEGs not showing correctly in PDF-Export

Hi,

we've some pictures from broken machines, they are taken with a digital camera and should be showed within a report.
But some Pictures don't display correctly:
I want to add this image.
In PreviewMode or if exporting to Tif-Images everything looks fine, but if I export to PDF the Image looks like this (resized, but it also looks so if I don't resize it).

If I open the file in Paint.net and save it again everything is okay.. But its strange for the users that this picture shows up correctly everywhere except the PDF-Export. So they say its a problem of PDF export and not of the image..

Does anybody have a similar issue and a solution for this problem?
It doesn't matter if I retrieve the jpeg from a database or from disk, this problem always occurs.
I tried this with and without SP1-> same problem..

Any help would be appreciatedI found the problem by hex-editing the PDF..
Some picutures ( like the one in the link above) get marked as grayscale though they are RGB!!
If you manually change
/XObject /Subtype /Image /ColorSpace /DeviceGray /BitsPerComponent 8 ....
to
/XObject /Subtype /Image /ColorSpace /DeviceRGB /BitsPerComponent 8 ....
and open the PDF the images are okay!

So, thats the bug, but who can give me a solution?
(Editing the PDF afterwards is no solution ;))|||I analysed the files, the problem seems to occur if the Huffman table marker (FFC4) Header shows up prior the Start of frame marker (FFC0)!
I don't know if the jpegs aren't "well formed" if huffman table marker comes first but other programs process them correctly..

If I manually move the start of frame marker to some position prior the Huffman table marker the pictures show up correctly (the pdf says /DeviceRGB)..|||We also have noticed this problem, though I don't know my way around Jpeg files well enough to verify the frame sequencing problem you identified above.

I do not believe that we saw this problem until I applied SQL Server 2005 Service Pack 1 last week.

Do you have the service pack applied?|||

We are also having the same problem and we do have SP1 installed on SQL 2005. Is there still no fix for this issue ? Please help.

|||I've reported that as Bug, take a look at:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109

MS Comment:
This is a duplicate of

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109.

It has been fixed for the upcoming Service Pack 2.

It's a duplicate of itself;) But they seem to fix it..

(BUG?)Some JPEGs not showing correctly in PDF-Export

Hi,

we've some pictures from broken machines, they are taken with a digital camera and should be showed within a report.
But some Pictures don't display correctly:
I want to add this image.
In PreviewMode or if exporting to Tif-Images everything looks fine, but if I export to PDF the Image looks like this (resized, but it also looks so if I don't resize it).

If I open the file in Paint.net and save it again everything is okay.. But its strange for the users that this picture shows up correctly everywhere except the PDF-Export. So they say its a problem of PDF export and not of the image..

Does anybody have a similar issue and a solution for this problem?
It doesn't matter if I retrieve the jpeg from a database or from disk, this problem always occurs.
I tried this with and without SP1-> same problem..

Any help would be appreciatedI found the problem by hex-editing the PDF..
Some picutures ( like the one in the link above) get marked as grayscale though they are RGB!!
If you manually change
/XObject /Subtype /Image /ColorSpace /DeviceGray /BitsPerComponent 8 ....
to
/XObject /Subtype /Image /ColorSpace /DeviceRGB /BitsPerComponent 8 ....
and open the PDF the images are okay!

So, thats the bug, but who can give me a solution?
(Editing the PDF afterwards is no solution ;))|||I analysed the files, the problem seems to occur if the Huffman table marker (FFC4) Header shows up prior the Start of frame marker (FFC0)!
I don't know if the jpegs aren't "well formed" if huffman table marker comes first but other programs process them correctly..

If I manually move the start of frame marker to some position prior the Huffman table marker the pictures show up correctly (the pdf says /DeviceRGB)..|||We also have noticed this problem, though I don't know my way around Jpeg files well enough to verify the frame sequencing problem you identified above.

I do not believe that we saw this problem until I applied SQL Server 2005 Service Pack 1 last week.

Do you have the service pack applied?|||

We are also having the same problem and we do have SP1 installed on SQL 2005. Is there still no fix for this issue ? Please help.

|||I've reported that as Bug, take a look at:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109

MS Comment:
This is a duplicate of

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109.

It has been fixed for the upcoming Service Pack 2.

It's a duplicate of itself;) But they seem to fix it..sql

% on Pie Charts

Hello all,
I am currently showing the value (hours) for each slice of the pie chart but
would like to also include the percentage of that pie slice. How would I do
this?Hi Anthonysjo,
SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
then Format Code: P.
Or
Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
"Percent")
I hope this is what you are looking for.
Kerrie
anthonysjo wrote:
>Hello all,
>I am currently showing the value (hours) for each slice of the pie chart but
>would like to also include the percentage of that pie slice. How would I do
>this?
Message posted via http://www.sqlmonster.com|||Kerrie,
thanks for the help, but I may need a little more explaination....would I
put this formula in the Chart properties, on the data tab, values, edit, and
add the code to the Value field? Also is Dataset1 the name of the datasource
or the name of the output field in the example you gave below?
Thanks for the help!!
Anthony
"Kerrie S via SQLMonster.com" wrote:
> Hi Anthonysjo,
> SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
> then Format Code: P.
> Or
> Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
> "Percent")
> I hope this is what you are looking for.
> Kerrie
> anthonysjo wrote:
> >Hello all,
> >
> >I am currently showing the value (hours) for each slice of the pie chart but
> >would like to also include the percentage of that pie slice. How would I do
> >this?
>
> --
> Message posted via http://www.sqlmonster.com
>|||That expression would go under data tab -> edit values -> point labels
tab -> data label expression
"Dataset1" is an explicit scope for the Sum aggregation function and has to
be identical to the data set name the chart is based on.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:ABFE935A-7E47-4E31-BD69-578D29F1F29C@.microsoft.com...
> Kerrie,
> thanks for the help, but I may need a little more explaination....would I
> put this formula in the Chart properties, on the data tab, values, edit,
> and
> add the code to the Value field? Also is Dataset1 the name of the
> datasource
> or the name of the output field in the example you gave below?
> Thanks for the help!!
> Anthony
> "Kerrie S via SQLMonster.com" wrote:
>> Hi Anthonysjo,
>> SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
>> then Format Code: P.
>> Or
>> Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
>> "Percent")
>> I hope this is what you are looking for.
>> Kerrie
>> anthonysjo wrote:
>> >Hello all,
>> >
>> >I am currently showing the value (hours) for each slice of the pie chart
>> >but
>> >would like to also include the percentage of that pie slice. How would
>> >I do
>> >this?
>>
>> --
>> Message posted via http://www.sqlmonster.com|||I put in the following.....
=SUM( Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, " YRT_Proj_Cat")
Then I ran the report and get the following error:
The expression for the chart â'chart1â' has a scope parameter that is not
valid for an aggregate function. The scope parameter must be set to a string
constant that is equal to either the name of a containing group, the name of
a containing data region, or the name of a data set.
Build complete
What am I missing...Reg_Hours is the field name and YRT_Proj_Cat is the
dataset?
Sorry if I am a little slow...I am new to SRS!
Thanks for the help thus far!!!
"Robert Bruckner [MSFT]" wrote:
> That expression would go under data tab -> edit values -> point labels
> tab -> data label expression
> "Dataset1" is an explicit scope for the Sum aggregation function and has to
> be identical to the data set name the chart is based on.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:ABFE935A-7E47-4E31-BD69-578D29F1F29C@.microsoft.com...
> > Kerrie,
> >
> > thanks for the help, but I may need a little more explaination....would I
> > put this formula in the Chart properties, on the data tab, values, edit,
> > and
> > add the code to the Value field? Also is Dataset1 the name of the
> > datasource
> > or the name of the output field in the example you gave below?
> >
> > Thanks for the help!!
> >
> > Anthony
> > "Kerrie S via SQLMonster.com" wrote:
> >
> >> Hi Anthonysjo,
> >> SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
> >> then Format Code: P.
> >> Or
> >> Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
> >> "Percent")
> >> I hope this is what you are looking for.
> >> Kerrie
> >>
> >> anthonysjo wrote:
> >> >Hello all,
> >> >
> >> >I am currently showing the value (hours) for each slice of the pie chart
> >> >but
> >> >would like to also include the percentage of that pie slice. How would
> >> >I do
> >> >this?
> >>
> >>
> >> --
> >> Message posted via http://www.sqlmonster.com
> >>
>
>|||Scope names are case-sensitive and they must exactly match the data set
name. The scope name in the expressions starts with a space which is most
likely the reason for the error message. Try it without the leading space in
the scope name:
=SUM( Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "YRT_Proj_Cat")
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:AE6D597D-D4CF-4EEB-9EFB-A223A8734D27@.microsoft.com...
>I put in the following.....
> =SUM( Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "
> YRT_Proj_Cat")
> Then I ran the report and get the following error:
> The expression for the chart 'chart1' has a scope parameter that is not
> valid for an aggregate function. The scope parameter must be set to a
> string
> constant that is equal to either the name of a containing group, the name
> of
> a containing data region, or the name of a data set.
> Build complete
> What am I missing...Reg_Hours is the field name and YRT_Proj_Cat is the
> dataset?
> Sorry if I am a little slow...I am new to SRS!
> Thanks for the help thus far!!!
> "Robert Bruckner [MSFT]" wrote:
>> That expression would go under data tab -> edit values -> point labels
>> tab -> data label expression
>> "Dataset1" is an explicit scope for the Sum aggregation function and has
>> to
>> be identical to the data set name the chart is based on.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
>> news:ABFE935A-7E47-4E31-BD69-578D29F1F29C@.microsoft.com...
>> > Kerrie,
>> >
>> > thanks for the help, but I may need a little more
>> > explaination....would I
>> > put this formula in the Chart properties, on the data tab, values,
>> > edit,
>> > and
>> > add the code to the Value field? Also is Dataset1 the name of the
>> > datasource
>> > or the name of the output field in the example you gave below?
>> >
>> > Thanks for the help!!
>> >
>> > Anthony
>> > "Kerrie S via SQLMonster.com" wrote:
>> >
>> >> Hi Anthonysjo,
>> >> SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
>> >> then Format Code: P.
>> >> Or
>> >> Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
>> >> "Percent")
>> >> I hope this is what you are looking for.
>> >> Kerrie
>> >>
>> >> anthonysjo wrote:
>> >> >Hello all,
>> >> >
>> >> >I am currently showing the value (hours) for each slice of the pie
>> >> >chart
>> >> >but
>> >> >would like to also include the percentage of that pie slice. How
>> >> >would
>> >> >I do
>> >> >this?
>> >>
>> >>
>> >> --
>> >> Message posted via http://www.sqlmonster.com
>> >>
>>|||Sweet!! That was it...the space was causing the problem. Thanks for the
help!!!
"Robert Bruckner [MSFT]" wrote:
> Scope names are case-sensitive and they must exactly match the data set
> name. The scope name in the expressions starts with a space which is most
> likely the reason for the error message. Try it without the leading space in
> the scope name:
> =SUM( Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "YRT_Proj_Cat")
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:AE6D597D-D4CF-4EEB-9EFB-A223A8734D27@.microsoft.com...
> >I put in the following.....
> >
> > =SUM( Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "
> > YRT_Proj_Cat")
> >
> > Then I ran the report and get the following error:
> >
> > The expression for the chart 'chart1' has a scope parameter that is not
> > valid for an aggregate function. The scope parameter must be set to a
> > string
> > constant that is equal to either the name of a containing group, the name
> > of
> > a containing data region, or the name of a data set.
> > Build complete
> >
> > What am I missing...Reg_Hours is the field name and YRT_Proj_Cat is the
> > dataset?
> >
> > Sorry if I am a little slow...I am new to SRS!
> >
> > Thanks for the help thus far!!!
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> That expression would go under data tab -> edit values -> point labels
> >> tab -> data label expression
> >>
> >> "Dataset1" is an explicit scope for the Sum aggregation function and has
> >> to
> >> be identical to the data set name the chart is based on.
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> >> news:ABFE935A-7E47-4E31-BD69-578D29F1F29C@.microsoft.com...
> >> > Kerrie,
> >> >
> >> > thanks for the help, but I may need a little more
> >> > explaination....would I
> >> > put this formula in the Chart properties, on the data tab, values,
> >> > edit,
> >> > and
> >> > add the code to the Value field? Also is Dataset1 the name of the
> >> > datasource
> >> > or the name of the output field in the example you gave below?
> >> >
> >> > Thanks for the help!!
> >> >
> >> > Anthony
> >> > "Kerrie S via SQLMonster.com" wrote:
> >> >
> >> >> Hi Anthonysjo,
> >> >> SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1")
> >> >> then Format Code: P.
> >> >> Or
> >> >> Format(SUM( Fields!Hours.Value )/ Sum(Fields!Hours.Value, "DataSet1"),
> >> >> "Percent")
> >> >> I hope this is what you are looking for.
> >> >> Kerrie
> >> >>
> >> >> anthonysjo wrote:
> >> >> >Hello all,
> >> >> >
> >> >> >I am currently showing the value (hours) for each slice of the pie
> >> >> >chart
> >> >> >but
> >> >> >would like to also include the percentage of that pie slice. How
> >> >> >would
> >> >> >I do
> >> >> >this?
> >> >>
> >> >>
> >> >> --
> >> >> Message posted via http://www.sqlmonster.com
> >> >>
> >>
> >>
> >>
>
>