.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

Add Total Problem while grouping and limiting number of rows in a page

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server


I have a report in which first column is CITY and consists of 5 data (5 cities),all other columns are grouped w.r.t CITY, i.e in one city there can be 100s of other column data, last column of report is INCOME. If I right click on [INCOME] field and select ADD TOTAL then it gives citywise total, but I limited only 10 records per page and pagebreak  option is selected at end of the CITY group. When perform the same operation now it gives pagewise sum not the groupwise, please rectify my approach if I am wrong else suggest the solution.

View Complete Post

More Related Resource Links

Restrict number of rows per page



As I deploy reports, based on the no of records in result set, I get a scroller on the right hand side. How can I disable the scroller? I guess I can disable the scroller by restricting the no of rows being displayed.. eg: show 10 records per page. Any idea how do I set no of rows per page?



Report, Change The Number Of Rows Per Page


I am fairly new to reporting services and recently created a simple tabular report.  There is one table which queries the database and I would like to change the table so there are more than 25 rows of data per page.  How do I do this? 

Also it would be advantageous to know how to set the report to only create a new page for every different item in a column.  For eg if I have various data for each date, I would like to only create a new page when the date changes so that all data for a specific date is on one page etc etc.

Many Thanks

Total page number is always just 1 in BI Preview


Hi, I'm having the same problem here.  I build my report in BI, .net 3.5, and at first it was showing correct total page number in the Preview tab on the top left of the preview content page.  I played around with margins, set table's property 'Keep together' = true....   And now, it doesn't matter how many pages my report generates in only shows total page number as 1.  I can scroll down and see all the rows but they're not broken up into pages.

I then deployed the report to the report server and the same problem there when I select to 'View Report'.  The true and correct total page number only shows up when I select Preview in the Print dialog and it's also correct when I actually prints out the report.

Is this a know bug or is there a way to correct this?  Thank you.

Alpha Davis

Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

WebDev.WebServer.exe has encounted a problem and needs to close when trying to view page in browser


Hi, whenever I load an aspx page in vwde2008, I get the message in the subject of this post.  After I click Ok on that, I get a dialog box, Unable to Connect to the ASP.Net development center.  What can I do to troubleshoot?

I am using Windows XP SP3, vwde2008 with SP1, on a HP desktop.  Also using Office 2003 if that is relevant at all.

Thanks, Justin

page postback problem with crystal report


Hi , i am creating crystal report with asp.net it is working showing data but  data is of two page its is take round trip action but report is not show 
until again i click on show button in this it is not propersly showing that data is how.

<br />
    <asp:Button ID="btnShow" runat="server" OnClick="btnShow_Click" Text="Show Report" />
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" DisplayGroupTree="False" EnableDatabaseLogonPrompt="False" /> CrystalReportViewer1.ReportSource = null; SqlCommand cmd = new SqlCommand(strcmd, c.con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); ReportDocument doc = new ReportDocument(); doc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\rptQuotation.rpt"); doc.SetDataSource(ds.Tables[0]); // login info SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new Tabl

Problem with master page and update panel (I think)



the app I am working with is made up of three nested master pages that have the following design:

The first master page ha only realize the HEADER, BODY and FOOTER divs.

The second one specialize the Body content placeholder and divide it in three more layers: NAVIGATOR, PAGE TITLE, BODY CONTENT.

The final layer specialize the BODY CONTENT in PAGE CONTENT and ACTIONS.

In one of my content pages I have (inside the PAGE CONTENT area) 

  • 1 Update Panel that contains a gridview object
  • 1 Update Panel that contains some HTML code to show in a PopupModalExtender

The PopupModalExtender can be either triggered from inside the gridView and also from a series of LinkButtons that are in the ACTIONS area.

The problem is that when the PopupModalExtender shows the FOOTER and the ACTIONS areas are not dimmed from the style I apply as background to the modal popup. An example of what I am trying to explain can be viewed in the following screenshot.

Why this is going to happen? Has anybody any suggestion on how to solve this problem?

Thanks a lot

Problem when I back to page


Hi Friends

I have page A.aspx where I show some result in listview. When I click On Some data on listview I go to page B.aspx.

Now the problem is when I click on back in page B.aspx it comes to A.aspx with out previous listview result. Ack requirement is when I come to page A.aspx result of listview has to be there. How do i do that?

Could u please help me out?



CSS Problem on ASPX page


I am having a problem with space around a div. The page looks perfect in the VS internal browser, but there is space at the top between the body and the div for the page layout in IE and FireFox. I tried everything I know by setting margins to 0 and padding to 0 for the body, div, form, almost everything and there is still space. The wierd thing is that the space shows the background color when I set the padding for the div#page to 0, and the space is the div#page background color when the padding is set to a value.

I must be missing something. I looked at the page's HTML after it is rendered from the server and it inserts a dive with a hidden control for the viewstate. I thought this might be causing the problem so I set the margin and padding for all divs to 0, but it did nothing.

The code for the simple page and CSS is provided below.

It appears the problem disappears and the page looks as I intended when I use the Compatibility View in IE8.

Thanks for the help in advance,
-- Chris



<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="CSSDemo1.aspx.vb" Inherits="Web.CSSDemo1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/

