Telerik Forums
Reporting Forum
5 answers
250 views
Hello,

I have created a report with few parameters for filtering the report data. There is one parameter drop-down which needs to be filled as per choice made in the other parameter drop-down. For example, one drop-down is for 'Subject' and the other is for 'AreaOfSubject'. Now I want 'AreaOfSubject' to be filled as per the choice made in Subject drop-down. I am filling both the drop-downs with the business logic.

Would you please suggest the way it can be achieved?

Thanks and regards,
Deepak Saboji
Steve
Telerik team
 answered on 10 Jan 2012
1 answer
91 views

Hi all!

I'm trying to view the datasouce source of theTelerik  Cross Tab example  ie. productSalesDataSet but when i try to configure... so as to view after "Edit in DataSet designer..."

 i get the error below.

 

Failed to open a connection to the database.

"This server version is not supported. You must have Microsoft SQl Server 2005 Beta 2 or later"

Change connection and try again.

 

I have SQL server 2008.

 

Can someone send the the query used in the productSalesDataSet so i can have a look. I think after i've seen it i'llget my crosstab to work

 

thnx so much.

Steve
Telerik team
 answered on 10 Jan 2012
2 answers
176 views
I'm trying to print a 4-detail per page report in a special paper (139mm x 304mm).

First it was working trying it using native printing but it was a problem when I tried to print it in a network printer it was HUGE (every page was more than 165MB) and it was very slow. I solutioned this with this thread:
http://www.telerik.com/community/forums/preview-thread/reporting/telerik-reporting/printing-problem-with-reportviewer-in-silverlight.aspx 

But now I'm having problems with margins. I setup the page with no margin and it is the same size than the page... but it leaves top, left, right and bottom margins...

I don't know what to do... any suggestion?
Fernando
Top achievements
Rank 1
 answered on 10 Jan 2012
3 answers
113 views
Hi
i am working with telerik reporting on vs 2008
i have a problem with it,
when that i want see data explorer or report explorer menu it does not show,i right click on report surface & select view menu & it's sub menus 
but didn't show,i install silverlight3 on vs2008 now inactive telerik reporting
plz help me.
thanks
Massimiliano Bassili
Top achievements
Rank 1
 answered on 10 Jan 2012
1 answer
83 views
Hi,

I would like to show an image on each row by using picture box and show some info when the cursor move on it (like a tooltip). Is it possible? If so, how to do it.

thanks a lot.
Steve
Telerik team
 answered on 10 Jan 2012
7 answers
1.1K+ views
Thanks
Steve
Telerik team
 answered on 10 Jan 2012
8 answers
466 views
Hi,

I'm experiencing quite some difficulty getting a subreport to act on the master report's parameters. I'm using the lastest TelerikReporting version 3.0.9.311 (Q1 2009).

I have the following setup: 2 reports, one to act as master (named KeyFigures), one included as sub report (named ChartSubReport).
Both have parameters "CompanyID" defined as Integer with a default value set to 1 (via designer).
The subreport item is set to pass the master report parameter thus: [=Parameters.CompanyID] (also via designer).

I want to pass the companyID from Session to both master report and subreport.

I use NeedDataSource event for both reports to populate the data:

private void Chart_NeedDataSource(object sender, System.EventArgs e) 
    string strCompanyID = this.ReportParameters["CompanyID"].Value.ToString(); 
// The above always gives the default parameter value in the sub report, but correct in the master report 
// ... 

When execution of NeedDataSource events, the master report has the correct value passed from Session. The subreport however keeps the old default value regardless. I have tried to programatically set this value in different ways but no different result.

The Web report viewer is initialized on Page_Load event like this:

Sunscape.TKS.Reports.KeyFigures report = new Sunscape.TKS.Reports.KeyFigures(); 
report.ReportParameters["CompanyID"].Value = Session["intCompany_ID"]; 
 
Telerik.Reporting.SubReport subReport = report.Items.Find("chartSubReport", true)[0] as Telerik.Reporting.SubReport; 
subReport.Parameters[0].Value = Session["intCompany_ID"]; 
this.ReportViewer.Report = report;
 

this shows I even try to programatically set the subreport's CompanyID, but it is not taken into account when NeedDataSource is fired for the SubReport. I know by forcing an exception to be thrown in both NeedDataSource handlers, that the master report's NeedDataSource event is fired first, and the subreport's second.

The above works for the master report which displays the correct data, but the sub report does not. It has the default parameter value of "1" regardless. Why is this?

I have browsed the forums and tried to follow any examples but none I have found address this exact problem. The best suggestion I have found is the above attempt by programmatically set the parameter before loading the report in the viewer.

Since it does not work this way, what is the correct way of forcing the sub report to get the value from the master report?


