Hello!

I did the sending of data to the parameter of the SQL procedure worse than telerik reporting, it always returns the results that I initially put when I added the parameters to the report. I need to be able to replace those values ​​that I set by default with the ones that I send to obtain different results.

From already thank you very much, greetings

 

Dim telReportStockMinimo As New Telerik.Reporting.Report
        Dim instanceReportSource = New Telerik.Reporting.InstanceReportSource()
        Dim codProddesde = frmSeleccionStockMinimo.lblProdDesde.Text
        Dim codProdhasta = frmSeleccionStockMinimo.lblProdHasta.Text
        Dim cantidad = frmSeleccionStockMinimo.txtcantidadMinima.Text
        instanceReportSource.ReportDocument = New telReportStockMinimo
        Me.ReportViewer1.ReportSource = instanceReportSource
        instanceReportSource.Parameters.Add(New Telerik.Reporting.Parameter("codProdDesde", codProddesde))
        instanceReportSource.Parameters.Add(New Telerik.Reporting.Parameter("codProdhasta", codProdhasta))
        instanceReportSource.Parameters.Add(New Telerik.Reporting.Parameter("cantidad", cantidad))
        ReportViewer1.RefreshReport()

Hy,

I creating a new telerik report and I want this report to export in excel. This new report has a table where a define my columns but I want my last 3 columns when I make a excel export (I select the option Excel Worksheet, see the PNG img for more info) to be in a group.  Is there an option from telerik report to make the excel export create this group?

I also attached an excel file to see how I want my output (that +/- is my group, when I press + it show my columns and when I press - it hide my columns).

If you need more details, please let me know.

Hi all,

I am new to Telerik and stuck.  Using Report Designer ver. 15.1.21.616.  Have a basic table which has user names and timestamps for when their accounts were activated.  Need to get a simple count of how many were activated in the last 30, 60 and 90 days. Tried with the main (server side) query such as 

Select name, ActionTimeStamp from UserRequest where ActionTimeStamp > AddMonths(Today(),-1)

or,

Select name, ActionTimeStamp from UserRequest where ActionTimeStamp > DATEADD(day, -30, getdate())

to no avail; getting different kinds of errors. 

Tried downloading the whole table (without a WHERE statement) and use an expression imbedded inside a Text Box to get the count. Just to make sure the function works, tried: 

[= AddMonths(Today(),-1)] 

and it works, it gives me the date 30 days before today. So tried to build on AddMonths(). Tried the following, and any combination that I could think of, and yet cannot get any results!!

[= "Recs last month: " + Count(CDate(Fields.ActionTimeStamp) > CDate(AddMonths(Today(),-1)))]

What am I doing wrong?

Greatly appreciate your help; thank you, guys,

Tony

Hi guys,

I have a strange problem with svg pictures in my project.
Displayed in a viewer or printed everything is rendered as it should be (left side). But if saved to pdf everything is a bit off. Not where it should be anymore.
I have added the pdf made with save as pdf, and one where I printed it to a PDF printer.
I use a picturebox. A field from a sql request contains the link.
No special settings I think.
Is there some hidden setting I have to set? 
I also added the svg maybe there is something wrong there.

 

Greetings Benedikt

Hy,

I creating a new telerik report and I want this report to export in excel. This new report has a table where a define my columns but I want my last 3 columns when I make a excel export (I select the option Excel Worksheet, see the PNG img for more info) to be in a group.  Is there an option from telerik report to make the excel export create this group?

I also attached an excel file to see how I want my output (that +/- is my group, when I press + it show my columns and when I press - it hide my columns).

If you need more details, please let me know.

 

 

 

 

Dear all,

           I have a report which will generate few page, which I found in page 3 word format of report. There is white space above the first line. Any method to remove the white space?

 

I have recently upgraded from v10 to v13 successful with no apparerent issues.  I moved to version 14 and 15 and the same reports no longer print their sub reports.  We bind the subreports data on creation of the subreport instance in the constructor and set an instance report source to the newly created report object inside if the detail section binding event.  Then none of the binding events raise on the subreport and it never prints.

Did somethinf change between 13 and 14 that would cause this?

Thanks in advance, Eric

Hi,

I have a problem when I  try to print report in controller. The thing is; it is working locally but when I deploy the project to iss I am getting error message says; "System.InvalidOperationException: No or invalid printer error on IIS server."


// Obtain the settings of the default printer
                System.Drawing.Printing.PrinterSettings printerSettings
                    = new System.Drawing.Printing.PrinterSettings();

                // The standard print controller comes with no UI
                System.Drawing.Printing.PrintController standardPrintController =
                    new System.Drawing.Printing.StandardPrintController();

                // Print the report using the custom print controller
                Telerik.Reporting.Processing.ReportProcessor reportProcessor
                    = new Telerik.Reporting.Processing.ReportProcessor();

                reportProcessor.PrintController = standardPrintController;

                    Telerik.Reporting.TypeReportSource typeReportSource =
                        new Telerik.Reporting.TypeReportSource();

                    //// reportName is the Assembly Qualified Name of the report
                    //typeReportSource.TypeName = reportName;

                // Create a new report source pointing to report definition
                var reportSource = new UriReportSource();
                reportSource.Uri = entity.ReportName;



                foreach (var i in entity.Parameters)
                {
                    reportSource.Parameters.Add(new Parameter(i.Key, i.Value));
                }


                    reportProcessor.PrintReport(reportSource, printerSettings);                    

                return null;

 

Please suggest,

Thanks

Hi guys,

I have deleted the header row of a table by mistake and now the function with print on every page is not working obviously.
Is it possible to delcare a 'normal' row as the header? Or a function to add a new header row?
I cant find any functionality to this.
But it would be really much work to build the table new from scrap.

Also I think I will still have a problem. I have the following situation:
I have the situation where I need the GroupHeaders and GroupFooters on every page.
Not just the ColumnHeaders. I don't know if this is possible.

Greetings

Benedikt

I want to bind for example cars to one table and houses to another table. In screenshot A, I am trying to bind a table column to an array of models in the cars object, but the telerik support designer doesn't allow me to see the models and select it. All is shows that its a system.Object. Am I doing something wrong? I am using a json data source like this (I am aware that the json is in single quotes, that's not a problem. I have using json data with double quotes and still the same problem):
JsonDataSource:
{
  'name': 'john',
  'age': 146,
  'cars': [{
    'model': 'Ford89',
    'price': 50
  },{
    'model': 'BMW',
    'price': 42
  }],
  'houses': [{
    'location': 'los angelos',
    'cost': 505
  },{
    'location': 'sunny town',
    'cost': 505
  }]
}