Showing posts with label matrix. Show all posts
Showing posts with label matrix. Show all posts

Wednesday, March 28, 2012

reporting services 2005 proxy

I am trying to create a RS proxy to use in my web site. I did this successfully with RS2000. I used web matrix to generate the proxy and put the dll and .cs file in the bin directory of the web site, then I just used <%@. import namspace="rsProxy" %>. It worked like a charm. Now I am trying to get the 2005 version working and created the dll's but all I get in my web page is that it couldn't find the namespace.

I also tried adding a web reference through VS 2005. I don't use projects in my web site so in the VS 2005 method it created a folder under my web site called App_WebReferences. In that folder was another named after my server (reference name defaulted it to, say myServerName). Within that folder there are two files: reportservice2005.discomap and reportservice2005.wsdl. I then tried thier examples to create an instance of ReportingService2005 on the page_load event:

reportservice2005.myServerName.reportservice2005 rs = new reportservice2005.myServerName.reportservice2005();

rs.Url = "http://myservername.reportserver/reportservice2005.asmx?wsdl";

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

I get the follwiong error:

CS0246: The type or namespace name 'reportservice2005' could not be found (are you missing a using directive or an assembly reference?)

I tried to import the namespace as I did in 2000 with the same error.

I am trying to read the listchildren and populate a treeview. Any suggestions?

Not sure how VS 2005 is different in this respect, but in any case you could use wsdl.exe to extract a *.cs file from a SOAP endpoint. Then you can just include that file in your project.|||

I can get the dll and .cs file to generate. Again, I am not using projects in my web site. Even when I created the web reference in VS it showed all the methods available in the reportingservice2005 and reportexecution2005. I generated it and have tried to implement it using multiple methods but none work. Is there something on the report server or IIS that needs to be setup in order to make a web service available for consumption? I was thinking that maybe during the installation or configuration I missed something. Anyway, I followed the exact same process I used with RS 2000 and it doesn't work.

By the way, thanks for the reply. I'll keep plugging away at it.

|||

ok, I got it this far. I can get the auto-list members to display in VS 2005. Here is my code:

WindowsImpersonationContext impersonationContext;

WindowsIdentity currentWindowsIdentity;

currentWindowsIdentity = WindowsIdentity.GetCurrent();

impersonationContext = currentWindowsIdentity.Impersonate();

rsWebReference.ReportingService2005 rs = new rsWebReference.ReportingService2005();

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

rsWebReference.CatalogItem[] items = rs.ListChildren("/", true);

foreach (rsWebReference.CatalogItem ci in items)

{

if (ci.Type.ToString() == "Folder" && ci.Hidden == false)

{

Response.Write(ci.Name);

Response.Write(ci.Path);

}

}

impersonationContext.Undo();

Even though the list members are working, it still gives me the same error:

The type or namespace name 'rsWebReference' could not be found (are you missing a using directive or an assembly reference?)

|||The problem was the web site is using the 1.1 framework. When I changed it to use 2.0 it worked.

Monday, March 26, 2012

Reporting Services 2005 - Matrix Grouped Report - Calculating Percentages %

Hi,

Could someone help with the following problem, I what to create a cross-tab report of the following data, grouped by Colour:

RAW DATA

Name Colour Sarah Black Kim Red Jane Black Jane Pink Robert Yellow Tom Green Tom Black Billy Black Sarah Black Sarah Black Tom Pink Kim Pink Robert Black

Group Colours by Names Report

Number Proportions % Name Black Green Pink Red Yellow Total by Name Black Green Pink Red Yellow Billy 1 1 100.00% 0.00% 0.00% 0.00% 0.00% Jane 1 1 2 50.00% 0.00% 50.00% 0.00% 0.00% Kim 1 1 2 0.00% 0.00% 50.00% 50.00% 0.00% Robert 1 1 2 50.00% 0.00% 0.00% 0.00% 50.00% Sarah 3 3 100.00% 0.00% 0.00% 0.00% 0.00% Tom 1 1 1 3 33.33% 33.33% 33.33% 0.00% 0.00%

I want to produce a Matrix cross-tab report, like the above, within Reporting Services. Any suggestions welcome

Many Thanks,

Radha

This is a pretty basic matrix report. Make sure to add a matrix to the layout design and then...

1. add name to row

2. add color to column

3. add name to data and change the expression to count(name.....)

4. add name to data again but to the right of the first one. You will see a light blue/green line appear and then release your mouse. Now you need to change the expression to formatpercent(count(name...))

This should do it.

|||

fsugeiger

