Report does not display the same as in the Preview window in Visual Studio

After formatting the report and making it look like I want too in the
Preview window of Visual Studio. I deploy the report to the web server
and when I open it - the web rendering (formatting) does not duplicate
what I see in the Preview window. It looks like it's adding extra rows
between the objects and is not following the vertical alignment that
was used in Visual Studio.
Does anyone have ideas on what could be causing this?
Thanks..I do. Verify if there are textboxes overlaping each other. In preview
windows this issue do not cause problem, but at render time, it does.
[]s
Renato
"Manuel" <mxgamez@.kelsey-seybold.com> escreveu na mensagem
news:ce53542a.0408260535.724891fd@.posting.google.com...
> After formatting the report and making it look like I want too in the
> Preview window of Visual Studio. I deploy the report to the web server
> and when I open it - the web rendering (formatting) does not duplicate
> what I see in the Preview window. It looks like it's adding extra rows
> between the objects and is not following the vertical alignment that
> was used in Visual Studio.
> Does anyone have ideas on what could be causing this?
> Thanks..|||Thanks... That worked.
"Renato Aloi" <aloi@.jew.com.br> wrote in message news:<OS$E9e3iEHA.2760@.TK2MSFTNGP15.phx.gbl>...
> I do. Verify if there are textboxes overlaping each other. In preview
> windows this issue do not cause problem, but at render time, it does.
> []s
> Renato
> "Manuel" <mxgamez@.kelsey-seybold.com> escreveu na mensagem
> news:ce53542a.0408260535.724891fd@.posting.google.com...
> > After formatting the report and making it look like I want too in the
> > Preview window of Visual Studio. I deploy the report to the web server
> > and when I open it - the web rendering (formatting) does not duplicate
> > what I see in the Preview window. It looks like it's adding extra rows
> > between the objects and is not following the vertical alignment that
> > was used in Visual Studio.
> >
> > Does anyone have ideas on what could be causing this?
> >
> > Thanks..

Report Designer: preview goes into infinite loop

