possible to inline text fields?

I have a report that looks something like the below.
Hello ______,
Your current interest rate is _____%.
SIgned,
___________
How can I inline all of these _______ fields with textbox's so I can
populate them from a sproc. Is there an easy way to do this? There
has to be...
ThanksHi,
Add a rectangle control in the layout. then add the textboxes inside
the Rectangle control. if you want to show the inline, then right click
on the textbox --> go to properties --> text decoration --> underline.
add the field to the corresponding textbox.
petejk wrote:
> I have a report that looks something like the below.
> Hello ______,
> Your current interest rate is _____%.
> SIgned,
> ___________
>
> How can I inline all of these _______ fields with textbox's so I can
> populate them from a sproc. Is there an easy way to do this? There
> has to be...
>
> Thanks|||I meant to say that there is text being populatd in the _______ fields.

Possible to have 2 Identity columns in a field?

Hi - is it possible to have 2 Identity (auto increment) fields in table?
Each time I try to change the one to an Identity column, it changes the
other to NOT an identity column.
Thanks, Mark
*** Sent via Developersdex http://www.examnotes.net ***Mark
No.
You cannot have more than one an identity column as well as updating
(identity) is not allowed.
You can generate your own an autoincrement colunm
create table #t
(
col1 int not null identity(1,1),
col2 as col1
)
insert into #t default values
select * from #t
Note: There are some "divantages" . With an identity you cannot be sure
that there will not be gaps or duplicates
"Mark" <anonymous@.devdex.com> wrote in message
news:uGw12ikyFHA.1032@.TK2MSFTNGP12.phx.gbl...
> Hi - is it possible to have 2 Identity (auto increment) fields in table?
> Each time I try to change the one to an Identity column, it changes the
> other to NOT an identity column.
> Thanks, Mark
>
> *** Sent via Developersdex http://www.examnotes.net ***|||No.
Such situation never occurs in proper design
--
Regards
R.D
--Knowledge gets doubled when shared
"Mark" wrote:

> Hi - is it possible to have 2 Identity (auto increment) fields in table?
> Each time I try to change the one to an Identity column, it changes the
> other to NOT an identity column.
> Thanks, Mark
>
> *** Sent via Developersdex http://www.examnotes.net ***
>|||No. Please explain why you would want more than one IDENTITY column in
a table.
What can you do with 2 columns that you can't already do with 1?
David Portas
SQL Server MVP
--|||Hi,
Its not possible to have two identity columns in the same table.
However I have never seen it changing an existing identity column into
not an identity column. Can u pls send me the script.
Regards,
Shanmugam
Mark wrote:

> Hi - is it possible to have 2 Identity (auto increment) fields in table?
> Each time I try to change the one to an Identity column, it changes the
> other to NOT an identity column.
> Thanks, Mark
>
> *** Sent via Developersdex http://www.examnotes.net ***

Possible to assign a value to a textbox?

Hi,
Is it possible to assign a value to a textbox when viewing reports, depending on certain values of the fields. E.g if Fields!Month.Value = Parameters!Month.Value, i want to display some message in the textbox.
Hi eeyore21
It is possible unless I'm not understanding the question correctly. Try this:
Select the textbox properties. In the 'Value: ' property select 'Expression' (button next to textbox)
type in '=IIF( Parameters!PamaterName.Value = Fields!FieldName.Value,"Print this if true","Print this if False")'

whereParameters!PamaterName.Value - this is the parameter value which you want to compare to Fields!FieldName.Value ( dataset field name)

In your case it would be :=IIF(Fields!Month.Value = Parameters!Month.Value,"IT IS TRUE DO SOMETHING","NOT TRUE DO SOMETHING ELSE")'