Hide 0 value

Hello,

I made a calculed member

with this formule distinctcount([sales order].members)

I would like that the "0" value doesn't appear.

Is it possible ?

Sure. Use the IIF statement in your calculated member to evaluate the value. If yoe return a value of 0, substitute a another value in it's place. You could substitute NULL or even a string such as "n/a".

Good luck,

Bryan

|||

I tried this formule

iif(distinctcount([no appels].members)=0,NULL,distinctcount([no appels].members))

and I have an error :

distinctcount must be used as a function of higher level (most external)

|||

I find the answer,

I created a new calculed member and I could use the iif to exclude the 0 values.

sql

Hidden Parrameters

Hi,
I want to send to my Report hidden parameters by Url.
I read that in order to do so I need to check the Prompt User checkbox
and clear the Prompt string.
But I can't find the Prompt User checkbox in the Report Parameters window.
I installed SP1, but still I can't find this checkbox.
Where is it?
Thanks,
LimorHi Limor,
You can define a parameter as a hidden parameter on the Report Server where
you deploy it.
Unfortunately this is a minus point for RS since the hidden parameters are
first introduced with Service Pack 1
You just go to the Report Properties Tab on the Report Server for that report.
Select Parameters from the left menu.
When you click it then the list of parameters will be displayed. You will
see the "Prompt User" checkbox there.
Eralper
http://www.kodyaz.com
"Limor Bellison" wrote:
> Hi,
> I want to send to my Report hidden parameters by Url.
> I read that in order to do so I need to check the Prompt User checkbox
> and clear the Prompt string.
> But I can't find the Prompt User checkbox in the Report Parameters window.
> I installed SP1, but still I can't find this checkbox.
> Where is it?
> Thanks,
> Limor
>|||Hi eralper,
Thanx for your fast response.
I did exactly what you told me and get into the Parameters window,
but there is no "Prompt User" checkbox.
Do you want me to send you a print screen of this window to your email?
Limor
"eralper" wrote:
> Hi Limor,
> You can define a parameter as a hidden parameter on the Report Server where
> you deploy it.
> Unfortunately this is a minus point for RS since the hidden parameters are
> first introduced with Service Pack 1
> You just go to the Report Properties Tab on the Report Server for that report.
> Select Parameters from the left menu.
> When you click it then the list of parameters will be displayed. You will
> see the "Prompt User" checkbox there.
> Eralper
> http://www.kodyaz.com
>
> "Limor Bellison" wrote:
> > Hi,
> > I want to send to my Report hidden parameters by Url.
> > I read that in order to do so I need to check the Prompt User checkbox
> > and clear the Prompt string.
> > But I can't find the Prompt User checkbox in the Report Parameters window.
> > I installed SP1, but still I can't find this checkbox.
> > Where is it?
> >
> > Thanks,
> >
> > Limor
> >|||Hi Limor,
I added a post at http://www.kodyaz.com/ShowPost.aspx?PostID=291 about this
subject and attached two images. One for the settings and the other is for
sending the hidden parameter by url
"Limor Bellison" wrote:
> Hi eralper,
> Thanx for your fast response.
> I did exactly what you told me and get into the Parameters window,
> but there is no "Prompt User" checkbox.
> Do you want me to send you a print screen of this window to your email?
> Limor
>
> "eralper" wrote:
> > Hi Limor,
> >
> > You can define a parameter as a hidden parameter on the Report Server where
> > you deploy it.
> >
> > Unfortunately this is a minus point for RS since the hidden parameters are
> > first introduced with Service Pack 1
> >
> > You just go to the Report Properties Tab on the Report Server for that report.
> > Select Parameters from the left menu.
> > When you click it then the list of parameters will be displayed. You will
> > see the "Prompt User" checkbox there.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> >
> >
> > "Limor Bellison" wrote:
> >
> > > Hi,
> > > I want to send to my Report hidden parameters by Url.
> > > I read that in order to do so I need to check the Prompt User checkbox
> > > and clear the Prompt string.
> > > But I can't find the Prompt User checkbox in the Report Parameters window.
> > > I installed SP1, but still I can't find this checkbox.
> > > Where is it?
> > >
> > > Thanks,
> > >
> > > Limor
> > >|||Thank you, this is exactly what I needed.
My mistake was that I was trying to do it from the visual studio instead of
the Report Manager. Now it's working.
Thanx,
Limor
"eralper" wrote:
> Hi Limor,
> I added a post at http://www.kodyaz.com/ShowPost.aspx?PostID=291 about this
> subject and attached two images. One for the settings and the other is for
> sending the hidden parameter by url
>
> "Limor Bellison" wrote:
> > Hi eralper,
> > Thanx for your fast response.
> > I did exactly what you told me and get into the Parameters window,
> > but there is no "Prompt User" checkbox.
> > Do you want me to send you a print screen of this window to your email?
> >
> > Limor
> >
> >
> > "eralper" wrote:
> >
> > > Hi Limor,
> > >
> > > You can define a parameter as a hidden parameter on the Report Server where
> > > you deploy it.
> > >
> > > Unfortunately this is a minus point for RS since the hidden parameters are
> > > first introduced with Service Pack 1
> > >
> > > You just go to the Report Properties Tab on the Report Server for that report.
> > > Select Parameters from the left menu.
> > > When you click it then the list of parameters will be displayed. You will
> > > see the "Prompt User" checkbox there.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > >
> > >
> > > "Limor Bellison" wrote:
> > >
> > > > Hi,
> > > > I want to send to my Report hidden parameters by Url.
> > > > I read that in order to do so I need to check the Prompt User checkbox
> > > > and clear the Prompt string.
> > > > But I can't find the Prompt User checkbox in the Report Parameters window.
> > > > I installed SP1, but still I can't find this checkbox.
> > > > Where is it?
> > > >
> > > > Thanks,
> > > >
> > > > Limor
> > > >