Hello,
Situation:
- a report with cascading parameters [A], [B], [C]
- first parameter [A] loaded via non-queried values
- second parameter [B] loaded via stored procedure, taking [A] and a
constant as input (via dataset dsB)
- third parameter [C] loaded via the same stored procedure, taking [A] and
[B] as input (via dataset dsC)
When I preview this report:
- initial view ok
- modify [A] -> [B] changes accordingly
- modify [B] -> the designer starts flickering and goes into a never ending
loop.
The deployed report works just fine and as expected.
Bug ? Any work arounds ?
Thanks for any input!
TomSounds like a bug. There is another bug I have found with the preview tab
and cascading parameters. It only cascades once. I.e. if you go back a
second time and change A it does not change B. Again, deploy works fine. I
have access to the the internal bug reporting tool and when I report the
previous but I'll do this one too. I am not aware of any workaround. At
least it works in deployed mode.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tom VdP" <unick@.hot_mail_.c-o-m> wrote in message
news:1FBF14D5-28E3-4B76-93BF-47F292BC33FE@.microsoft.com...
> Hello,
> Situation:
> - a report with cascading parameters [A], [B], [C]
> - first parameter [A] loaded via non-queried values
> - second parameter [B] loaded via stored procedure, taking [A] and a
> constant as input (via dataset dsB)
> - third parameter [C] loaded via the same stored procedure, taking [A] and
> [B] as input (via dataset dsC)
> When I preview this report:
> - initial view ok
> - modify [A] -> [B] changes accordingly
> - modify [B] -> the designer starts flickering and goes into a never
ending
> loop.
> The deployed report works just fine and as expected.
> Bug ? Any work arounds ?
> Thanks for any input!
> Tom|||Thanks for reporting it.
It is annoying as the first parameter in our reports is the choice of
language. Depending on the selection the contents of the other dropdown
boxes is changed.
So we have cascading parameters in every report.
But we can use the deployed reports luckily.
Regards,
Tom
"Bruce L-C [MVP]" wrote:
> Sounds like a bug. There is another bug I have found with the preview tab
> and cascading parameters. It only cascades once. I.e. if you go back a
> second time and change A it does not change B. Again, deploy works fine. I
> have access to the the internal bug reporting tool and when I report the
> previous but I'll do this one too. I am not aware of any workaround. At
> least it works in deployed mode.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Tom VdP" <unick@.hot_mail_.c-o-m> wrote in message
> news:1FBF14D5-28E3-4B76-93BF-47F292BC33FE@.microsoft.com...
> >
> > Hello,
> >
> > Situation:
> > - a report with cascading parameters [A], [B], [C]
> > - first parameter [A] loaded via non-queried values
> > - second parameter [B] loaded via stored procedure, taking [A] and a
> > constant as input (via dataset dsB)
> > - third parameter [C] loaded via the same stored procedure, taking [A] and
> > [B] as input (via dataset dsC)
> >
> > When I preview this report:
> > - initial view ok
> > - modify [A] -> [B] changes accordingly
> > - modify [B] -> the designer starts flickering and goes into a never
> ending
> > loop.
> >
> > The deployed report works just fine and as expected.
> >
> > Bug ? Any work arounds ?
> >
> > Thanks for any input!
> > Tom
>
>|||I am not using cascading parameters but I have experieced a similiar problems
with the Report Designer preview (loops) and I sometimes get a Processing
Error 'Specified Cast in not Valid' , If I remove the Page Header OR Footer I
do not get the error, OR if there is labels only (no ReportItems! or Globals!
in the header/footer) it works.
There are no problems when the report is deployed.
"Tom VdP" wrote:
> Thanks for reporting it.
> It is annoying as the first parameter in our reports is the choice of
> language. Depending on the selection the contents of the other dropdown
> boxes is changed.
> So we have cascading parameters in every report.
> But we can use the deployed reports luckily.
> Regards,
> Tom
>
> "Bruce L-C [MVP]" wrote:
> > Sounds like a bug. There is another bug I have found with the preview tab
> > and cascading parameters. It only cascades once. I.e. if you go back a
> > second time and change A it does not change B. Again, deploy works fine. I
> > have access to the the internal bug reporting tool and when I report the
> > previous but I'll do this one too. I am not aware of any workaround. At
> > least it works in deployed mode.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Tom VdP" <unick@.hot_mail_.c-o-m> wrote in message
> > news:1FBF14D5-28E3-4B76-93BF-47F292BC33FE@.microsoft.com...
> > >
> > > Hello,
> > >
> > > Situation:
> > > - a report with cascading parameters [A], [B], [C]
> > > - first parameter [A] loaded via non-queried values
> > > - second parameter [B] loaded via stored procedure, taking [A] and a
> > > constant as input (via dataset dsB)
> > > - third parameter [C] loaded via the same stored procedure, taking [A] and
> > > [B] as input (via dataset dsC)
> > >
> > > When I preview this report:
> > > - initial view ok
> > > - modify [A] -> [B] changes accordingly
> > > - modify [B] -> the designer starts flickering and goes into a never
> > ending
> > > loop.
> > >
> > > The deployed report works just fine and as expected.
> > >
> > > Bug ? Any work arounds ?
> > >
> > > Thanks for any input!
> > > Tom
> >
> >
> >

Report Continually Refreshing

Hi All,

I had an interesting problem come up today. I have a report that when you preview on vs or click view report on the report server, the report continually refreshes itself. I cannot see that I have written anything different in this report than any other report.

I saw one other append here on a continually refreshing report but that was linked to a document map and this report has not document map.

Has anyone seen this problem of a continually refreshing report?

It's not a big deal as I figure I will just have to write it from scratch again, but I am interested to see if I can stop it before I re-write it.

Thanks in Advance

Peter

Peter, there is option in Report Properties that allows you to set a refresh rate. Click in the body of your report layout and then select Report and then Report Properties from the toolbar. At the bottom of the General tab you should see the option to check AutoRefresh and a number of seconds. Unselect this and the report should stop refreshing.

|||

Hi Cuck,

thanks very much for that...I have no idea how the refresh rate got set to 1 second but that was the problem.

I read about that option when I first started with Report Services but forgot it was there.

Thanks Again.

Peter

Report Continually Refreshing

Hi All,

I had an interesting problem come up today. I have a report that when you preview on vs or click view report on the report server, the report continually refreshes itself. I cannot see that I have written anything different in this report than any other report.

I saw one other append here on a continually refreshing report but that was linked to a document map and this report has not document map.

Has anyone seen this problem of a continually refreshing report?

It's not a big deal as I figure I will just have to write it from scratch again, but I am interested to see if I can stop it before I re-write it.

Thanks in Advance

Peter

