Telerik Forums
Reporting Forum
0 answers
35 views
I have use crystal report long tme for win form.
Now I move to web and I use Telerik reprorting. So I am a beginner.
I was searching but I can't figured out how can make report like this was made by crystal report.
ken
Top achievements
Rank 1
 asked on 23 Nov 2010
2 answers
101 views
I have not had a chance to review the drill down capabilities of Q3 yet, but the biggest question I have is whether or not the expand event allows me to load the next level down of data on demand.  In otherwords, can I initiate another data call at the time the expand event is triggered and get just the data for the item that has been expanded.

I do not want to load all data for all levels at time of render.  Only as needed.

Thanks,

Terry Webster
Terry Webster
Top achievements
Rank 1
 answered on 22 Nov 2010
5 answers
176 views
I am experiencing an issue with Multicolumn reports displaying incorrectly in the web viewer.

I created an avery zweckform report, bound it to a stored procedure, witgh parameters and was able to successfully test the report in the preview and so forth with the report displaying perfectly.

I thn transferred this code to a web application and have successfully got the report to display , however it is only displaying a single column (with the correct reults and so forth).

When I print this using the print , I get the correct multicolumn report.

I jhave checked that the page style and so forth aren't being interfered with

am I missing an option  for the display.

note I have not set zoom width or Zoom Mode
Peter
Telerik team
 answered on 22 Nov 2010
7 answers
479 views

I'm using Telerik Report Q1 2009 and would like to know the best way to populate this report with xml data?
I'm using VS2008, C# and Oracle as my back end.
Within the report I'm not sure also how to reference it once the xml is passed in?

I tried the following

ReportXML rXML = new ReportXML();  
rXML.DataSource = "<XmlDS><table1><col1>Value1</col1></table1><table1><col1>Value2</col1></table1></XmlDS>";         
rvFreqReport.Report = rXML;  
rvFreqReport.RefreshReport(); 
Within my report I added a textbox and set it's value equal to =xmlds\table1\col1 to get the value for column 1.  It doesn't work correctly.  Should just see
Value1
Value2
within my report.

Thank You
Francis Frank
Top achievements
Rank 1
 answered on 22 Nov 2010
0 answers
128 views
How can I draw line at the detail part of report like "Crystal report"
and
How can I use something like "Record Number" on Table binded datasource.

Thanks!
ken
Top achievements
Rank 1
 asked on 22 Nov 2010
0 answers
85 views
Hi team,

  • I am not clear mechanism of "Stop If True" in conditional formatting dialog. Could you please explain how does it work or show me a link which help me understand.
  • Please take a look on my attached file, I have 3 rules and my question is: What will the background colour of "Store_Name" and why ? Many thanks.

Regards,
Minh Tam.
Tam Pham
Top achievements
Rank 1
 asked on 22 Nov 2010
1 answer
70 views
If we know the Page Size...and each page has a footer...

Could you not use html absolute positioning to dock the footer to the bottom of the "page" in the html viewer?  I have this nicely formatted report but the footer keeps smashing itself up to the bottom of the content instead of the bottom of the page in the viewer (PDF looks exactly as I need it though)
Steve
Telerik team
 answered on 22 Nov 2010
2 answers
171 views
Hi There,

I'm currently building a Report showing user data by calling a LINQ Function through a .dll and setting my Datasource accordingly for the Report. Everything works fine in the Details area of the report, but it's the Report Header area I am having some problems with.

My function is pulling Employee Information from the Database and displaying the info for the "selected" employee. This displays all of the information on the selected employee in the Details area of the report. But since the Report doesn't know that it's Datasource is only selecting for ONE employee, it copies the data to each page of the report.

For instance; If the selected employee has 12 records in the database, those 12 records are displayed, and then displayed again on every page for another 12 pages. Making my report 12 pages longer than it should be.

Is there a built in Function that I am missing in the Report to tell a Textbox to only display one record?

Best Regards,

Landon
Landon
Top achievements
Rank 2
 answered on 19 Nov 2010
1 answer
127 views
I am using a Pie Chart from Telerik Reporting Q2 2010 and would like to change the numeric values it used to create the pie slice with a percentage concatenated with an identifier.  The datasource is a SqlDataSource and I'm using the ItemDataBound event to set various items.

There are two columns in the datasource a TotalCost and Product column.  

I've tried setting a variety of different properties but to no avail.

