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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

is it possible to force a "0" when no data found for grouping result

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server

SSRS 2005...

I'm using a table grouped by Region.  My Regions are Central, West, East, and South.  If I query against a dataset that doesn't have any data from the East region, that region doesn't show on the table.  Is it possible to force the East region to show on the table with 0 or "no data"?


View Complete Post

More Related Resource Links

grouping summary data gridview


how can I gruping summary data in gridview like that; Thanks for helping


Car                   Rate 1               Rate 2            Rate 3  

 BMV                 5                          7                       9

                         4                          6                      7


Collapsed Grouping in Data View

I have created a data view that groups data to roll-up common items. The problem is that even though I have the data view group properties set to collapse by default, when the user opens the page, the contents are not collapsed by default.

"Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no def

When i attempt to fill my Crystal Report -named limitler.rpt and it is under the sub-folder Oraburslar of my project -, i get the following error; "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Error in File C:\DOCUME~1\KEMAL~1.ESM\LOCALS~1\Temp\limitler {148B6FE6-D5BE-4BC3-A13A-47CCCB79D78B}.rpt: Unable to connect: incorrect log on parameters." How can i handle this pro? Thanks in advance... Here is how i connect to database to fill the Crystal Report:string database = ConfigurationManager.AppSettings["Database"].ToString(); string password = ConfigurationManager.AppSettings["Password"].ToString();string username = ConfigurationManager.AppSettings["Username"].ToString(); string server = ConfigurationManager.AppSettings["Server"].ToString();ReportDocument report = new ReportDocument();report.Load(Server.MapPath("~/Oraburslar/limitler.rpt")); report.SetDatabaseLogon(username, password); CrystalReportViewer1.ReportSource = report; CrystalReportViewer1.BackColor = System.Drawing.Color.White;

I need a grouping and cumulative sum of data(TFS SSAS Report)

