Alignments between tasks and constrains

Hello

What are your experiences with the alignment of constrains between tasks?
I find it hard to align two task in an exact same vertical or horizontal position.

When you grab the green constrain lines with your mouse, you can see a soft pink dashed line which tels you which way to go with your mouse but it is so hard to get straight lines.

Is there a auto align task feature or something else I don't know of?
How do you guys do it?

Regards,

Worf

Have you looked at the options in Format menu of BIDS?

I personally use it to align the tasks but I do pay too much attention to the arrows.

Rafael Salas

|||

I knew I shouldn't of asked that question. I better start reading the basics before making packages.

Well Rafael..once again, thank you.
Worf

Alignment/Formatting in Page Header...

I find that if I use a bunch of textboxes in a 'tabular' layout in the page
header (or anywhere) things dont line up quite right. I need a table in info
in the page header (not from a dataset just static text and param labels) so
I figure I'll use a table in the Page Header but it tells me that I cannot
use a 'data region' in the page header.
There has to be a way to create a 'table' like layout in the page header!
Any feedback/suggestions are greatly appreciated.Are you using the align to: top, bottom, side tools?
"Terry Mulvany" wrote:
> I find that if I use a bunch of textboxes in a 'tabular' layout in the page
> header (or anywhere) things dont line up quite right. I need a table in info
> in the page header (not from a dataset just static text and param labels) so
> I figure I'll use a table in the Page Header but it tells me that I cannot
> use a 'data region' in the page header.
> There has to be a way to create a 'table' like layout in the page header!
> Any feedback/suggestions are greatly appreciated.
>
>|||I have had similar problems in the past. I ended up using tables in the
"Body" of the Report to display static text and param value instead of
placing individual text boxes in the Page header. Make sure that you set the
property (RepeatonNewPage) for the static header in the table to repeat in
every page.
"Terry Mulvany" wrote:
> I find that if I use a bunch of textboxes in a 'tabular' layout in the page
> header (or anywhere) things dont line up quite right. I need a table in info
> in the page header (not from a dataset just static text and param labels) so
> I figure I'll use a table in the Page Header but it tells me that I cannot
> use a 'data region' in the page header.
> There has to be a way to create a 'table' like layout in the page header!
> Any feedback/suggestions are greatly appreciated.
>
>|||Yes, but this does not help. When the report runs the gaps between say 6 or
so rows of info varies and looks terrible, when I use a table (only
available in Body though) all rows have the same distance between them and
it looks very nice. MS needs to create a new 'layout' tollbox control (or
modify the existing table so it can be used as a non-data region object).
"BK9" <BK9@.discussions.microsoft.com> wrote in message
news:ACD30BAB-C2D8-4F42-8BD5-D9499CB77961@.microsoft.com...
> Are you using the align to: top, bottom, side tools?
> "Terry Mulvany" wrote:
>> I find that if I use a bunch of textboxes in a 'tabular' layout in the
>> page
>> header (or anywhere) things dont line up quite right. I need a table in
>> info
>> in the page header (not from a dataset just static text and param labels)
>> so
>> I figure I'll use a table in the Page Header but it tells me that I
>> cannot
>> use a 'data region' in the page header.
>> There has to be a way to create a 'table' like layout in the page header!
>> Any feedback/suggestions are greatly appreciated.
>>
>>|||Can't actually do this because I need to display different headers on
different pages (based on Globals!PageNumber) and just as Data Regions
(tables for instance) cannot be used in Page Header, 'Globals' cannot be
used in Body. So I am stuck!
"Taps" <Taps@.discussions.microsoft.com> wrote in message
news:B3F8D95E-9581-47A1-9B52-E79DC61D7782@.microsoft.com...
>I have had similar problems in the past. I ended up using tables in the
> "Body" of the Report to display static text and param value instead of
> placing individual text boxes in the Page header. Make sure that you set
> the
> property (RepeatonNewPage) for the static header in the table to repeat in
> every page.
> "Terry Mulvany" wrote:
>> I find that if I use a bunch of textboxes in a 'tabular' layout in the
>> page
>> header (or anywhere) things dont line up quite right. I need a table in
>> info
>> in the page header (not from a dataset just static text and param labels)
>> so
>> I figure I'll use a table in the Page Header but it tells me that I
>> cannot
>> use a 'data region' in the page header.
>> There has to be a way to create a 'table' like layout in the page header!
>> Any feedback/suggestions are greatly appreciated.
>>
>>