Suppress Blank Rows in Grouping on SRS

I have a Table on a SRS report.  Within that Table I have a Group. I display Rows from the DataSet in the Group Header.  In the Detail Line of the Group, I display rows if a condition is true.  That condition is in the Filter Criteria (Fields!GroupID.Value > 0).  If the GroupID equals 0, I want to suppress the detail line.  If GroupID is greater than 0, I want to show it.  This works great in development mode within Visual Studio 2005. I deploy to SRS on our Test Server and run the report. All of the detail rows are displayed even the ones where GroupID = 0. I am using the same Data Source.  The only difference is running the report within Visual Studio and the SRS web site. Does anyone have a suggestion.  

Restricting number of rows in a set

Hi All, Is it possible to restrict the number of rows which may come in a set in MDX ? WITH SET set1 AS Order ( { Filter ( [DimContract].[Contract Acc].[Contract Acc].MEMBERS , (NOT IsEmpty([Measures].[Consumption])) OR (NOT IsEmpty([Measures].[SampleSize])) ) } ,[Measures].[Consumption] ,ASC ) Say if i have a set like above , then can we restirct the number of contracts which may come in this set ?

Expand rows in a data grid to show details in the same page

<asp:templatecolumn headertext="Purchase Order"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <%# DataBinder.Eval(Container.DataItem, "PurchaseOrder") %> </itemtemplate> </asp:templatecolumn> <asp:templatecolumn headertext="Order"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <a href="OrderDetail.aspx?Order=<%# DataBinder.Eval(Container.DataItem, "OrderNumber")%>"> <%# DataBinder.Eval(Container.DataItem, "OrderNumber") %> </a> </itemtemplate> </asp:templatecolumn> <asp:templatecolumn headertext="Ack Date"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <%# DataBinder.Eval(Container.DataItem, "AcknowledgeDate") %> </itemtemplate> </asp:templ

Problem displaying a page using window.showModalDialog when resizing it.

 Hi, I have a page that is displayed using window.showModalDialog, when the page is resized the tables, text boxes and everything else that is in the page with the width 100% doesn't resize (fit the page) unless a post back is used.How can I make the page keep everything in proportion when it is resized without the need to post back? 

Problem with cheking the sended parameters on sended page

Hi everyone hope u will help me i have some pages, in my first page have  a repeater with hyperlink and i want to send 2 parameters to another page<asp:HyperLink ID="hp1" runat="server" Text='<%# ". Sayi :"+ Eval("sayi") %>' NavigateUrl='<%# "~/arsivdetay.aspx?cilt=" +Eval("cilt") + "sayi=" +Eval("sayi") %>' ForeColor="#FF6600" Font-Bold="True" Font-Underline="False" Font-Size="12px" /> looks fine here atm but the problem start on sended page cs sideprotected void Page_Load(object sender, EventArgs e)        {                        if (!IsPostBack)                if (Request.QueryString["sayi"] == null)                    Response.Redirect("~/default.aspx");                else                    makalegetir(Request.QueryStri

Export to CSV w/ grouping problem after 2005 upgrade

Hi,After upgrading to reporting services 2005 from 2000, reports that used to export to CSV correctly don't now. It appears the CSV export suddenly stops at a table with grouping. Any ideas would be appreciated...Thanks.

First time facing this problem in aspx page how to solve this..go to now

Hi . We have developed an asp.net application in Visual Studio 2008 with built in crystal report version =10.5.3700.0 , which is working fine in our local server. Our hosting server has crystal report file version =, Which is running on windows server 2008 (x64) with IIS 7. On load my crystal report aspx page am getting the following error. Error in File UNKNOWN.RPT: The request could not be submitted for background processing. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.  Exception Details: System.Runtime.InteropServices.COMException: Error in File UNKNOWN.RPT: The request could not be submitted for background processing. Source Error:  Line 32:         string user = ConfigurationManager.AppSettings["Userid"]; Line 33: Line 34:         crReportDocument.Load(Server.MapPath("CrystalReport.rpt")); Line 35: Line 36:         crConnectionInfo.ServerName = Server1; Source File: d:\inetpub\vhosts\xxxx.com\httpdocs\DT\Default.aspx.cs    Line: 34  Stack Trace:  [COMException (0x800002ad): Error in F

Problem passing a text box value from aspx.cs page to SelectParameters in aspx page

Hi,I would like to take a value from a text box and pass it as a search parameter to my database. I get the value from my code behind page as follows: protected void btn_click(Object sender, ImageClickEventArgs e)      {           AccessDataSource1.SelectParameters["inputValue"].DefaultValue = TextBox1.Text;           string test = AccessDataSource1.SelectParameters["inputValue"].DefaultValue;                      //string inputValue = TextBox1.Text;          //Response.Write(inputValue);         // AccessDataSource1.SelectParameters.Add("@name", inputValue);          //Response.Write(@inputValue);                              } protected void btn_click(Object sender, ImageClickEventArgs e)     {          AccessDataSource1.SelectParameters["inputValue"].DefaultValue = TextBox1.Text;          //An alternate option I have used is          //string inputValue = TextBox1.Text;         // AccessDataSource1.Selec
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