It is a MDX query (TFS Warehouse)     WITH MEMBER [Measures].[Date Value] AS     [Date].[Date].CurrentMember.Member_Value     MEMBER [Measures].[CalculatedRoughOrderOfMagnitude] AS Iif(     [Work Item].[Microsoft_VSTS_Common_RoughOrderOfMagnitude].CURRENTMEMBER IS [Work Item].[Microsoft_VSTS_Common_RoughOrderOfMagnitude].[All].UNKNOWNMEMBER,     2,     2^([Work Item].[Microsoft_VSTS_Common_RoughOrderOfMagnitude].CURRENTMEMBER.MEMBER_VALUE+1)     )   MEMBER [Measures].[ActiveRoughOrderOfMagnitude] AS Iif( [Work Item].[System_State].CURRENTMEMBER IS StrToMember("[Work Item].[System_State].[System_State].[" + @Active + "]") , [Measures].[CalculatedRoughOrderOfMagnitude] ,0 )   MEMBER [Measures].[ResolvedRoughOrderOfMagnitude] AS Iif( [Work Item].[System_State].CURRENTMEMBER IS StrToMember("[Work Item].[System_State].[System_State].[" + @Resolved + "]"), [Measures].[CalculatedRoughOrderOfMagnitude] ,0 )   MEMBER [Measures].[ClosedRoughOrderOfMagnitude] AS Iif( [Work Item].[System_State].CURRENTMEMBER IS StrToMember("[Work Item].[System_State].[System_State].[" + @Closed + "]"), [Measures].[CalculatedRoughOrderOfMagnitude] ,0 )           SELECT {  &nbs

Namespace 'MySql.Data.MySqlClient' cannot be found.

Hey Guys. I'm having some really annoying issue using ADO.NET connector. I've added reference to my project- the file "MySQL.data.dll" Actually, i've copied the file from "MySQL Connector Net 6.2.2\Assemblies" to "MyWebSite\bin" and then added reference. Then, typed "using MySQL.data" and as you can guess, i've got that message: Namespace or type specified in the Imports 'MySql.Data.MySqlClient' cannot be found. What am i doing wrong? thanks ahead  

SQL Compact 3.5 on WinCE5.0 System.Data.SqlServerCe.dll or one of its dependencies, was not found

Hi community, I'm trying to get SQL Compact SP(1, 2) in my NK.BIN (WinCE500, Arm4I). PB builds the image, it boots correctly. On the mobile device, all of these files are present in the \Windows folder: GAC_System.Data.SqlServerCe_v3_5_1_0_cneutral_1.dll sqlceca35.dll sqlcecompact35.dll sqlceer35EN.dll sqlceme35.dll sqlceoledb35.dll sqlceqp35.dll sqlcese35.dll In the registry, these settings are present: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETCompactFramework\Installer] "GACPath"="\\Windows" [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETCompactFramework\Installer\Assemblies\Global] "System.Data.SqlServerCe, Version=, Culture=neutral, PublicKeyToken=3BE235DF1C8D2AD3"=hex(7):\       5c,77,69,6e,64,6f,77,73,5c,47,41,43,5f,53,79,73,74,65,6d,2e,44,61,74,61,2e,\       53,71,6c,53,65,72,76,65,72,43,65,5f,76,33,5f,35,5f,31,5f,30,5f,63,6e,65,75,\       74,72,61,6c,5f,31,2e,64,6c,6c,00,53,79,73,74,65,6d,2e,44,61,74,61,2e,53,71,\       6c,53,65,72,76,65,72,43,65,2e,64,6c,6c,00,00,00,00,00,00 ; Which is \windows\GAC_System.Data.SqlServerCe_v3_5_1_0_cneutral_1.dll System.Data.SqlServerCe.dll [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETCompactFramework\Installer\Assemblies\ROM] "System.Data.SqlServerCe, Version=, Culture=neutral, PublicKeyT

SSRS 2008 - Data Source cannot be found in Preview

Hello; Something weird is happening to me - Never happened before on 100's of reports using Shared Data Sources. I have a Shared data source defined and when I try to preview a new report, I get a message saying that "The data source 'ProjectList' cannot be found" When I created the dataset, I pointed it to the shared data source. I can preview the data when I run my query from query designer, so it's obviously seeing my shared data source. If I use an embedded data source, the report renders just fine. I'm using SSRS 2008R2 BIDS to develop the report - the data source is hosted from a SQL Server 2008R1 database. Anyone ever seens this? How'd you get out of it? ThanksThanks Ron...

ASP.net UPS void wsdl error message 'exception has been raised as a result of client data'


exception has been raised as a result of client data. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol

Void shipment erro message; I can't determine how to resolve error.  at ***

The following is the code for ups void shipment wsdl...

protected void wsdlRate()


RateWSs.RateRequest rateReq = new RateRequest();RateWSs.UPSSecurity rateSecurity = new RateWSs.UPSSecurity(); RateWSs.UPSSecurityServiceAccessToken rateToken = new RateWSs.UPSSecurityServiceAccessToken

e.Result when data source was shaped? - linqdatasource selected event - LinqDataSourceStatusEventArg



How do I handle using e.Result when my datasource was shaped (select new{})? example aspx markup below:

<asp:LinqDataSource ID="ldsMain" runat="server" 
                    Disposition.Substring(0, 2) as Status)"
        onselecting="ldsMain_Selecting" onselected="ldsMain_Selected">    

1) since I shaped, it's an anonymous type right? so what do I cast e.Result to in order to be able to get at the data? 

2) I am thinking of using the selected event to handle some conditional page setup based on whether or not any results were actually found from the main query (the one that is used to bind data to a gridView via this linqdatasource control)... so I need to check for count > 0 and if it is, I need to fill a few dropdown controls based on a few new queries that will essentially be some select dis

Data source name not found and no default driver specified on win xp


Hi All,

I have got a new laptop with I5, windows 7 64-bit and I am trying to run application developed in vb6 which uses DSN connection to connect to the database which is in SQL 2000. Actually I was facing issue "SQL server does not exists" while connecting to the db and I have solved this by running c:\windows\syswow64\odbcad32.exe and configuring dsn through it.

Now I have installed virtual machine windows xp professional sp3 which is 32-bit and when I run my application from VM then I am getting following error -

"Datasource name not found and no default driver specified"

when I go to administrative tools > Data sources(ODBC) then I can see only one driver i.e. SQL server. I configured it but not working..

Can somebody help me on this? I am stuck..

Prabi I can be still better.

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


trying to install sql server2005 on a windows 2003 server box.

getting msg below at the sql server .  i looked at other posts on trying to uninstall  SQL Native Access Client and norton antivirus.  i could never find the snac on the add - remove programs and this server does not have a virus protection program yet.

