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

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

RDLC Category

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :ASP.Net
Hi All. Greetings.I wrote this query in RDLCselect * from Tablethen i select Name(category) as Group.It is howing me group wise detail.But one group I don't want to show as group.RDLC. =IIF(Fields!Cateory.Value="Hadi","",Fields!cateory.Value)Event it is showing me result.Ali Hadi  | 2   | 3 Jon    |  4 |  5 Hadi Robi | 2  | 3 Ali    |  4 |  5 Robi Hadi  | 2 | 3 Ali     |  4 |  5 But i want not to show group "Hadi" and result should but bellowAli Hadi  | 2   | 3 Jon    |  4 |  5Robi Hadi  | 2 | 3 Ali     |  4 |  5

View Complete Post

More Related Resource Links

Category attribute of user control property does not work correctly in categories tab.



I have a User Control (ascx) and a property which a want to display in my categories tab in Visual Studio in the category named "Styles".

[Category("Styles"), DefaultValue(""), Description("The value for formating something.")]
public String MyFormatProperty
set { /* the code for set */; }
get { /* the code for get */; }

And here is the problem: Actually I do not need a get, because I only have to set the property (write only property). But when I omit the get, the property is displayed in the "Misc" category in the categories tab in Visual Studio. Only when I code the get as well, then the property is displayed correctly in the "Styles" category in the categories tab in Visual Studio.

Does anybody know why? How can I display the category correctly only with set?

Thanks, S.

RDLC Report Hide Export Option

The article RDLC Report Hide Export Option was added by mandandeo on Sunday, August 15, 2010.

