Incorrect Positioning?

Hi,

I have created a couple of reports with a header that contains an embedded image and a textbox just to the right of the image, vertically aligned. So far so good but when i deploy the report it doesn't show exactly as in the preview...
Instead the textbox seems to goto another column? Yes it seems that some how a new column is created and the textbox is the only thing to be in it...

Anyone experiencing this? What can be causing this?

Best Regards,

Luis Simoes

It sounds like the image and the textbox overlap. This is only supported in image-based rendering (e.g. Preview, PDF). We currently don't support overlapping items in HTML (when viewed e.g. through report viewer in report manager). This is why one of the overlapping items will get pushed to the right/bottom in the generated output.

-- Robert

|||

No, they are not overlapped. They are side by side!

What can it be? That's really weird behavior.. only the text box on the right side of the embedded image get's to a new blank column...

This is the layout of the report:

Image here	Textbox here
Rest of the report

|||I have the same problem. The funniest thing is it depends of the image if textbox is moved or not. When I show the bigger image (property set to fit) textbox is ok side by side but when the image is smaller then the textbox is moved to the next page. Any sollution in this case?|||Got it! I inserted both image and textbox to the header-section and now it works. Strange...sql

Incorrect Positioning?

Hi,

I have created a couple of reports with a header that contains an embedded image and a textbox just to the right of the image, vertically aligned. So far so good but when i deploy the report it doesn't show exactly as in the preview...
Instead the textbox seems to goto another column? Yes it seems that some how a new column is created and the textbox is the only thing to be in it...

Anyone experiencing this? What can be causing this?

Best Regards,

Luis Simoes

It sounds like the image and the textbox overlap. This is only supported in image-based rendering (e.g. Preview, PDF). We currently don't support overlapping items in HTML (when viewed e.g. through report viewer in report manager). This is why one of the overlapping items will get pushed to the right/bottom in the generated output.

-- Robert

|||

No, they are not overlapped. They are side by side!

What can it be? That's really weird behavior.. only the text box on the right side of the embedded image get's to a new blank column...

This is the layout of the report:

Image here	Textbox here
Rest of the report

|||I have the same problem. The funniest thing is it depends of the image if textbox is moved or not. When I show the bigger image (property set to fit) textbox is ok side by side but when the image is smaller then the textbox is moved to the next page. Any sollution in this case?|||Got it! I inserted both image and textbox to the header-section and now it works. Strange...

Include User's Parameters in Report Header?

Hi, I'm getting stuck on what is probably a very simple/common task: Adding a textbox that displays the parameters that a user has selected for the current report.

For example, if the user chooses a @.startdate and @.enddate using date-pickers, a textbox in the header will display/print those parameters:

="Report by Department from " + @.startdate+ " to " + @.enddate

Seems simple, but I keep getting errors:

"Return statement in a Function, Get or Operator must return a value".

Can anyone help out with the proper syntax for repeating a user's parameters in the header or body of a report?

Thanks!

try

="Report by Department from " & Parameters!startdate.value " to " & Parameters!enddate.value

you can also right click at your textbox in the header and choose Expression to edit expression..

in there , choose Parameters in the left pane and double click the needed parameters in the right pane...

the expression will show at the top pane...

HTH

|||Ah, of course - Thankl you!|||What about something more general like looping through the parameters and writing them out by name and value? Any ideas?|||

do you mean multivalue parameters ?

if it is, u can try =Join(Parameters!status.label, ",")

.label for name; .value for value

include the report date

