Search results for query: *

I tried using a scope in my expressions for the grouped data. I grouped the values Devicename, OStype, PC laststartup and user value in a group called "table1_Group2" If I try to set the scope for my expression like this: =sum(iif(Fields!OSType.Value = "Microsoft Windows XP...

Dear Reader, I build a query that gives me information about our computers(1200) and their software. This query gives me for example the following results: Sql Example: Devicename OS Location Software Comp1 WinXp office office 2003 Comp1 WinXp...

I solved it by using: =sum(iif(Fields!title.Value = "Microsoft Office 97 Standard",1,0)) Another problem was that I named the title field in my query as software. When I used software in the expressions or script It didn't work beacause it thought it was another dataset. Renaming it back to...

Dear xlbo, Thanks for your reply. If I use =SUM(iif(Fields!Software.Value = "Microsoft Office 2003 standard",1,0)) I get: [rsFieldReference] The Value expression for the textbox ‘textbox49’ refers to the field ‘Software’. Report item expressions can only refer to fields within the current...

I tried to put the retrieved software values in an array and then tried to run the scipt but I can't get it working..

I tried the following. I made the following custom code: Dim getal As String Dim leeg As String Public Function getcount(Value as String) As String For i As Integer = 0 to 1000 - 1 if Value = "Microsoft Office 2003 standard" then getal = getal +1 else leeg =...

Dear Swhitten, Thanks for your reply! The problem is that the same software needs to be shown per different computer + user combination. A subtotal of the products in the query results dousn't give me enough flexibility. I'm now trying to make function that count some values trough an if...

Is it also possible to do for example, =Count(Fields!software.Value, "Microsoft Office XP standard") and =Count(Fields!software.Value, "Microsoft Office XP professional") ?

Dear Reader, I have build a query that returns me information of used microsoft products within our organization. One row gives back one of the following values: Microsoft Office 97 Standard Microsoft Office 97 professional Microsoft Office 2000 Standard Microsoft Office 2000...

Dear Acessn, Thanks for your reply! With that function I can strip down everything left of the market group? I was wondering, is it also possible to strip down everything left and right of the string?

Dear reader, Currently I’m making a report that shows the used Microsoft products in our organization. This information needs to be ordered by the market group where the computer is in. This information is stored in our OU structure. All the required information is in a sql database (by...