alignment when value from custom code

I have a textbox in my heading that gets its value from custom code. The
horizontal alignment property is set to RIGHT and I notice that the value is
getting truncated in my report. There is another textbox that has a similar
problem. These text boxes are somewhat free standing in the report (not
within tables etc). Can anyone tell me if this is expected behavior and if
so ... how can I fix the alignment so it doesnt truncate my client name?
Thanks
the expression in the textbox in the heading is nothing unusual ...
=code.GetClient(ReportItems!tbClientName.value)Have you tried adjusting the padding of the control? Usually, when padding
is set to 0pt I'll see this behavior.
-Tim
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:BF351039-B112-473E-8DE0-B38F1643F25C@.microsoft.com...
>I have a textbox in my heading that gets its value from custom code. The
> horizontal alignment property is set to RIGHT and I notice that the value
> is
> getting truncated in my report. There is another textbox that has a
> similar
> problem. These text boxes are somewhat free standing in the report (not
> within tables etc). Can anyone tell me if this is expected behavior and
> if
> so ... how can I fix the alignment so it doesnt truncate my client name?
> Thanks
> the expression in the textbox in the heading is nothing unusual ...
> =code.GetClient(ReportItems!tbClientName.value)
>|||Havent messed with the padding ... it is 2pt all the way around.
"Tim Dot NoSpam" wrote:
> Have you tried adjusting the padding of the control? Usually, when padding
> is set to 0pt I'll see this behavior.
> -Tim
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:BF351039-B112-473E-8DE0-B38F1643F25C@.microsoft.com...
> >I have a textbox in my heading that gets its value from custom code. The
> > horizontal alignment property is set to RIGHT and I notice that the value
> > is
> > getting truncated in my report. There is another textbox that has a
> > similar
> > problem. These text boxes are somewhat free standing in the report (not
> > within tables etc). Can anyone tell me if this is expected behavior and
> > if
> > so ... how can I fix the alignment so it doesnt truncate my client name?
> > Thanks
> >
> > the expression in the textbox in the heading is nothing unusual ...
> > =code.GetClient(ReportItems!tbClientName.value)
> >
>
>

Alignment result