Peter, there is option in Report Properties that allows you to set a refresh rate. Click in the body of your report layout and then select Report and then Report Properties from the toolbar. At the bottom of the General tab you should see the option to check AutoRefresh and a number of seconds. Unselect this and the report should stop refreshing.

|||

Hi Cuck,

thanks very much for that...I have no idea how the refresh rate got set to 1 second but that was the problem.

I read about that option when I first started with Report Services but forgot it was there.

Thanks Again.

Peter

sql

Report appearance issues

I have 2 issues wih the appearance of my report both in the preview tab and when I deploy.

1. My report contains a subreport and the subreport appears indented from the left edge of the main report. How can I stop this? I won't the subreport to be aligned with the main report.
2. The last column of my report is stretched to the edge of the page even though I have all my cells set to CanGrow = false. How can I stop this?

Any help is appreciated.
I solved this one myself. The subreport's body was wider than the main report's body and as I have the table centred on both reports the subreport appeared indented. As soon as I made both report's body width the same the subreport aligned with the main report correctly. I also set every cell in the table in both reports to CanGrow = false and that stopped the last column stretching to the edge of the page.

Report always displays 2 pages

Hi, I have a SQL Reporting service on which I have a footer with the number of page, something like "page 1 of 1". THe thing is, if I preview the report, it displays the nr of pages correctly, however, when I export to PDF; it alwas displays 2 pages, on the 2nd page only displays the footer "page 1 of 2" even if the first page is small and fits that page only. I've tried to reorganize the controls on the report and fit the footer to display only one page, however, no result.. any guess?Thanks a lot!Check the page margins settings in the report's properties.|||Problem solved. I've resized the report width to a less value than the value that I was using and is working!Thanks for the tip!

Report - preview looks fine, but exporting to PDF splits controls!!!Help!!

Hi, I've build correctly my report using the most efficient tools. I've made the preview and it worked just fine!However, when I export to PDF, it splits the report heigth into two pages, having the columns of my table and other controls splitted.

I'm already using the font size as 7 or 8 (depends), really small, I've tried hard to reduce their size, however the result remains the same...no resolution!!

Is there anybody who may have or had this situation?Any guests or help?Thanks a lot!

is your report in landscape or potrait layout?

|||I've tried both, however the problem remains. I guess I'll try to change a little bit the report to see any change...Thanks anyway!|||

hi

I had a similar situation when i exported my report to PDF and it inserted blank spaces and spilt the report. My solution was not to change the font but the margin size of the report. Try changing the size of the margins and see if it works...

hope this helps.

|||

Hi,

It may not be just the margin size but more combination of margin and paper size. Drag the back ground paper smaller untill it fits within the size of you paper less the margin.

You can also try printing the report. Does this give the same result as export to pdf. Putting a borad arround the page can help see where the edge is.

hope this helps

dkldev

|||Reorganizing the controls solved out the problem. The issu now is, that I have a footer on which ir presents the current and total nr of pages, such as "page 1 of 2", and the report appears always with 2 pages, even if the report only has one page. The preview shows one page, and the footer shows "page 1 of 1", however, if I export to PDF appears "1 of 2! and the second page only has the footer saying "page 2 of 2"...any guess?Thanks a lot for helping!|||

http://blogs.msdn.com/bwelcker/archive/2005/08/19/Alien-Lanes-_2800_Logical-and-Physical-Pagination-Rules_2900_.aspx

hope this helps

Report - preview looks fine, but exporting to PDF splits controls

Hi, I've buildcorrectly my report using the most efficient tools. I've made thepreview and it worked just fine!However, when I export to PDF, itsplits the report heigth into two pages, having the columns of my tableand other controls splitted.

I'm already using the font sizeas 7 or 8 (depends), really small, I've tried hard to reduce theirsize, however the result remains the same...no resolution!!

Is there anybody who may have or had this situation?Any guests or help?Thanks a lot!

I have one this to say to you.Page Size.

The number of issues with controls splitting, blank pages, missing images and all that really annoying stuff is down to the page size.

Check your preview based on the print preview (RS2000) or the print layout (RS2005). But even that lies sometimes.

Just add up your widths + margins don't go over the page width cause that'l cause a new page or a split.|||Problem solved. Re arranged my controls, they were violating the margins of the page...Another issue is that I've put the number of the page on the footer and it creates a second page on which it only appears the number of the page...any guess?!?Thanks a lot!