Chad
Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound


       Chart1.Series(0).DataYColumn = "TOTALCOST"
        Chart1.Series(0).DataXColumn = "PRODUCT"
        Chart1.Series(0).DataLabelsColumn = "PRODUCT"


    End Sub
    Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound


        Chart1.Series(0).DataYColumn = "TOTALCOST"
        Chart1.Series(0).DataXColumn = "PRODUCT"
        Chart1.Series(0).DataLabelsColumn = "PRODUCT"


    End Sub
    Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound


        Chart1.Series(0).DataYColumn = "TOTALCOST"
        Chart1.Series(0).DataXColumn = "PRODUCT"
        Chart1.Series(0).DataLabelsColumn = "PRODUCT"


    End Sub
    Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound


        Chart1.Series(0).DataYColumn = "TOTALCOST"
        Chart1.Series(0).DataXColumn = "PRODUCT"
        Chart1.Series(0).DataLabelsColumn = "PRODUCT"


    End Sub
    Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound


        Chart1.Series(0).DataYColumn = "TOTALCOST"
        Chart1.Series(0).DataXColumn = "PRODUCT"
        Chart1.Series(0).DataLabelsColumn = "PRODUCT"


    E

Private
 Chart1.Series(0).DataYColumn = "TOTALCOST"
        Chart1.Series(0).DataXColumn = "PRODUCT"
        Chart1.Series(0).DataLabelsColumn = "PRODUCT"
Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound


        Chart1.Series(0).DataYColumn = "TOTALCOST"
        Chart1.Series(0).DataXColumn = "PRODUCT"
        Chart1.Series(0).DataLabelsColumn = "PRODUCT"


    End Sub
Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound


        Chart1.Series(0).DataYColumn = "TOTALCOST"
        Chart1.Series(0).DataXColumn = "PRODUCT"
        Chart1.Series(0).DataLabelsColumn = "PRODUCT"


    End Sub
Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound


        Chart1.Series(0).DataYColumn = "TOTALCOST"
        Chart1.Series(0).DataXColumn = "PRODUCT"
        Chart1.Series(0).DataLabelsColumn = "PRODUCT"


    End Su
Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound


        Chart1.Series(0).DataYColumn = "TOTALCOST"
        Chart1.Series(0).DataXColumn = "PRODUCT"
        Chart1.Series(0).DataLabelsColumn = "PRODUCT"


    End Sub
Private Sub Chart1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Chart1.ItemDataBound


        Chart1.Series(0).DataYColumn = "TOTALCOST"
        Chart1.Series(0).DataXColumn = "PRODUCT"
        Chart1.Series(0).DataLabelsColumn = "PRODUCT"


    End Sub
Peter
Telerik team
 answered on 19 Nov 2010
1 answer
128 views
Hello,
I'm currently facing problem loading the report (using silverlight viewer) in the old way I did on Q2... I need to load the report when the user passes 2 parameters and click a button

here's my code...

private void btnCarica_Click(object sender, RoutedEventArgs e)
  {
      LoadRendiconto();
  }
 
  private void LoadRendiconto()
  {
      reportViewer.Visibility = Visibility.Visible;
      //tbErrore.Visibility = Visibility.Collapsed;
 
      if (dtPicker.IsDateValid() && ucRapporto.RapportoSelezionato != null)
      {
          reportViewer.Height = double.NaN;
          var reportViewerModel = reportViewer.DataContext as ReportViewerModel;
 
          Telerik.Reporting.Service.Parameter paramRapporto = new Telerik.Reporting.Service.Parameter();
          paramRapporto.Name = "Rapporto";
          paramRapporto.Type = typeof(int).FullName;
          paramRapporto.Value = ucRapporto.RapportoSelezionato.IDInterno;
 
          Telerik.Reporting.Service.Parameter paramData = new Telerik.Reporting.Service.Parameter();
          paramData.Name = "Data";
          paramData.Type = typeof(DateTime).FullName;
          paramData.Value = dtPicker.SelectedDate;
 
          //  parameters.Add(paramUser);
 
          if (reportViewerModel.Parameters != null)
          {
              reportViewerModel.Parameters.Add(paramRapporto);
              reportViewerModel.Parameters.Add(paramData);
          }
          // if (reportViewerModel.ApplyReportParametersCommand.CanExecute(null))
          reportViewerModel.ApplyReportParametersCommand.CanExecute(null);
 
          //if (!IsFromHistory)
          //    AddItemToHistory();
 
          SetHeader();
      }
      //else
      //{
      //    reportViewer.Visibility = Visibility.Collapsed;
 
      //    tbErrore.Visibility = Visibility.Visible;
      //}
  }

here's the Report Loaded event

private void Report_Loaded(object sender, RoutedEventArgs e)
      {
          this.reportViewer.RenderBegin += new RenderBeginEventHandler(reportViewer_RenderBegin);
 
          if (IsFirstLoad)
          {
              
 
              ucRapporto.PropertyChanged += new System.ComponentModel.PropertyChangedEventHandler(ucRapporto_PropertyChanged);
 
              if (IsFromHistory)
              {
                  ucRapporto.ForzaLostFocus();
              }
 
              SetFirstLoad(false);
          }
      }

can you please provide me a sample where when I click on a button it calls a report with 2 parameters?
Thanks..... as far as I've seen the BeginRender event is not fired when I click the button (it was done in the previous version when it calls reportViewerModel.ApplyReportParametersCommand.CanExecute(null);)

Thanks
Paolo
Steve
Telerik team
 answered on 19 Nov 2010
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?