Thanks for the above response, but now I am getting 300% for Name, Sarah for the colour Black . I need to show this as the percentage of the "Total by Name" that should = 100%.

For Tom the % should be 33%, not 100% results now:-

Name Black Green Pink Red Yellow Total by Name Black Green Pink Red Yellow Sarah 3 3 300.00% 0.00% 0.00% 0.00% 0.00% Tom 1 1 1 3 100.00% 100.00% 100.00% 0.00% 0.00%

Solution to this would be very welcome, and greatly appreciated, from anyone.

Thanks

Radha

|||Hi , i m currently building a report that will calculate frequencies using a MATRIX .

I have a column that contains multiple groups of answers as you can see in the following screenshot.

In each group of answers i compute the total (calling the subtotal function) .

The problem is that now i want to compute the frequencies for each answer.. So for the first group of answers i want to divide each cell with each corresponding total .

I cant do that at the current moment because the number of answers in each group is diffirent (im using a matrix) and there is no way to know the total because it is computed on the fly.

Is there a way i can do that?

Thnx in advance

Reporting Services 2005 - Matrix Grouped Report - Calculate Percentages

Hi,

Could someone help with the following problem, I what to create a cross-tab report of the following data, grouped by Colour:

RAW DATA

Name Colour Sarah Black Kim Red Jane Black Jane Pink Robert Yellow Tom Green Tom Black Billy Black Sarah Black Sarah Black Tom Pink Kim Pink Robert Black

Group Colours by Names Report

Number Proportions % Name Black Green Pink Red Yellow Total by Name Black Green Pink Red Yellow Billy 1 1 100.00% 0.00% 0.00% 0.00% 0.00% Jane 1 1 2 50.00% 0.00% 50.00% 0.00% 0.00% Kim 1 1 2 0.00% 0.00% 50.00% 50.00% 0.00% Robert 1 1 2 50.00% 0.00% 0.00% 0.00% 50.00% Sarah 3 3 100.00% 0.00% 0.00% 0.00% 0.00% Tom 1 1 1 3 33.33% 33.33% 33.33% 0.00% 0.00%

I want to produce a Matrix cross-tab report, like the above, within Reporting Services. Any suggestions welcome

Many Thanks,

Radha

This is a pretty basic matrix report. Make sure to add a matrix to the layout design and then...

1. add name to row

2. add color to column

3. add name to data and change the expression to count(name.....)

4. add name to data again but to the right of the first one. You will see a light blue/green line appear and then release your mouse. Now you need to change the expression to formatpercent(count(name...))

This should do it.

|||

fsugeiger

Thanks for the above response, but now I am getting 300% for Name, Sarah for the colour Black . I need to show this as the percentage of the "Total by Name" that should = 100%.

For Tom the % should be 33%, not 100% results now:-

Name Black Green Pink Red Yellow Total by Name Black Green Pink Red Yellow Sarah 3 3 300.00% 0.00% 0.00% 0.00% 0.00% Tom 1 1 1 3 100.00% 100.00% 100.00% 0.00% 0.00%

Solution to this would be very welcome, and greatly appreciated, from anyone.

Thanks

Radha

|||Hi , i m currently building a report that will calculate frequencies using a MATRIX .

I have a column that contains multiple groups of answers as you can see in the following screenshot.

In each group of answers i compute the total (calling the subtotal function) .

The problem is that now i want to compute the frequencies for each answer.. So for the first group of answers i want to divide each cell with each corresponding total .

I cant do that at the current moment because the number of answers in each group is diffirent (im using a matrix) and there is no way to know the total because it is computed on the fly.

Is there a way i can do that?

Thnx in advance

Wednesday, March 7, 2012

reporting service

While generating the matrix report Reporting services giveing below
problem.
An error has occurred during report processing Exception of type
'System.OutOfMemoryException' was thrown
If anybody boddy face the same problem pls tell me the sol.It might be the problem such that you have extended the no of columns
in the matrix it can show. I am not sure about the exact count. but
try to run the query on analyser first, check the No of columns and
Rows.second, Create a table in the layout ,drag and drop the values.
Run the preview,Next use matrix and try to Pivot your requiement
(Columns into Rows and Rows into columns) .finally your requirement.
Debug at each and every stage
Thanks
Raj Deep.A
On Apr 2, 5:59=A0pm, nannuri.sr...@.gmail.com wrote:
> While generating the matrix report Reporting services giveing below
> problem.
> An error has occurred during report processing Exception of type
> 'System.OutOfMemoryException' was thrown
> If anybody boddy face the same problem pls tell me the sol.