protected void ReportViewer1_PreRender(object sender, EventArgs e) {DisableFormat(ReportViewer1, "Pdf"); }protected void DisableFormat(ReportViewer viewer, string formatName) {const System.Reflection.BindingFlags Flags =System.Reflection.BindingFlags

Unwanted page breaks in rdlc report



I hav a report that has a table group =Fields!Location.Value

and in the cells I do this

=Avg(IIF(Fields!Contaminant.Value = "Element1", cDbl(Fields!Value.Value), cDbl(0)))

what I am getting is 1 row for each location then there is a pagebreak! what i want is the next location right below the  first I looked through for all the page breaks with no luck. Any ideas?

Convert 2005 RDLC to 2008 using VS2010


Hi and thanks.


I'm getting an error on serveral reports that I built  in VWD2005 (express) using the reportviewer control.  Trying to edit the rdlc file in VS2010, VS2010 asks if i want to convert the file to RDLC 2008 format and I click ok.  When I build the site, I get this error (and of course also when the report is ran):


Error 1 The report definition is not valid.  Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. C:\inetpub\wwwroot\mastercardlcm\Reports\WorkLists\OpenSRStatus.rdlc 1 


Here is my web.config concerning the RDLC assemblies, etc.

			<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
		<compilation debug="true">
				<add assembly="Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
				<add assembly="Microsof

how I show category and forum like our forum.asp.net


hi, I would like to make script that show category and all its forum

that 's why I have created table 'cat' ( id , CAT_TITLE )( table for category)

and an other table for forum name ' s 'forum' ( id , name,CAT_ID)

my question how I can show category and the forum  by using repeater or another control like http://forums.asp.net/

Jquery dynamic Category menu


Dear Friends

Im currently developing ecommerce web site. I reffered to some video tutorials in ASP.net website and i managed to develped basic store front for my ecommerce website. I would like give more attractive look to my categories menu using Jquery or ajax. Please someone help me to understand how to apply jquery or ajax to dynamic category menu.

I use web user control to create category menu. This is my code for that.

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="CategoriesList.ascx.cs" Inherits="UserControls_CategoriesList" %>
<asp:DataList ID="list" runat="server" CssClass="CategoriesList" Width="200px">
    Choose a Category
  <HeaderStyle CssClass="CategoriesListHead" />
    <asp:HyperLink ID="HyperLink1" Runat="server"
      NavigateUrl='<%# Link.ToCategory(Request.QueryString["DepartmentID"], Eval("CategoryID").ToString()) %>'
      Text='<%# HttpUtility.HtmlEncode(Eval("Name").ToString()) %>'
      ToolTip='<%# HttpUtility.HtmlEncode(Eval("Description").ToString()) %>'

Adding Totals to RDLC Matrix


I'm using a local RDLC report in VS2008 / .NET 3.5 which includes a Matrix.  It works fine and shows its corresponding Rows, Columns, and Data values as specified.

How can I add row totals / column totals in order to show sum of Data values both horizontally and vertically?

RDLC Rows and colums totals



I want to  show the row totals and column totals in the rdlc matrix. Please let me know how to do this.

For example:

                 2006  2007  2008  2009  Total

A                10      20      30      40       100

B                20      30      10      10       70  

Total          30      50      40      50       170


'System OutOfMemory Exception' while using rdlc in Windows application

hi Everyone , I am Using Reporting Service (.rdlc) in my Windows application , i am getting Error System OutOfMemory Exception Like "an error occured during local report processing An Unexpected error occured in Report Processing Exception of type 'System OutOfMemory Exception'Was Thrown " what to do Please anyone help me ... Advance Thanks Anilmarnal

Nested gridview to show category and forum

hi,I would like to do like this forum http://www.vbforums.com/there is category and under its there are all forum of this category to do that , I create 2 tables in DB cat for category have 2 rows ( id,title) and table forum have 3 rows ( id,title,Cat_ID) I can do it with Php but in asp.net I can'tI read in some article to create  nested gridviewI try but I didn't find solution and thanks

Select Category

Hi All. Greetings.I have 2 Table.Table_Category | ID | Category_Name |   1       Wood   2       IronTable_SubID  |   Catagory_ID  |  Name1   |    1                    | Wood12   |    1                    | Wood23   |    2                    | Iron24   |    2                    | Iron3I want result Like this.Wood             Wood1             Wood2Iron          Iron1          Iron2and If i want to go Further in Sub Category then it will be like this.Wood              Wood1           &nb

Programmatically Generated Reports (RDLC) ASP.NET C#

Good Day,   I been looking for a day now and I couldn't find a good source of information. I have a one of a kind report wherein the RDLC file including all controls are programmatically generated (system generated)  by one of my asp.net page. All fields and its values to be displayed on the RDLC file are coming a stored procedure. On my stored procedure I'm using a temp table for example #MyTable and its columns can adjust programmatically/automatically base on date range. BTW I'm using C# code to generate the RDLC file and preview it on the report viewer of a page. Sample: Date Range: 01/01/2008  to 12/31/2009  My temp table may look like below AssetCode, Description, Class,  Jan2008, Feb2008, Mar2008 --> until column reach Dec2009 AAAA00001, AAAAAAA,FF, 0.00, 0.00,1,00.00 --> some month#### column may not or may contain value base on my formula. AAAA00002, BBBBBBB,FF, 0.00, 1.00,1,00.00 --> some month#### column may not or may contain value base on my formula. AAAA00003, CCCCCCC,CE, 1.00, 1.00,1,00.00 --> some month#### column may not or may contain value base on my formula. I have no problem in retrieving all data on SQL Server using temp table and showing it on a system generated rdlc file even if I'm using

set textbox size dynamically in RDLC

in Hi, Can some one tell me how to set the size and location of the text box in RDLC dynamically. I cannot access it code, i cannot use parameters or expressions to set this. Thanks

Struggling to assign the parameter value for the RDLC report, VS2010

 Struggling to assign the parameter value for the report, I saw so many helps in this forum. seems i have the same error comes again after i click the button. pls help what i miss in the below?   Following is my .XSD (DataSet) SELECT     [Order Details].OrderID, [Order Details].ProductID, Products.ProductName, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount,                       CONVERT(money, ([Order Details].UnitPrice * [Order Details].Quantity) * (1 - [Order Details].Discount) / 100) * 100 AS ExtendedPriceFROM         Products INNER JOIN                      [Order Details] ON Products.ProductID = [Order Details].ProductID <div> <asp:Label ID="lblMessage" runat="server" Text="Label"></asp:Label> <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="OrderID" DataValueField="OrderID"> </asp:DropDownList> <asp:Button ID="Button1" runat="s

RDLC Report Viewer

I want to Export Rdlc Report into PDF format, programmatically. How can i do that, Please help me Thanks in advance Bheemidi.  

Problem Add Category Item by select department

Add Category Item by select department Firstly database has two tables Department and Category Department Table Id -------int  (PK) dep_name--------nvarchar(50) dep_description---------nvarchar(100) -------------------------------------------------------- Category Table Id------int cat_name------- nvarchar(50) cat_description----------- nvarchar(100) IsActive--------bit DepartmentId-----int   (FK) ---------------------------------------------------------- I have form contain DetailsView control under name CategoryDetailsView. My problem: this mechanism not duo correctly I don't know why,  only show to me when I run page" Procedure or function InsertCategory has too many arguments specified. " My idea when a user need to create category must on him write category details ( category name, Description, IsActive) and select this category where to insert by select department name from drop downlist This control connecting with table under name Category, insert process by stored procedure under name sp_InsertCategoryALTER Procedure [dbo].[InsertCategory] (@cat_name nvarchar(50) ,@cat_description nvarchar(100),@IsActive bit , @Result int output)AsBegin Insert Into Category (cat_name , cat_description, IsActive ) Values (@cat_name , @cat_description, @IsActive ) Select @Result = @@IdentityEnd <asp:DetailsView ID="CategoryDetailsView

WebpartToolPart category "Appearance" expanded by default - How to revert this ?

Hi When I create a sharepoint 2007 webpart and attach a custom Toolpart to the webpart it works fine. However, when I go into edit mode the appearance category is always expanded, and I would like it to be collapsed. I have noticed that the Content Query Webpart be default has collapsed all the catgories of the WebPartToolpart. I tried to look through the code in Reflector, but I wasn't able to figure out how this webpart does the trick. I have found that the WebPartToolpart class has and Expand() method, but undfortunately not a Collapse method. Does anyone has the answer to this one ? Best Regards Lars Kohsel, Nykredit Denmark.
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