Telerik Forums
Reporting Forum
0 answers
94 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
76 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
182 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
132 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
138 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
3 answers
150 views
Hi,

Is there any way to know when the data processing gets complete? In other words, I would like to know when the report has completed binding its data.

Thanks
Steve
Telerik team
 answered on 19 Nov 2010
1 answer
113 views
My crosstab gives an Avg Rating numerically, is there somehow to show a series of Rating stars in addition or inplace of that?
Peter
Telerik team
 answered on 19 Nov 2010
1 answer
83 views
Ok, lets say in my report I setup a SqlDS which points to a stored procedure

Then inside the Detail portion I drop in a crosstab wizard and a table wizard and link them into the SQLDS

Is the SqlDS being called twice?

I'm running into a problem right now where if I add in the table I go from 3 second report generation to infinite generating icon.

(The DS is 21,000 rows)
Peter
Telerik team
 answered on 19 Nov 2010
7 answers
205 views
I ran into a technical roadblock and wonder if anyone has a solution or suggestions.  Scenario and background as follows:

1.  I'm using Telerik Reporting to generate a number of reports in a web site (built with ASP .Net 2.0) .  I'm not using the report viewer, rather the report is streamed to the user as PDF files from which they can print or save as appropriate.  This is accomplished via the following code sequence (pretty standard technique I believe):

Response.Clear()
Response.ContentType = strMimeType
Response.Cache.SetCacheability(HttpCacheability.Private)
Response.Expires = -1
Response.Buffer =

False
Response.AddHeader("content-disposition", _
"attachment; filename=""" & strFileName & """")
Response.OutputStream.Write(reportBytes, 0, reportBytes.Length)
Response.End()



2.  From the report web page, the user clicks the Generate button to generate a selected report.  As soon as this button is clicked, the mouse cursor turns to an hourglass.  This is accomplished via a simple client-side javascript function that sets the cursor style to hourglass in conjunction with setting the "onClick" attribute for the button Generate, (in page_load event), as follows:

function hourglass()
{document.body.style.cursor =
"wait";}


' This is set in the page_load event of the aspx.vb file
btnGenerate.Attributes("onclick") = "javascript: hourglass();"


3.  In real time, the user clicks the Generate button, the mouse cursor turns to hourglass (by virtue of the client-side action mentioned above) while the report is being generated.  After a period of time, the PDF download dialog appears on top of the report web page.  The user opens the PDF file, prints it and then closes the PDF file.  Everthing works fine up to this point.

4.  Once the PDF file is closed, the report web page is, of course, still there.  The problem is the mouse cursor is still showing the hourglass.

5.  The problem appears to lie in the fact that the cursor is never reset to the default style.  And it appears that there isn't an opportunity to reset the cursor because there isn't a postback to the report web page AFTER the user has printed the PDF file and closes the PDF application. 

I've tried adding client-side javascript to reset the cursor at window.onload.  It doesn't do it because the report web page is NOT reloaded after the PDF file is generated.

I hope this makes sense.  I'd appreciate if anyone has any suggestions.

Thanks.

Barry


 

Steve
Telerik team
 answered on 19 Nov 2010
1 answer
57 views
Is it doable to get an empty data template somewhere in a report section where we can put in something easily when the DS returns no results?...I mean just to make it a bit easier instead of having to always implement some sort of conditional formatting or handle the databound events?
Steve
Telerik team
 answered on 19 Nov 2010
Top users last month
Ambisoft
Top achievements
Rank 2
Iron
Pascal
Top achievements
Rank 2
Iron
Matthew
Top achievements
Rank 1
Sergii
Top achievements
Rank 1
Iron
Iron
Andrey
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?