Koen Verbeeck (8/6/2013)

---

So you want to use this formula as a SSRS formula?

In that case, it would be something like this:

iif(Fields!event_type == "c","R" + Format(Fields!event_type,"####0"),iif(Fields!event_type == "i",Format(Fields!event_type,"####0"),"P" + Format(Fields!event_type,"####0"))

Not 100%...

This is Crystalreport. In crystal report you can use Formula Fields. know i wanne convert it.

When you read the code you can see that the difference is little. I hope...

David Burrows (7/16/2013)

---

Check the language for each of the logins as this determines conversion of character dates.

Are you passing the date parameters as character? If so is there a specific...

ANSWERS

The Query of Lowell works. Only now i get a value of the total of the table item_keya / snetworkname * 100.

But i use this qeury;

SELECT

sNetworkName,

REPLACE(sNetworkName,'.noc','')

FROM...

I was not the person who made this table (thats why i cant tell you so much about it :S srry;

When i run the syntax

SELECT ((count(item_keya) / count(snetworkname))...

I have made ??a comparison of query and snetworkname item_keya. Below the syntax:

SELECT

snetworkname,

REPLACE(sNetworkName,'.noc','')

FROM WhatsUp_Assyst_replicatie3.dbo.NetworkInterface

RIGHT OUTER JOIN ...

Somebody a Answer

TNX A LOT 🙂 I use it for a lot reports 🙂

can you use my SYntax what you mean?

select snetworkname from WhatsUp.dbo.NetworkInterface right outer...

I dont get any valuas out the Query ??

Grant Fritchey (5/21/2013)

---

Well, OK then. If it's bytes, what do you want to display? Kilobytes is derived by dividing the number of bytes by 1024 because that's how many bytes...

Its bytes in colmn

And the units you see in de qeury before that he find the units in device.deviceid and name.

ChrisM@Work (5/21/2013)

---

karim.boulahfa (5/21/2013)

---

select *

from StatisticalDisk

Thats are the...

select *

from StatisticalDisk

Thats are the rseult of...