Reporting Services Render issues in IE

Hi

We are having an issue with reporting services when it is viewed in IE.

We can design the report in visual studio and it looks fine, however when we upload the report to reporting services it displays the report incorrectly (shown below)

http://static.flickr.com/103/298669551_7395fc946d.jpg

When it is print previewed it looks like this (which is the correct layout)

http://static.flickr.com/104/298669558_cfd56ffd0e.jpg

Any advice would be most appreciated!

Thanks Ross

Ross,

You're running into the differences between the renderers. Designer preview and print preview use a GDI-based renderer, while Report Manager uses an HTML-based renderer. There are some pretty significant differences in the way borders and other elements are handled.

Best advice I can give you is to decide which renderer is most important for each report, and make sure you get what you want for that renderer.

It may be possible to get a consistent result from both types of renderers with the use of rectangles to "freeze" report items.

|||

Mike

I posted this yesterday...

"We have a SQL Server 2005 database which holds all the companies scanned documents (in image fields). I have developed a report which allows the user to search for a contract and all relevant scanned documents are returned.

When I preview the report with Visual Studio Report Designer...SOME of the images are not displayed, I get the little red cross icon in the top left corner.

When viewed using Report Manager with a browser... the report displays ALL images... however, when I click on the print button and then the print preview button in Report Manager, some of the images do not appear (the same images that don't appear in the Report Designer preview).

Can anyone tell me why I can see all the images through Report Manager and my Browser (IE7), but only some of the images when in Report Designer preview or Print Preview? "

After reading your post above, I started thinking it could be a rendering issue. Have you got any more information?

Reporting Services Render issues in IE

Hi

We are having an issue with reporting services when it is viewed in IE.

We can design the report in visual studio and it looks fine, however when we upload the report to reporting services it displays the report incorrectly (shown below)

http://static.flickr.com/103/298669551_7395fc946d.jpg

When it is print previewed it looks like this (which is the correct layout)

http://static.flickr.com/104/298669558_cfd56ffd0e.jpg

Any advice would be most appreciated!

Thanks Ross

Ross,

You're running into the differences between the renderers. Designer preview and print preview use a GDI-based renderer, while Report Manager uses an HTML-based renderer. There are some pretty significant differences in the way borders and other elements are handled.

Best advice I can give you is to decide which renderer is most important for each report, and make sure you get what you want for that renderer.

It may be possible to get a consistent result from both types of renderers with the use of rectangles to "freeze" report items.

|||

Mike

I posted this yesterday...

"We have a SQL Server 2005 database which holds all the companies scanned documents (in image fields). I have developed a report which allows the user to search for a contract and all relevant scanned documents are returned.

When I preview the report with Visual Studio Report Designer...SOME of the images are not displayed, I get the little red cross icon in the top left corner.

When viewed using Report Manager with a browser... the report displays ALL images... however, when I click on the print button and then the print preview button in Report Manager, some of the images do not appear (the same images that don't appear in the Report Designer preview).

Can anyone tell me why I can see all the images through Report Manager and my Browser (IE7), but only some of the images when in Report Designer preview or Print Preview? "

After reading your post above, I started thinking it could be a rendering issue. Have you got any more information?

sql

Reporting Services Render issues in IE

Hi
We are having an issue with reporting services when it is viewed in IE.
We can design the report in visual studio and it looks fine, however
when we upload the report to reporting services it displays the report
incorrectly (shown below)
http://static.flickr.com/103/298669551_7395fc946d.jpg
When it is print previewed it looks like this (which is the correct
layout)
http://static.flickr.com/104/298669558_cfd56ffd0e.jpg
Any advice would be most appreciated!
Thanks RossI'd like to know more about this too.
I had a report with a chart and an image on it. The image was to the
right of the chart. When viewing the report it looked fine. However,
when it was print previewed, the image showed up right on top of the
chart. Made no sense.
However, i fixed this by making sure my report elements didn't overlap.
Is this happening in your case? Reporting services doesn't like reports
where the elements on it are either touching or overlapping. Try
spacing out some stuff.
-Kevin
ross.dargan@.gmail.com wrote:
> Hi
> We are having an issue with reporting services when it is viewed in IE.
> We can design the report in visual studio and it looks fine, however
> when we upload the report to reporting services it displays the report
> incorrectly (shown below)
> http://static.flickr.com/103/298669551_7395fc946d.jpg
> When it is print previewed it looks like this (which is the correct
> layout)
> http://static.flickr.com/104/298669558_cfd56ffd0e.jpg
> Any advice would be most appreciated!
> Thanks Ross

Reporting Services problem

Hi all,
I am experiencing a problem with Reporting Services. Once i render a
report on button click, using a ReportViewer the report loads fine.
However, after that the actual website is not able to serve any other
request. Normal hyperlinks work but button clicks postback to the page
requesting the operation.
So for example if i have a page A requesting for a report to be loaded,
the report loads fine the first time. Every subsequent request just
does a postback to Page A.
Any ideas? I hope i am clear in what the problem is.
Regards,
VenkatHow are you accessing the reports? Are you populating a frame with a URL?
Are you simply linking to the reports?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"vk" <venkatak@.gmail.com> wrote in message
news:1110110041.527411.26000@.f14g2000cwb.googlegroups.com...
> Hi all,
> I am experiencing a problem with Reporting Services. Once i render a
> report on button click, using a ReportViewer the report loads fine.
> However, after that the actual website is not able to serve any other
> request. Normal hyperlinks work but button clicks postback to the page
> requesting the operation.
> So for example if i have a page A requesting for a report to be loaded,
> the report loads fine the first time. Every subsequent request just
> does a postback to Page A.
> Any ideas? I hope i am clear in what the problem is.
> Regards,
> Venkat
>|||hi
Can any one tell me how to get a hyperlink for sub reports in ssrs 2005.
Mail me please to karvallamp@.gmail.co
From http://www.google.com/custom?cx=015258194770007199679:e2pdvdvh7_8&q=linking+operation+in+ssrs+2005&cof=GFNT:#666666;LH:55;CX:DevelopmentNow;DIV:#cccccc;FORID:10;L:http://www.google.com/coop/images/google_custom_search_sm.gif;LP:1;AH:left&ad=w9&num=10&rurl=http://www.developmentnow.com/search.aspx?cx=015258194770007199679%3Ae2pdvdvh7_8&q=linking+operation+in+ssrs+2005&cof=FORID%3A10&adkw=AELymgWd0asU4YN8M6nf8QYxkdBAnJRfMILx4jyc_yMuo5rbi3xb11lnSvDjYZ3lklV794YbgTVgpsE-FVgmSExpSufDmun2DyMWvB37Q4XnscQnC61mOPGWYIBdbDrObR3K7DGEOGJaGq8I4UNP6z0CJLN_Wzao17XXLI7m2ktFp1GyeYtLS9dbEEZHjJbmk0sI5flBS6dw&client=pub-356848142164436
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Reporting services parameter([rsFieldReference] The Value expression for the...)

@.StartDate is a report parameter and CustomerNo is the field I want to render on the report,I want to combine the sql ,but it display the error message below when I preview the report.If I query in the design form and input the value of the parameter ,it run correctly .

Data sql:

declare @.sql nvarchar(4000)
declare @.sqlWhere nvarchar(4000)

set @.sql='select CustomerNo from table1 '
set @.sqlWhere=''

if @.StartDate<>''
begin
set @.sqlWhere =@.sqlWhere + ' StartDate=''' +@.StartDate + ''''
end

if ltrim(rtrim(@.sqlWhere))<>''
begin
set @.sqlWhere =' where ' + @.sqlWhere
end
set @.sql=@.sql+@.sqlWhere

exec sp_executeSQL @.sql

Error message:

[rsFieldReference] The Value expression for the textbox ‘CustomerNo’ refers to the field ‘CustomerNo’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

I'm a beginner .Help me.

|||

Please give me a answer.

|||

I wrote a procedure and the problem is resolved.