here's the history of the installs on the server:

wanted to test a 2005 upgrade so:

  1) installed sql server 2000 then sp4 then restored some databases to it - all OK

  2) tried to upgrade to sql 2005 but ran into problems and left it at that.

had a disk drive crash on the d drive so lost the installs but not the operating system

when the drive was replaced, left alone for a while

then wanted to test a straight 2005 install

  1) removed the broken 2005 attempt

  2) removed the 2000

  3) installed 2005 and got the error on the subject line:

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in S

A field or property with the name 'FieldName' was not found on the selected data source


I'm attempting to load a GridView dynamically on a button is pressed.

The gridview has AutoGenerateColumns="True" (set in skin definition) and has a declarative column definitions as follows:

<asp:GridView runat="server"
        SkinID="GridViewDetail" ID="gvReport"
            <asp:TemplateField HeaderText="Date">
                        <asp:LinkButton  OnClick="

Custom "no data found" error on extended cqwp


Hi all,

I'm extending the content by query webpart to handle dynamic query string variables. Yes, I know, it's built in, but I need more than 3 and even just using 3 through the GUI consistently throws errors. And, since I only need them one at a time, it seemed more logical to extend it.

Anyway, I'd like to return an error when whatever is filtered for doesn't return results - or when someone messes with the URL variables and causes an error. But, I don't know how to go about doing that, and googling is only finding information on other kinds of errors people have using the cqwp.

Anyone able to point me in the right direction?


Fast Search 4 Sharepoint 2010 Business Data Connectivity (BDC) - IEntity Could not be found


Hi, I am using Fast for Sharepoint and I have created a simple Employee database in SQL server 2008 and I am trying to crawl this database.

Using Sharepoint designer, I have created an external repository and I have configured it to look at my test database. After trying to crawl this database - I get two successfyul documents crawled - which are just junk documents. And 5 errors.  The errors say:

Error while crawling LOB contents. ( IEntity could not be found using criteria 'Id=2502'. )

I also noticed that if I was to disable "Defaul Action" from the BDC configuration, then I get all successful crawled documents. However, if I click on any of those documents in the search page, then it brings me to "unkown page". 

This makes sense since Default Action (View Profiles) is disabled. Does anyone know how to avoid this error message above without having to disable Defaul Action check box? 

P.S. I can also see that the connection between SQL Server - BDC - SP is working since when I create a user profile page, I can see that data populate.  

Selecting Result from Content Query Wb Part gets Webpage cannot be found Error

I have MOSS 2007 running on Windows Server 2008.

I have added a custom List to a MOSS 2007 site sollection. The List works fine.

I have added a new webpage to the site collection Home page that includes a Content Query Web Part. When the Content Query WP is configured it returns items from the custom List as expected. But when I select one of the result items returned by the Content Query WP, the Browser says "The webpage cannot be found."

Why doesn't the Content Query WP result navigate to a page that displays the List item selected from the results list?

I have 2 items returned in the CQWP results list and both generate the same error when selected.

If I go to the custom List, the items display OK when selected.

The URLs generating the error looks like:

Sorting or Grouping by "External Data" columns secondary fields - only possible for certain value ty


I have a BCS connection to an external system that provides various external data types.

I'm now adding an "External Data" column to a SharePoint list, selecting multiple fields of an external data type to be added as list columns. These fields have different data types, in my case string, DataTime and Boolean.

Editing the list view settings, I can only select the external entity as a whole, or it's Boolean fields for either "Sort By" or "Group By". The other fields are not offered for selection.

Is there any restrictions on which secondary fields of an external data type are supported for either sorting or grouping? Or is there something wrong in the definition of some of the external data type fields?

Thanks in advance for any help on this issue...

How to add Grouping to VisibleTables in Dynamic Data Scaffolding


I am searching for a way to add a GroupBy functionality to the initial list of database tables generated in a Dynamic Data gridview.  I was looking at adding metadata to the individual tables (example below), but I cannot figure out 1.) how the List<MetaTable> VisibleTables could retrieve this information, and 2.) how a GridView could do the correct grouping.  Has anyone seen such a solution?


public partial class Orders { }


public partial class OrderItems { }


public partial class OrderStatus { }


public partial class Customers { }


public partial class ReturnedItems{ }

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