USE PUBS
GO
CREATE FUNCTION [dbo].[GetSpace] ()
RETURNS int AS
BEGIN
RETURN (SELECT max(len(fname)) + 1 FROM employee)
END
GO
SELECT top 5 fname + SPACE([dbo].GetSpace() - LEN(fname)) + lname AS
Expr1, [dbo].GetSpace() AS Expr2, LEN(fname) AS Expr3
FROM dbo.employee
When I execute the query over the query analyzer it gave me the correct
result like that...
Expr1
Aria Cruz
Annette Roulet
Ann Devon
Anabela Domingues
Carlos Hernadez
When I execute the query over the Enterprise Manger > View > Create New View
>
SELECT top 5 fname + SPACE([dbo].GetSpace() - LEN(fname)) + lname AS
Expr1, [dbo].GetSpace() AS Expr2, LEN(fname) AS Expr3
FROM dbo.employee
It gave the result on view pannel like that...
Expr1
Aria Cruz
Annette Roulet
Ann Devon
Anabela Domingues
Carlos Hernadez
I mean no alignment in the view pannel and when we call the same view over
the front end so it will gave the same unalign result.
Thanks
GetSpace user function returns the appropriate number of spaces but in
Enterprise Manager the problem is the font used.
Copy the result from Enterprise Manager in a word editor (like Microsoft
Word) and set the font to Courier New and Size 10. You will see that the
results will be aligned. The default font for results in Query Analyzer is
Courier New and Size 10.
Cristian Lefter, SQL Server MVP
"Joh" <joh@.mailcity.com> wrote in message
news:%235HNgnSYFHA.228@.TK2MSFTNGP12.phx.gbl...
> USE PUBS
> GO
> CREATE FUNCTION [dbo].[GetSpace] ()
> RETURNS int AS
> BEGIN
> RETURN (SELECT max(len(fname)) + 1 FROM employee)
> END
> GO
> SELECT top 5 fname + SPACE([dbo].GetSpace() - LEN(fname)) + lname AS
> Expr1, [dbo].GetSpace() AS Expr2, LEN(fname) AS Expr3
> FROM dbo.employee
> When I execute the query over the query analyzer it gave me the correct
> result like that...
> Expr1
> Aria Cruz
> Annette Roulet
> Ann Devon
> Anabela Domingues
> Carlos Hernadez
> When I execute the query over the Enterprise Manger > View > Create New
> View
> SELECT top 5 fname + SPACE([dbo].GetSpace() - LEN(fname)) + lname AS
> Expr1, [dbo].GetSpace() AS Expr2, LEN(fname) AS Expr3
> FROM dbo.employee
> It gave the result on view pannel like that...
> Expr1
> Aria Cruz
> Annette Roulet
> Ann Devon
> Anabela Domingues
> Carlos Hernadez
> I mean no alignment in the view pannel and when we call the same view over
> the front end so it will gave the same unalign result.
> Thanks
>
|||You are right. Thanks
"Cristian Lefter" <nospam_CristianLefter@.hotmail.com> wrote in message
news:ONgxYpcYFHA.2768@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> GetSpace user function returns the appropriate number of spaces but in
> Enterprise Manager the problem is the font used.
> Copy the result from Enterprise Manager in a word editor (like Microsoft
> Word) and set the font to Courier New and Size 10. You will see that the
> results will be aligned. The default font for results in Query Analyzer is
> Courier New and Size 10.
> Cristian Lefter, SQL Server MVP
> "Joh" <joh@.mailcity.com> wrote in message
> news:%235HNgnSYFHA.228@.TK2MSFTNGP12.phx.gbl...
over
>

Alignment problem with SQL Server 2000

Greeting
I have more than one language installed on my computer, and I tried to use my Enterprise Manager yesterday... What Im getting is with all the GUI im using Im having everything is Right Aligned....
Any help as to what I should change?
Thanks
This is my first post so would be great to have a qucik and handy answer :D??? :confused:

Can you attach a screenshot?

What country are you in?

blindman|||Here we go
Australia...I have English,Arabic,Japanese,Chinese installed|||Strange, in the Australian version everything is supposed to be upside-down, not reversed left-right.

.
.
.
Couldn't resist. :D

I'll see if I can find anything that might have caused this, but I've never seen it before.|||Dig hard man.. Its realy sucks to work with such alignment.|||I suspect this is a result of server settings on your platform.

What regional options do you have for your Locale and your Default Language?|||You mean like this ... go to control panel ... regional settings ... General tab ... and set english to default. :D ;) :p :).|||Nope,
Checked it now.. Hope it was the case.. I have English(Australia) as the default language... Im running XP if that helps...|||Originally posted by blindman
I suspect this is a result of server settings on your platform.

What regional options do you have for your Locale and your Default Language?
Hi,
Guess what you are right, its because Australia, hence the up side down :D Nah kidding
It wasnt the default language that wasnt set to English it was the Language for non-unicode Programs that wasnt set to English.
Cheers mate !!

Alignment problem

After i upload the report to server , and try to convert it to excel, the alignment of report is out!!the width of columns is different with the width i set in design..=.= however, the report is pretty when i preview in reporting servcise design.

Anyone face same problem?

Hi

