.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

Repeat Report Item with Data Region on Every Page - doesn't work

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
Hi All, The Repeat Report Item with Data Region on Every Page property does not work - or atleast not the way i would expect it to. My report contains a header which is the Report Name. In the report body - I have text box with the company name, pulled from a data set. Below the company name i have a line, followed by a text box displaying the selected parameters. When I run the report, the first page displays all information as expected. However, subsequent pages only display the report header (report name) with the table butted up against it. I have tried setting the Repeat Report Item with Data Region on Every Page to true (and the data region to my table) for the Company Name text box, the line, and the parameters text box. This has no affect i.e. page 2, page n... are not printing the three items. Any suggestions much appreciated. Thanks.  Clay

View Complete Post

More Related Resource Links

When I use 'publish', site doesn't work when i post data


Arrgghh, I am so tired of dealing with stuff like this

I've got a project, when I put up on another server I point two sites in IIS6 to it

i have

http://www.main.com  pointing to the folder the files are in


http://www.anotherofoursites.com/main pointing to that same folder in it's own "Virtual Application" or whatever IIS calls it when you put a folder into it's own 

If I just "Build" and push all the files up.. both work without issue and as expected...  but when I use "Publish" to precompile, the site works until I post, and then i get nailed with:

Server Error in '/' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Microsoft Report Viewer control to display data on one page


Hello everyone,

I am wondering if the Microsoft Report Viewer control allows for display changes.  Say for instance a user wants would like to see all the data requested then another time would like to toggle thru the pages of infomation.  So does anyone know if the control allows for display changes from complete view to paginated viewing.  I am using MS VS 2008 with ASP.NET 3.0.  Thanks for your response.


Report filters do not work, ALL data is returned

Hello, I'm facing a weird problem with a Report Builder 1.0 report. The report has two filters: a Start Date and an End Date. I have selected the "prompt" property of these filters to use them as report parameters. When I run the report in Test, it runs just fine and shows correct data as per selected filters. When I copy the report to Production, it again runs fine. The problem begins if I try to make any changes to the report in Production. I open the report in RB 1.0 and add another column. When I now run the report, it returns ALL the records in the DB regardless of the Start Date and End Date specified. Strangely, this does not happen when I change the report in the test environment. Any ideas on why this could be happening will be very much appreciated! Thanks, Shivani

2 datasets in one report doesn't work

I have two datasets in one report. They work fine when i put them separately, but in one report only first one works. Second dataset's parameters are calculated on first dataset's parameters. What could be reason of such a behaviour? Please help me, Saikhnaa

MVC doesn't work once is published in the WEB, "Error 404 Page Not Found" vs2010 iis7 mvc 2rc2 I up


Hi Everyone.

 I'm doing the samething in my two differents pc.

1) Windows 7,  vs2010 rc, mvc 2rc2, .Net 3.5

2) Winodws xp, vs2008, mvc 2rc2, .Net 3.5

My Hosting is in GOdaddy IIS 7, .Net 3.5.

I created a new project in both computers, i build it, i copied the 3 dll's files in the bin folder (System.Web.Mvc,  System.Web.Routing, system.Web.Abstractions), and i publish them...., i go to my website (www.luisbragagnolo) both same problem "Page Not Found"

 I tried many blogs...many advices...nothing yet....

 Any other new Advice people? Thankssssssss

Report Model based on Analysis Services Cube doesn't work


Hi all,

I am working in BIDS and would like to create a Report Model based on a cube.

Creating a Data Source based on SSAS goes well, but when I want to make a Data Source View, the earlier created Data Source doesn't show up, which is necessary for the final resulting Report Model.

Could somebody help me out in solving this issue? (And also tell me why this is issue is rising?)


SQL Server 2008 & BIDS 2008 (Version 9.0.3x)

returning data as hyperlink works but doesn't work


Please help. I have a form that searches my database and returns results well but each record contains a cell with a link to another html page. The problem is that whether I place the html pages in the same directory as the .asp codes or in a separate directory with the link being an absolute URL, the action of clicking on the link fails to redirect. Is it possible?

The returns are addresses and the link in each record is to it's own address page with google map.

while running new report, doesn't indicate if previous report preview page is open



i am using asp.net to run the reports from the parameter page.

When i run a report by passing report parameters, the reporting services report opens in the report_preview.aspx page.

 Now, if i do not close this report_preview.aspx page and go to new parameter page and run another report, the report_preview.aspx page doesn't show the new report. It just refreshes the old report.

This can be because, when the run button of any parameter page is executed, it opens the report_preview.aspx page by executing the following query under page_load button.

            ScriptManager.RegisterStartupScript(this, typeof(string), "openNewWindow", "window.open('../Report_Preview.aspx','ReportPreview','scrollbars=yes,resizable=yes,')", true);

But clients get confused for everytime to close previous preview page and open the new report.

IS there any way to handle it please

Is there any way to generate the new ssrs report on the same report_preview.aspx page by refreshing it ( by replacing previous report by the new one) ?


SSRS-2005 Repeat Matrix On Each Report Page

I am using two matrix controls in my report. Both use different data sets. I want the first matrix to repeat on all the report pages. Can someone help me with this? Thank you in advance.

How to access the data item of the current page?


I have a question, is there a "standard" way to access the current data item in the codebehind of a dynamic data page that has the ID in the querystring? (I could get the ID from the querystring and look it up manually but I'm just wondering if there's a built-in function for it so I don't hit the database again for something that's already been looked up?)

I'm customizing Details.aspx so that it shows some child records in addition to the fields on the current record.  (It's a response to a survey - I'm adding the list of questions with the answer for each question.)

I tried something like this but I got an error, Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. 

        protected void Page_Load(object sender, EventArgs e)
            if (!Page.IsPostBack)
                QuestionListUserControl questions = UpdatePanel1.FindControl("QuestionList") as QuestionListUserControl;
                questions.DataSource = (GetDataItem() as SurveyResponse).SurveyResponseAnswers;

Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

Crystal Report Asking for Database Authentication each time when I view Page.


Whenever I open my Crystal Report page, I am taken to the Database Authentication page where I am asked for

User name
Data Name

each time.

Is there a way to avoid this and I save these authentication in my page once.

I am using VS2005, C#.

Any Help will be appriciated.


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

Team System: Work Item Tracking


In this column, Brian Randell explains how to build a simple Work Item explorer and demonstrates the core operations needed to add work item support when building your own add-in.

Brian A. Randell

MSDN Magazine April 2007

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

problem...i want a list item to populate all data in gridview!!!


i have a dropdownbox and a gridview

what I want is to have a list item which populates all data in a gridview.

I have tried using list item selected value=0 but to no avail.

what is the easiest way to achieve this?

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