q: this strange problem

Hello,
I have different sub-reports in my main report. I have rectangles around my
sub-reporta to be able to put page breaks te the start of rectangle. I need
to make some sub-report visible and invisible based on a parameter. However I
am using =iif(Parameters!MyPar.Value = "true",false, true) in the visibility
property and this creates problem in the page break of the visible reports.
Any idea?If the sub-report becomes not visible then the page break is ignored.
To fix this, use a seperate rectangle control (make it tiny and place
it below the subreport on the master report) and set the page break
property on this new rectangle control.
HTH-
Matt A

Q: this strange problem

I am having this strange problem, when I run my query in Query Analyzer, I
see the result is ok. But my report based on the same query shows first filed
repeats itself instead of showing right values. What might the problem be?Is this in development? In development the report data is cached (look for a
file with an extension called .data). If you change the paramter it will
requery. If no parameter then you can manually delete this file if you care.
The designer does this so when previewing you are not waiting for the query
to run.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:9E917150-64CD-43FA-8E80-84E716FC6AFE@.microsoft.com...
>I am having this strange problem, when I run my query in Query Analyzer, I
> see the result is ok. But my report based on the same query shows first
> filed
> repeats itself instead of showing right values. What might the problem be?