.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

MDX::SUM only distinct values

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server
 
Posted - 09/30/2010 :  13:45:29  Show Profile  Email Poster  Edit Topic  

View Complete Post


More Related Resource Links

"How to get distinct values of sharepoint column using SSRS"

  
Hi,

    I have integrated sharepoint list data to SQL Server reporting services. I am using the below to query sharepoint list data using sql reporting services.

<Query>
   <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
      <Parameters>
         <Parameter Name="listName">
            <DefaultValue>{GUID of list}</DefaultValue>
         </Parameter>
         <Parameter Name="viewName">
            <DefaultValue>{GUID of listview}</DefaultValue>
         </Parameter>
         <Parameter Name="rowLimit">
            <DefaultValue>9999</DefaultValue>
         </Parameter>           
      </Parameters>
   </Method>  
<ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>

By using this query, I am getting a dataset which includes all the columns of sharepoint list. Among these columns, I wanted to display only 2 columns (i.e Region and Sales type) using chart. I have created a Region parameter but when I click

how to distinct values of sharepoint custom list using SSRS (new from http://social.msdn.microsoft.c

  

i hope jin chen would read this.

i followed his instruction from the link above(in the title)

i still got an error message :

System.Web.Services.Protocols.SoapException: An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC42105] Function 'RemoveDups' doesn't return a value on all code paths. A null reference exception could occur at run time when the result is used.’.
   at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetReportDefinition(String Report, Byte[] Definition, Warning[]& Warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.SetItemDefinition(String ItemPath, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2010.SetItemDefinition(String ItemPath, Byte[] Definition, Property[] Properties, Warning[]& Warnings)

could anybody tell me what's wrong?

and by the way,

i'm using ssrs 2008 r2

i use report builder(content type) to create reports from sharepoint lists.

thx in advance.

 

-willy-


Create CSV list by using FOR XML PATH with distinct values

  

My table structure is as follows:

Table Name: CustSpecialty

CustID Spec

1 A,B

1 A,B,C

2 A,B

2 B,C,D

2 A,D

3 A,C

3 A,B

 

I tried "FOR XML PATH" but what Spec I get for CustID=2 is: A,B,B,C,D,A,D. What I want is distinct Specs: A,B,C,D

Same for other Custs.

 

Help appreciated.

 

Thanks,

Manu


How to get distinct values of sharepoint column using SSRS: paramter Greyed out

  

I'm referring to a previous thread: How to get distinct values of SharePoint column using SSRS.  I followed all the steps as set out but when I view my report, the parameter is greyed out.  I then downloaded the example report of Jin Chen.  In that report, he suggests a blank parameter label for the main parameter, as well as, a default value for the hidden parameter (which is different from the initial thread posted).  When I change my report accordingly, I get an error: An error occurred during local report processing. MainParameter.  Anyone with suggestions?


How to bind distinct values to DropDownList from DataSet (as a result of a web service call)?

  

Hi there,

I'm trying to bind a dataset (where the data is coming from a webservice) to a dropdownlist; the problem is that I'm getting duplicates in the list... how can I display distinct values only:

drp_Brand.DataSource = ds.Tables[0];
            drp_Brand.DataTextField = "Brand";
            drp_Brand.DataValueField = "Brand";
            drp_Brand.DataBind();


Thanks!

 


Group two rows together by picking the Distinct Values

  

Hi

There are many duplicate rows on the Table. where I need to pick the Distinct Values.

 

Ref Adur Achg Bdur Bchg TotChg StartBal EndBal

Get multiple values for each distinct username

  

I have a SELECT statement that I save into a temporary table and the return table partly looks like this.

Username | areaName
                 |
zalkin        | blue
zalkin        | red
zalkin        | green
user2        | blue
user2        | green
user1        | yellow
user1        | red

I need to get the areaName as a comma-separated list for each user. The query should return a table like this:

zalkin   |   blue, red, green
user2   |   blue, green
user1   |   yellow, red


How would I do this?
And also, can I do this in my first select statement, before I create the temporary table?

Thanks!

Niklas


wroking on datatable to fetch only distinct values of particular column to assign to dropdown list.

  

As I kept my fetched datatables into session and accessing it on another page there I am

wroking on datatable to fetch only distinct values of particular column to assign to dropdown list.


How to Pass Values Between Web Pages ASP.NET

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

How to Pass Values Between ASP.NET Web Pages

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

jquery autocomplete multiple values

  

i got some samples and i did autocomplete using jquery , its working well for single input values

but i need to pass multiples values after one by one in the textbox. Is it possible to pass multiple

values in the textbox for autocomplete in jquery in asp.net?

 


JQGrid Loading deleted values

  

Hi,

This is quite strange. here is the issue:

Some Info:

1. I'm using a multi-select jqgrid.

2. I have my own delete button to delete multiple orders

The problem:

When i press the delete button on the pager of my jqgrid, the records are deleted from the database but JqGrid shows some records (4-5). On refreshing the grid, correct numbers of records are shown.


Here is the code:


function delorder() {
        var amg = $("#horder").getGridParam('selarrrow');
        var cont = amg.length;
        if (amg.length > 0) {

How to cast integer values as an array of enum values?

  

Hello all!

I'm working with VS2010 Beta2, ASP.NET and Dynamic Data. I'm using VB but will certainly be happy to receive a C# example if necessary. Laughing

I used a few of Steve's examples (Writing Attributes and Extension Methods for Dynamic Data and Dynamic Data - Hiding Columns in selected PageTemplates) to create a custom property attribute to be applied to a dynamic data column and want it to accept an array of enum values (each value will represent a dynamic data page template where this column should not be displayed).  My new attribute works fine when I hardcode it like this, meaning the HideColumnIn attribute is properly populated with the array of enum values:

<HideColumnIn(PageTemplate.List, PageTemplate.Edit)> _
Public Property My_DD_Column As Object

 

However, I want to store the values to be used for the HideColumnIn in the DB as integer values that correspond to the

Passing values in pages

  

Hi! Friends..

how to pass the value from one page to another page in asp.net  with out Using State Management Concepts?

Like 1. cookies

        2.Session

        3. QueryStrings

     With out using the above should pass the values...


how to bind Dropdownlist based on textbox values

  

hi

I have one drodownlist which show data based om textbox values...

Let us consider i have 

Select Name from table1 where Type IN(@typ)

here @typ is textbox values

here for example textbox will have some thing like this L1,L2,L3..

How to filter Name based and shown in drodownlist based on this L1,L2,L3(on textbox)..

Help me in this


Unable to get all the values from a field

  

Am reading an XML from web service and storing in  a dataset. 
then in write to a DataTable as follows

 DataTable dtResult1 = dsSearch.Tables["RESULTSET"];    
 DataTable dtHIT = dsSearch.Tables["HIT"];     
 DataTable dtField = dsSearch.Tables["FIELD"]; 

The issue  is  in the DataTable dtField i can only see 3 columns FieldID,Name,HIT_ID

The corresponding values in the dataTable looks like this for the corresponding fileds

0,rank,0
1,internalid,0
2,contentid,0
3,contentids,0
4,collection,0 

I am unable to get the Field Name values 1,8799f4646b6ed9acde142581a84f75a6 ,234B5F5F-F247-4EB6-9E39-A7B64C7FE1BD,Yes...etc

What would be the cause for this...Any Help

Below is the structure of the XML-


- <RESULTSET FIRSTHIT="1" LASTHIT="10" HITS="10" TOTALHITS="46" MAXRANK="3159" TIME="0.0040"> 
- <HIT NO="1" RANK="2955" SITEID="0" MOREHITS="0" FCOCOUNT="0"> 
<FIELD NAME="rank">1</FIELD> 
<FIELD NAME="internalid">8799f4646b6ed9acde142581a84f75a6 </FIELD> 
<FIELD NAME="contentid">234B5F5F-F247-4EB6-9E39-A7B64C7FE1BD</FIELD> 
<FIELD NAME="contentids" /> 
<FIELD NAME="collection&

Retreiving XML tag values

  

Hi,


I'm new to xml.


Currently I'm using the SOAP service and MSXML2.ServerXMLHTTP40  to get data from a website.

To retrieve data I'm using the "responseText" method of the MSXML2.ServerXMLHTTP40 class.


My XML tree looks like this. ( part of the tree)


<dataID>0</dataID>
<projectName>100208_FC3_BY_RO_rza</projectName>
<chunkSize>0</chunkSize>
<minLat>47.8512912</minLat>
<maxLat>48.2469535</maxLat>
<minLong>11.6839167</minLong>
<maxLong>12.4439732</maxLong>
<minTimestamp>2010-02-03T10:58:29</minTimestamp>
<maxTimestamp>2010-04-09T10:05:22</maxTimestamp>
<imageCount>154282</imageCount>
<audioCount>0</audioCount>
<gpsCount>84475</gpsCount>
<mcvCount>2475</mcvCount>
<fileCount>87</fileCount>
</JobInfo>


Just need to retrieve the value of the "projectName" & "dataID" from this.

Appreciate if somebody can help me to get the values of the above 2 fields with the relevant code.


Thanking you in advance.


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend