.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

Graph messes up subreport?!?

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
Hello all, I'm using the built in graphs in SSRS 05. The report has a graph on top and a subreport below. The subreport contains the detail for the graph this way it displays like a Data Table in Excel. The report is 18 pages, displaying one page per department. The parameter for the subreport is the department number. For some reson I get "Error: Subreport could not be shown" on six of the pages. The graph on top displays correctly though?.. If I delete the graph and render the report with only the subreport I do not get any errors. Any ideas on what could cause this? Thank you in advance - Lee

View Complete Post

More Related Resource Links

using reflection to emit properties to the top of the entity graph


I've got a class

  public class Criminal

public HouseholdMember[] LiedAboutFSHousehold { get; set; }

      public HouseholdMember[] FoodstampTrafficingHousehold { get; set; }
HouseholdMember inherits Person, as do many other classes.  

  public class HouseholdMember: Person


What I&#

Giving Custom Colors for Graph values in SSRS2000


Hi All,

        I am stuck here with the color for the graph values i want to give custom colors for each values present in the graph, is it possible in SSRS2000.

 Problem Statement : Suppose if i want to display two data fields as bar graph

                                 Data Fields are : Vegetable Count and Fruits Count

                                          I want Vegetable count to be in Blue Colour and I want Fruits count to be in green colour.

Any help would be appreciated.

Thanks in advance.

Anish Shenoy

SSRS 2008 Graph Type?


Greetings -


I am required to plot the following graph in an SSRS report.


Sum of Total Credits to be shown on Positive side and total sum of Debits for a month on negative side. I have created a query which retrieves all the expenses for the month and sums them up before feeding the same to the graph for plotting. Both values returned are positive integers.


