PackageID and GUIDs in ExecuteSQL task

Am I looking at a potential bug here or do I not understand the feature properly? I have an ExecuteSQL task that inserts into a table for logging and includes the System::PackageID as one of the values. It's stored in my table as a uniqueidentifier. When I set the output variable in Parameter Mappings tab of the Execute SQL task to VarChar, all works great. WHen I set it to GUID as the data type in that tab, it outputs a different GUID than the actual System::PackageID variable.

-- Brian

This is not a bug, although several have thought it was. If you look at the system variable you will notice that even though it looks like a GUID the type of the variable is a string. This is why when you set the SQL task to use a string type it shows the correct value. However, when you set to GUID you don't get the value you expect because the SQL Task doesn't perform conversion for you so the value being placed in your uid field is actually a guid representation of the pointer not that GUID that is pointed to. Currently, if you want to set the GUID into a uid field in SQL I believe you need to use a script task because then you can get the conversion you expect.

HTH,

Matt

Overlay of textboxes are not rendering properly

In the page header I have a rectangle that has 2 textboxes on the same line and both are the full length of the page. One textbox has text centered and the other has text right justified. When I render report in Studio or print it, the text appears on the same line and justified like I want, but when the report is rendered when I call the report by URL, the textboxes wrap, like it's taking the width of each textbox in account. Has anyone seen this? Any suggestions on how to overlay text on the same line and the text keep their own individual characteristics?

I do not believe that you can overlap two textboxes. One will push the next one down to the next line. Can't you make one text box only long enough to allow the text that you need, then Format that text box ittself to align Format-Center in Form-Horizonally. Create the second text box, only as large as you need to hold that text that you are displaying. Then put that text box all the way to the right of your page and align the text in it to right.

|||Yes, that sounds like that would work, but how do you format-center in the form-horizonally?|||Create the first text box and make it only large enough to display the text that you need it to display. Click on the text box itsself to select it, go up to the menu bar and click format, slide down to center in form, select horizontally. This will center that text box in the middle of your page. Then you could actually choose text align in your properties and middle align the text within the text box itsself if you needed to do that. Hope this helps.|||

Kim,

Thanks for trying, but that won't work for me because of a couple reasons: 1) The text is dynamic, so I have no idea on how wide to make my textbox. 2) Even if my text is static and I shorten them up and center the one text box, they still overlap.

Overlapping Report Items via HTML?

Has anybody managed to get Overlapping Report Items to display properly
in Internet Explorer or some other browser? (Ignoring Microsoft's
statement that overlapping items are not supported in HTML)
Extensions or additions to the Rendering Extension, or any other
suggestions would be welcome.I also want to know has any idea about this issue!
Angi
"Sam" <samadams001@.googlemail.com>
'?:1148978623.733811.128950@.j33g2000cwa.googlegroups.com...
> Has anybody managed to get Overlapping Report Items to display properly
> in Internet Explorer or some other browser? (Ignoring Microsoft's
> statement that overlapping items are not supported in HTML)
> Extensions or additions to the Rendering Extension, or any other
> suggestions would be welcome.
>

Overlapping images won't position themselves properly on the web

I have noted that if two images with different zIndex overlapping each other
will display as if they were word-wrapped on the web. In fact, as soon as
the web service generates html, this problem occurs.
Is it a known bug or a misuse I am doing?
Thanks!
Marc Lacoursiere
Programmer/Analyst
CGIOverlapping items are only supported by image-based renderers, but not in
HTML.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"news.microsoft.com" <marcdotlacoursiere@.cgi.com> wrote in message
news:e9joNg0yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> I have noted that if two images with different zIndex overlapping each
other
> will display as if they were word-wrapped on the web. In fact, as soon as
> the web service generates html, this problem occurs.
> Is it a known bug or a misuse I am doing?
> Thanks!
> Marc Lacoursiere
> Programmer/Analyst
> CGI
>