Manage TextBox.Value in other TextBox for calculations

Hi,
I need to know if and how can I do this:
tbTotal tbNumber1 tbNumber2
? 12 5
? 3 7
If I've some rows and I want insert in expression of tbTotal the pseudo-code
tbNumber1+tbNumber2
how can I do this? I need this method because the real formula is more
complex with condition etc..
Help me please!!!!! :-)Dario,
you can do this way
ReportItems!tbNumber1.Value+ReportItems!tbNumber2.value
or
Fields!Number1.Value+Fields!Number2.Value
Kiran
"Dario Concilio [MCP]" <dco@.experta-spa.com> wrote in message
news:eP3TQqxcFHA.3940@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need to know if and how can I do this:
>
> tbTotal tbNumber1 tbNumber2
> ? 12 5
> ? 3 7
>
> If I've some rows and I want insert in expression of tbTotal the
> pseudo-code
> tbNumber1+tbNumber2
> how can I do this? I need this method because the real formula is more
> complex with condition etc..
> Help me please!!!!! :-)
>

Making a row delete itself at a certain time?

Is there any possible way to make a row delete itself at a certain date and time? I am tring to make an "On_Sale" table and perticular items(rows) must expire at a certain Date and time. I have an idea to delete a row when it expires but it will cause an extra burden on my application. So is it possible to have SQL responsible for deleting a row at a certain time and date?

Also, I have another question:
when I asign a PK Identity to a certain column is there a way I can enforce consecutive order of PK values? For example if I delete a row and the PK value was 5 it will reoder the whole table so all PK values are in consecutive order:

PK----Item----price
1----XYZ1----$$$$
2----XYZ2----$$$$
3----XYZ3----$$$$

when I delete PK 2 this is what happens

PK----Item----price
1----XYZ1----$$$$
3----XYZ3----$$$$

the PKs are not in consecutive order

What I want is this to happen: when PK 2 is deleted I need it to show as follows

PK----Item----price
1----XYZ1----$$$$
2----XYZ3----$$$$

The PKs stay in consecutive order.

See how the PK are still in consecutive order?I am tring to make an "On_Sale" table and perticular items(rows) must expire at a certain Date and time. I have an idea to delete a row when it expires but it will cause an extra burden on my application.Why delete it at all? Save the expiration date within your row, and then create a view on that table with something like WHERE expiration_date <= current_date. Then make your application use the view to retrieve the data (or simply add the condition to your application logic), thus it will never see expired rows. If you put an index on that column the retrieval should be quite fast.

If you are concerned about space, than run a batch job every night that deletes the expired rows.|||you could create an agent job that would delete the rows also.

making a dimension smart

Hi,

We have a cube with a client dimension which has lots of rows and about 60 attributes.

The table looks like this

ID, first name, infix, lastname, street, housenumber, postal code, city, gender.

The users want to see all the attributes..

Analysis server is making calculations on every attribute.

The users are only intrested in ID, city and gender but they don't want to loose the other attributes.

How can I tell analysis server that it should not make calculations on the first name, infix and lastname, street, housenumber and post code?

I tried setting the attribute IsAggregable to false but that didn't work.

Any suggestions ?

With regards,

Constantijn Enders

If you don't want the data to aggregate, set the AggregationUsage property to None in the Attributes tab, in the Dimension window (possibly the bottom left window) under the Cube structure tab in VS.

C
|||

what type of calculations you do?

usually you do calculations in numeric values...

you can set aggregation to none...

give more details...

Regards

Make Table not appear

Hello
I want to edit my visibility of a table depending on the number of rows
it has. i.e if there are no rows present I want to display a message
instead, so make the table invisble and make the message visible. Is
this possible if so how do I do it, my gues would be to count the
number of rows and display if greater then 1?
Any help would be greatly appreciated
DenverHi Denver.
The way I would go about doing this is by placing an iif statement in the
visibility section of the properties. This would basically specify true for
if there were no rows returned or false if there is data returned.
Regards
"Denver" wrote:
> Hello
> I want to edit my visibility of a table depending on the number of rows
> it has. i.e if there are no rows present I want to display a message
> instead, so make the table invisble and make the message visible. Is
> this possible if so how do I do it, my gues would be to count the
> number of rows and display if greater then 1?
> Any help would be greatly appreciated
> Denver
>

Make row in table shrink or collaps

How can I make a row in a table shrink or collapse when there's no data for
that row? I have a table with several detail rows in it. the bottom row
has 2 cells. the first one if for a label and the second one is for the
data.
cell 1: =iif(len((Fields!Id_Assignee.Value))>0,"Assignees","")
cell 2: =(Fields!Id_Assignee.Value)
The iff statement in cell 1 works good so when there's no data it doesn't
show the label. Now when there's no data in cell 2, how can I make this row
go away completely? I set the CanShrink property for both cells to true.
Thanks.
--
moondaddy@.nospam.nospamPut the hight of the row = 0 (you have to do this in the properties panel,
not in the window you get by right clicking) and enable the hight to grow
"moondaddy" wrote:
> How can I make a row in a table shrink or collapse when there's no data for
> that row? I have a table with several detail rows in it. the bottom row
> has 2 cells. the first one if for a label and the second one is for the
> data.
> cell 1: =iif(len((Fields!Id_Assignee.Value))>0,"Assignees","")
> cell 2: =(Fields!Id_Assignee.Value)
> The iff statement in cell 1 works good so when there's no data it doesn't
> show the label. Now when there's no data in cell 2, how can I make this row
> go away completely? I set the CanShrink property for both cells to true.
> Thanks.
> --
> moondaddy@.nospam.nospam
>
>|||Thanks that is exactly what I was looking for.
Does this mean Can Shrink doesn't really work?
Dave
"Antoon" wrote:
> Put the hight of the row = 0 (you have to do this in the properties panel,
> not in the window you get by right clicking) and enable the hight to grow
> "moondaddy" wrote:
> > How can I make a row in a table shrink or collapse when there's no data for
> > that row? I have a table with several detail rows in it. the bottom row
> > has 2 cells. the first one if for a label and the second one is for the
> > data.
> >
> > cell 1: =iif(len((Fields!Id_Assignee.Value))>0,"Assignees","")
> > cell 2: =(Fields!Id_Assignee.Value)
> >
> > The iff statement in cell 1 works good so when there's no data it doesn't
> > show the label. Now when there's no data in cell 2, how can I make this row
> > go away completely? I set the CanShrink property for both cells to true.
> >
> > Thanks.
> >
> > --
> > moondaddy@.nospam.nospam
> >
> >
> >