(Sorry for the diagram below, i tried to paste an image but it didn't work)

Linked Report Subreport- Error: Subreport could not be shown on SSRS 2008r2

I've got 2 folders: /Finance /Japan In the Finance folder I have a Sales report that has 3 subreports, and a salesregion parameter. I created a linked report in /Japan to /Finance/Sales, hide the salesregion parameter, and set the default to Japan, so they can only see their region's sales data. But when a Japan user runs the Sales report, they get Error: Subreport could not be shown because they do not have access to the /Finance folder. Any ideas?

VS2010 Reportviewer - subreport - web server

Hi all,I have ASP.NET web application(vs 2010). I'm trying to use subreport with reportviewer. The report is working with my machine, it returns both the main and sub report. But when I deplyed to web server, the main report display, but not the subreport and no error indicate. I did something like this with VS2005 and deployed to web server without any problems. Here is my coding:Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load      Dim ReportViewer1 As New ReportViewer        Dim rptDataSourceMain As New ReportDataSource("dsSRC", GetDataSet("p_SRC_completed_main").Tables(0))        With ReportViewer1            .ProcessingMode = ProcessingMode.Local            .AsyncRendering = False            .LocalReport.ReportPath = "content\SRC.rdlc"            .LocalReport.DataSources.Clear()            .LocalReport.DataSources.Add(rptDataSourceMain)        End With        ' HANDLE the sub-report        AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf SetSubDataSource        ReportViewer1.LocalReport.Refresh

SSRS 2008 Having more than one subreport changes output

I have a master report which has a list control.  The list contains employee header information.  I have ticked the option to have a page break between each instance of a group on the details group properties page as i want each employee on a seperate page. There is no grouping on the list other than the default details.  I have two sub-reports which are linked to the main report by an employeeID.  When i add the first sub-report it displays the header and associated detail without a problem.  When i click on the next record it shows me the correct next employee header and the correct associated details.  However, when i add the second subreport to the list and review it, the first record shows okay, but when i click on next all the header information is gone - when i then click on previous to show the previously ok record - all the header for that record has now gone.  It doesn't matter which subreport i use as the first one on the master - it happens in exactly the same way as soon as i add the second subreport to the list control.  This is a vitally important report and i am now starting to get very frustrated as i cannot easily see a solution.  Your help would be most appreciated.  Barry  

Parameter passing from masterreport to subreport

what If I'm passing a parameter which is null ?? and if the parameter is an integer? My subreport query is : SELECT    ...FROM ... WHERE ... and (CRMAF_FilteredContact.ownerid = @ownerid  OR @ownerid IS NULL) ORDER BY CRMAF_FilteredContact.OwnerIDname When I try it with a null value in the subreport, it works fine, but when I try it from  the main report, so I tried to remove the ownerid parameter, I tried to put it at blank, I tried to put NULL but I've always an error, the report start fine but then, on the total, i've the error "error subreport could not  be shown". I've the error : [rsErrorExecutingSubreport] An error occurred while executing the subreport subreport3: One or more parameters required to run the report have not been specified. But then I don't know how to fixe it.  I put the @ownerid as blank, but obviously it doesn't like it. I've done that because i'm using the same sub report above but grouping with this parameter. How can I manage this ? Thanks a lot,  

Formula on Main Report Using a Field from Subreport

Hi, I try to use a value coming from a cell which contain a subreport. I need to create a formula using this value. So I tried : =Code.CalcPct(CountDistinct(Fields!s_contactsvisited.Value), Globals!CALL_SubReport) But I've an error: [rsRuntimeErrorInExpression] The Value expression for the textbox textbox9 contains an error: Specified argument was out of the range of valid values. Thanks for you help,      

How to read the value of textbox in table1 of subreport

I have a report which has subreport in it. the textbox5 has a countrows() function hooked and i want to =sum(Subreport1.table1.textbox5.value), is it possible. subreport control is pointing to childreport.rdlchildreport.rdl has - Table1 and textbox5 Thank you very much for the info.

Line graph in .rdlc

Hi ALL,             I have to desing line chart graph in .rdlc report, can you please help me, i have decimal values on Y-Axis and date time values on X-Axis , i have two series of product, according to product value during specific time i need to display line graph for each product.please do needfull to me.

SSMS 2008 & Activity Monitor's Processor Time graph is disabled

Hi,I just upgraded one of my SQL 2005 clusters to SQL 2008 with CU9.  Now, when I connect to it with SSMS, either from my workstation or directly on a cluster node, the % Processor Time graph in the Activity Monitor screen is disabled.  The other three graphs are fine.  If I connect to a different SQL 2008 server, the % Processor Graph is fine.  I don't see any errors in any app event log.  Has anyone else seen this behavior?Thanks!

Bar-graph style - how to keep columns in relative height of size of "graph"

Hi, I need some input for this and imagined that someone else had seen something like it: I have a box, let's say a grid, where there are some bars in it. These bars could be rectangles in a ItemsControl. The grid has a fixed height and width - but the rectangles' height (and width) are set a from a collection of numbers. These numbers go from 0 to 200 - but in periods the numbers only go from 1 to 10. If I use absolute numbers, the rectangles will be tiny in height or width if the numbers are between 1 and 10 and the Grid is 200 in height and width. How do I make the size of these rectangles relative to the tallest one? I guess I could do some calculations 'behind the scenes' in code, but is that really necessary? Is there no other way? Thanks! --Anders

Creating Matrix report to show totals, need subreport to show details...

I've created a perfect matrix report using the nifty wizard and it's exactly what the client wants, but they would also like to see the detail for each row. I'm able to create subreports and pass parameters and all that jazz, but I'm having a hard time setting up a subreport for this matrix. It's pretty much this format                      MakeOfCar                      ModelOfCar LotLocation   Count of cars   This would return:                         Ford           Ford                        Mustang      F150 Location A:         5                0 Location B:         2                3    

Problem in Visualisation of graph

HI all, I have to create a graph like below I want data in this format as below   | |                                           b________                 b________ |                   a_____                               a________ |_____________________________________________ 0      1           2      3              6               7                  24 time   X- axis -- Time Y - Stand jsut for single name.showing dotted but consider as simple y axis. Name A suppose to perform two work a,b and he perform a in 2Am to 3Am while b in 6 Am to 7 Am,now i want to create the bar chart as above please suggest how to do.   but after doing some work aro

how to create rdlc subreport

Hi can any body tell me that how can we use multiple subreportsi m using single dataset to fill sub reports , and single data adapter objdataadapter , the problem is that the code is showing one sub report at a time but i have multiple sub reports, here is the snippet of two subreports , where is the mistake ,  at 2nd subreport  its showing "Report cannot be shown".void SubreportProcessingEventHandler(object sender, SubreportProcessingEventArgs e) { ReportDataSet RD = new ReportDataSet(); switch (SwitchSubReport) { case 1: { e.DataSources.Add(new ReportDataSource("ReportDataSet_SubReportAuditor", RD.Tables["SubReportAuditor"])); objAdapter.Fill(RD); SwitchSubReport = 2; break; } case 2: { BindingSource CheckListBS = new BindingSource(RD, "SubReportCheckList"); e.DataSources.Add(new ReportDataSource("ReportDataSet_SubReportCheckList", CheckListBS )); objAdapter.Fill(RD)

How to graph a Load Test Result manually


I was wondering if you have a plugin or list of scripts that I use if i will manually generate graphs and reports from a Load Test result.

1) Webtest Elapsed Time vs Load Test Elapesed Time

2) Key Indicators
* Pages/Sec
* Avg. Page Time
* Errors/Sec
* Threshold Violations/Sec
(It's Min, Max and Average)

3) Page Response Time (It's Min, Max and Average)


Graph vizualisation?


hi all!

do you know if Miscrosoft has made a graph vizualisation control like MS Chart?

I believe it does not matter if it is for win or web, if it is able to geneate bitmap/png.

I am aware of Microsoft Automatic Graph Layout - but it is not perfect as MS Chart is!


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