Best case, I include the report date in the report header. Worst case, in
the subject line of the subscription email. I'm using SQL/RS v2000, VS 2003,
anybody know how I can do this? nothing crazy, just like this:
ReportName xx/xx/xxxx
-- LynnI tried to add a text box into the header, just filling it w/this expression:
select LEFT(Dateadd(mm,-0,getdate()),11)
it fails indicating
'the value expression for the textbox 'textbox7' contains and error:
[BC30201] Expression expected.'
please advise
-- Lynn
"Lynn" wrote:
> Best case, I include the report date in the report header. Worst case, in
> the subject line of the subscription email. I'm using SQL/RS v2000, VS 2003,
> anybody know how I can do this? nothing crazy, just like this:
> ReportName xx/xx/xxxx
> -- Lynn|||Please disregard, I got it. I included a text box with this as the
expression, everything is fine now, thanks anyway:
=Format(today()," dd MMM yy" )
-- Lynn
"Lynn" wrote:
> I tried to add a text box into the header, just filling it w/this expression:
> select LEFT(Dateadd(mm,-0,getdate()),11)
> it fails indicating
> 'the value expression for the textbox 'textbox7' contains and error:
> [BC30201] Expression expected.'
> please advise
> -- Lynn
>
> "Lynn" wrote:
> > Best case, I include the report date in the report header. Worst case, in
> > the subject line of the subscription email. I'm using SQL/RS v2000, VS 2003,
> > anybody know how I can do this? nothing crazy, just like this:
> >
> > ReportName xx/xx/xxxx
> >
> > -- Lynn|||Just an FYI, you can use expression builder, look at the global variables.
One of those has what you want.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lynn" <Lynn@.discussions.microsoft.com> wrote in message
news:DA80718F-E475-4891-93A5-EAEB1CB3D2D7@.microsoft.com...
> Best case, I include the report date in the report header. Worst case, in
> the subject line of the subscription email. I'm using SQL/RS v2000, VS
> 2003,
> anybody know how I can do this? nothing crazy, just like this:
> ReportName xx/xx/xxxx
> -- Lynn|||Will do, Bruce, thank you. I will check it out.
-- Lynn
oh, oh, just a slightly related question -- i've created my browser role and
i'm trying to send out this : http://webserver/reports
such that certain people can have direct access to a number of my reports
right now there's a 'Users Folders' in there along with my reports. I'm
unable to hide that. Do you know how to get rid of it?
"Bruce L-C [MVP]" wrote:
> Just an FYI, you can use expression builder, look at the global variables.
> One of those has what you want.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lynn" <Lynn@.discussions.microsoft.com> wrote in message
> news:DA80718F-E475-4891-93A5-EAEB1CB3D2D7@.microsoft.com...
> > Best case, I include the report date in the report header. Worst case, in
> > the subject line of the subscription email. I'm using SQL/RS v2000, VS
> > 2003,
> > anybody know how I can do this? nothing crazy, just like this:
> >
> > ReportName xx/xx/xxxx
> >
> > -- Lynn
>
>|||Yes, you can remove the browser role from that particular folder. Normally
the folder inherits from the parent so all folders initially have the same
roles assigned to them. Click on the folder, properties, security and remove
the browser role. Or, if it is just that you don't want them distracted by
it, you could hide in list view (properties, general).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lynn" <Lynn@.discussions.microsoft.com> wrote in message
news:CDBC9A73-7FD8-4271-9BCE-73D03A0BD3D1@.microsoft.com...
> Will do, Bruce, thank you. I will check it out.
> -- Lynn
> oh, oh, just a slightly related question -- i've created my browser role
> and
> i'm trying to send out this : http://webserver/reports
> such that certain people can have direct access to a number of my reports
> right now there's a 'Users Folders' in there along with my reports. I'm
> unable to hide that. Do you know how to get rid of it?
> "Bruce L-C [MVP]" wrote:
>> Just an FYI, you can use expression builder, look at the global
>> variables.
>> One of those has what you want.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Lynn" <Lynn@.discussions.microsoft.com> wrote in message
>> news:DA80718F-E475-4891-93A5-EAEB1CB3D2D7@.microsoft.com...
>> > Best case, I include the report date in the report header. Worst case,
>> > in
>> > the subject line of the subscription email. I'm using SQL/RS v2000, VS
>> > 2003,
>> > anybody know how I can do this? nothing crazy, just like this:
>> >
>> > ReportName xx/xx/xxxx
>> >
>> > -- Lynn
>>

Inaccurate HTML Rendering

(RS 2000)
I have 6 rows of text boxes in my body header running the width of the
report. All look fine in the report designer and when rendered to Adobe.
When I output to HTML, there are an extra 2 blank rows between the 5 and 6
TB. All the TB properties are exactly the same; I have tried
deleting/recreating, shifting around, nothing seems to help.
Thanks for any suggestionsFor anyone else that has the same problem I ran into where the HTML output
looks different than the designer or other output: I found if I slightly
reduced the vertical height of all the text boxes it fixed the problem.
"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:%23zD8P27TGHA.5908@.TK2MSFTNGP14.phx.gbl...
> (RS 2000)
> I have 6 rows of text boxes in my body header running the width of the
> report. All look fine in the report designer and when rendered to Adobe.
> When I output to HTML, there are an extra 2 blank rows between the 5 and 6
> TB. All the TB properties are exactly the same; I have tried
> deleting/recreating, shifting around, nothing seems to help.
> Thanks for any suggestions
>