Help?

sorry if im off topic.

I was trying to home network with windows XP, in order for me to shear Internet connection with other computers in the house. I have cable modem and its using USB port.. which makes my Ethernet adopter free.

I've tired contacting the Ethernet adapter to each computer (two computer) using a cat5 Ethernet cord.. but the local area connection show's unplugged..? there for i can't bridge
the computers?

am i missing something?You will need a cross-over ethernet cable to connect 2 PCs directly. You can use straight Cat5 cables if you have an ethernet hub/switch.

Help:Locking...

Hello .
I am using SQL Server 2000 in order to create a multi user program that accesses data.
The problem is that multiple users will update and select data at the same time at the same table.

Is there a way to avoid deadlocks ?
I heard about two ways: using a temporary table to store data and then write the data only when the user finished the update.
and the other is using xml to write the database to a xml file that is stored locally. do the updates on the file and then after completion insert the xml file into the database.

does anybody know much about these ways? do you know where i can find code for this ?

is there a better way?

thanks !
and happy new year !yeah, according to the textbook of database, there should be 2 other ways instead of write the information to other place from the database.

1. lock all what u will lock in the transaction when u begin the transaction.

2. all kinds of resources should be locked at the same order.

hehe.

happy new year.|||Those two ways you described will help but truely it all depends on how you write your sql script. Are all the updates and deletes using cursors? Do you have begin trans and commit on all your transactions? There is no one way you can completely avoid deadlocks, but there are ways to manage it. The best way is to let us know what sql script in your environment that creates deadlock so we can better help with your situations.|||Are we talking about deadlocks or blocking here? It surely sounds that the poster is concerned about object availability when more than one connection attempts to access its data.|||There is no silver bullet to avoid deadlocking other than fully analysing the transactions you intend to commit. Using a temporary table may work, as long as your transaction does not depend upon data previously read from the permanent tables remaining unchanged during the accretion of the temporary data. XML in this regard is a complete red herring.

Essentially you control locking policy using the SET TRANSACTION ISOLATION LEVEL command and wrapping all calls with an outer transaction until all components of the unit of work are available for committing.

You need to consider whether the integrity of data reads is essential to the integrity of the intended data writes. If youre booking seats on an aircraft you must ensure no other user books your particular seat between you reading that its free and you writing that youre booking it. To make reads fully transactional with writes you use isolation level SERIALIZABLE everything you read is locked against being updated or inserted against for the duration of the transaction. Isolation level REPEATABLE READ ensures that data you have read cannot be updated by another user, but allows background inserts.

If it is not possible to extend the duration of the transaction between critical reads (i.e. you can keep your option on the flight seat open for twenty minutes) you must implement soft locking of the seat row in the permanent tables using something like a timestamp or a flag.

Isolation level READ COMMITTED ensures you can only read data that has had full transactional commit to the database. You use this read mode to ensure you never read over another users half finished work, but you have no locks of the data you have read for the purposes of subsequent writes. READ UNCOMMITTED means you read through any locks applied during any other users writes. You cannot write through any other users locks.

Particularly useful in ensuring transactional integrity is SET XACT_ABORT ON, which will cause any error anywhere in your SQL to Rollback the entire transaction.

Also be aware that if a deadlock does occur SQL will terminate one or other transaction, at random, unless you explicitly set a deadlock priority on the thread whose death you would prefer to occur.|||Yeah, use strored procedures and stroe the data locally...

don't do dynamic sql

don't open recordsets...

Read data store

manipulate data in the app

when an action is to occur...update or delete, check the records timestamp to see if someone else alread modified the record and act accordingly

if ok, exec (through a sproc) your transaction...

keep'em short