when hide rectangle on left right rectangle moved to hidden

Question

I working in rdlc microsoft report windows form vs 2015

 

i have two rectangle controls

 

First show on left side

 

second show right side

 

when i hide left rectangle and try to print report

 

i see right rectangle moved to place of hidden rectangle left rectange

 

I need only print right rectangle on position right

 

but it moved if left rectangle hidden

 

How to prevent conume white spaces when controls hidden ?

 

Answer 1

If your quantity is going to be less than 2147483647 then use int datatype,
if your quantity is going to be more than that and less than 9223372036854775807, use bigint data type.

if you are sure Unit cost price is going to be only from 1 pound to 200 pound, use smallint datatype.
but dont guess here, ask or clarify with BA. if you need to store fractions either use decimal or money or smallmoney datatype

for amount, use money data type which can store value upto 922337203685477.5807

and I suggest you to use calculated column for amount.

Answer 2

On top of Nilesh's reply, it is always good to keep below reference handly.

 

https://www.connectionstrings.com/sql-server-data-types-reference/

 

Answer 3

I am working in inventory applicaion.so i will tell about my suggestion

 

Qty: is only allow number. So you can set NUMERIC(18,0) data type

Unit Cost: is getting decimal value like 10.1000. So you can set NUMERIC(18,4) data type

 

Note:

 In future end users will be asked extern thire Cost value form 10.1000 to 10.100000.that time we have to stuck. So numeric datatype already is there.you can make it as an User Define Datatype. 

 

 

Note:Don't forget to accept.if you agreed my reply