this is probabily because of the page size u specified for the report in the report deisigner.

right click on the empty part of the report designer go to properties and in the layout tab u will have page width and page height.

Make shure that that the left ,right margin plus the report body width is less than the page width you are going to set same is the case with height.

If you dont get your problem solved by this please let me know.

Vamsi Krishna Korasiga

|||

nope..i 'd set my table rows' height to 0.11in..

when i preview n export to excel, it exactly same with what i do in designer.

but when i uploaded to server n export , the report rows change to 0.15

it cause i cannot fix all rows into one page..

N i wonder in the report properties>layout , there is field "columns" and "spacing"....

what is the use?would it affect my report row's height?

Alignment problem

After i upload the report to server , and try to convert it to excel, the alignment of report is out!!the width of columns is different with the width i set in design..=.= however, the report is pretty when i preview in reporting servcise design.

Anyone face same problem?

Hi

this is probabily because of the page size u specified for the report in the report deisigner.

right click on the empty part of the report designer go to properties and in the layout tab u will have page width and page height.

Make shure that that the left ,right margin plus the report body width is less than the page width you are going to set same is the case with height.

If you dont get your problem solved by this please let me know.

Vamsi Krishna Korasiga

|||

nope..i 'd set my table rows' height to 0.11in..

when i preview n export to excel, it exactly same with what i do in designer.

but when i uploaded to server n export , the report rows change to 0.15

it cause i cannot fix all rows into one page..

N i wonder in the report properties>layout , there is field "columns" and "spacing"....

what is the use?would it affect my report row's height?

Alignment etc...

This is a multi-part message in MIME format.
--=_NextPart_000_0028_01C6A504.9BB3C560
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How can I align a field with the right margin of the report? With the = Matrix, the report width varies depending on the amount of data. I can = seem to find a way to specify that a control is anchored to the right = margin. Or maybe even centered in the page..
Help?
Jerry
--=_NextPart_000_0028_01C6A504.9BB3C560
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
How can I align a field with the right = margin of the report? With the Matrix, the report width varies depending on = the amount of data. I can seem to find a way to specify that a control = is anchored to the right margin. Or maybe even centered in the page..

Help?

Jerry
--=_NextPart_000_0028_01C6A504.9BB3C560--Hi Jerry,
Thank you for your posting!
Based on my test, you could just put the textbox next to the right border
of your report. The textbox will align with the right border of the report.
Please try and let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks, Wei... But that doesn't work. Since the report is wider when it's
run than it is in the designer. And there's no way to determine, at design
time, how wide the report will, as the matrix expands dynamically based on
the criteria entered by the user at run time.
So... Is there any way to dynamically position any of the controls at run
time?
Thanks.
Jerry
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:TWFXnMYpGHA.4612@.TK2MSFTNGXA01.phx.gbl...
> Hi Jerry,
> Thank you for your posting!
> Based on my test, you could just put the textbox next to the right border
> of your report. The textbox will align with the right border of the
> report.
> Please try and let me know the result.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Jerry,
Thank you for the update.
You could not control the position of the control dynamically in the
report.
If the text box left border is next to the right border of the matrix, the
textbox will be position on the right of the matrix.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Jerry,
How are you doing on this issue? Does Wei's suggestion in the last reply
helps you some? If you still have any problems or need any further
assistance, please feel free to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||I'm not sure I understand his suggestion at all... I have a textbox just
below and aligned with the right border of the matrix...
At run time, the matrix expands to accomodate maybe 3 to 7 columns,
depending on data. But the textbox stays at the position it was at in the
designer.
I want the text box's right edge position to stay aligned with the right
edge of the matrix as it expands.
Thanks.
Jerry
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:$TtwwejqGHA.2024@.TK2MSFTNGXA01.phx.gbl...
> Hello Jerry,
> How are you doing on this issue? Does Wei's suggestion in the last reply
> helps you some? If you still have any problems or need any further
> assistance, please feel free to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> =================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>