kind regards,
Ernst Sognnes
Patrick
Top achievements
Rank 1
 answered on 10 Jan 2012
2 answers
333 views
i have been struggling, googling and searching my problem to no avail.

i am using reporting v5.3.11.1116  for exporting a chart. The axis are dates. I have played around with autoscale and setting step and label step, min value, and max value.

However, it seem to get the same result: The line is constructed and scaled properly, but the x-axis labels are always spaced evenly apart even when the time between points is varied.  Please see my attachment.

You will notice that one major tick is 2 months, but the next is 12 days. It conitnues like that.

Here are some of my current settings that wil not work.

            chart1.PlotArea.XAxis.MinValue = dataSeriesDisplayChartViewModel.DataSeriesDisplay.SelectedStartDate.AddDays(-1).ToOADate();
            chart1.PlotArea.XAxis.MaxValue = dataSeriesDisplayChartViewModel.DataSeriesDisplay.SelectedEndDate.AddDays(1).ToOADate();
            chart1.PlotArea.XAxis.Step = (chart1.PlotArea.XAxis.MaxValue - chart1.PlotArea.XAxis.MinValue)/10;

           this.chart1.PlotArea.XAxis.Appearance.LabelAppearance.Position.AlignedPosition = Telerik.Reporting.Charting.Styles.AlignedPositions.Top;
            this.chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 45F;
            this.chart1.PlotArea.XAxis.Appearance.MajorGridLines.Color = System.Drawing.Color.Gainsboro;
            this.chart1.PlotArea.XAxis.Appearance.MajorGridLines.EndCap = System.Drawing.Drawing2D.LineCap.Flat;
            this.chart1.PlotArea.XAxis.Appearance.MajorGridLines.PenStyle = System.Drawing.Drawing2D.DashStyle.Solid;
            this.chart1.PlotArea.XAxis.Appearance.MajorTick.Color = System.Drawing.Color.Black;
            this.chart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = System.Drawing.Color.Black;
            this.chart1.PlotArea.XAxis.Appearance.ValueFormat = Telerik.Reporting.Charting.Styles.ChartValueFormat.ShortDate;
            this.chart1.PlotArea.XAxis.AutoScale = false;
            this.chart1.PlotArea.XAxis.AxisLabel.Appearance.Visible = true;
            this.chart1.PlotArea.XAxis.AxisLabel.TextBlock.Appearance.TextProperties.Color = System.Drawing.Color.Black;
            this.chart1.PlotArea.XAxis.AxisLabel.TextBlock.Appearance.TextProperties.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.chart1.PlotArea.XAxis.AxisLabel.TextBlock.Text = "Observation Date";
            this.chart1.PlotArea.XAxis.AxisLabel.Visible = true;
            this.chart1.PlotArea.XAxis.DataLabelsColumn = "ObservationDateOADate";
            this.chart1.PlotArea.XAxis.IsZeroBased = false;


how do i get the x axis labels to display evenly spaced out values. It is okay if the labels do not match up with the points. For example, a data point on 1/15/12 could be by the actual label of 1/12/12.  we are printing out a separate report for the raw values in a different report.
Robert
Top achievements
Rank 1
 answered on 09 Jan 2012
1 answer
89 views
do the minor gridlines or tick marks appear on the X axis? If so, how?

i have this code, but still nothing appears, only the major lines.

my xaxis is a date value

            
chart1.PlotArea.XAxis.Appearance.MinorGridLines.Color =
Color.Black;<BR>           
chart1.PlotArea.XAxis.Appearance.MinorGridLines.EndCap =
LineCap.Flat;<BR>           
chart1.PlotArea.XAxis.Appearance.MinorGridLines.PenStyle =
DashStyle.Solid;<BR>           
chart1.PlotArea.XAxis.Appearance.MinorGridLines.Visible =
true;<BR>           
chart1.PlotArea.XAxis.Appearance.MinorTick.Visible =
true;<BR>           
chart1.PlotArea.XAxis.Appearance.MinorTick.Color = Color.Black;
Elian
Telerik team
 answered on 09 Jan 2012
1 answer
442 views
Hello,

I want to set a textbox with the next formula
[= "Date of " + Parameters.CALCDATE.Value]

For CALCDATE = '04/11/2011' The result is:

Date of 04/11/2011 00:00:00

The desired result is

Date of 04/11/2011

Format string is set to {0:d} but it does not work properly.
Instead I tried with

[="Date of" + Format({0:d}, Parameters.CALCDATE.Value)]

And it does not work either (it throws an error).

How can I set the format to this date?

Thank you very much.

Sergio.
Steve
Telerik team
 answered on 09 Jan 2012
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?