Telerik Forums
Reporting Forum
10 answers
1.2K+ views

in development server its working fine but after migrate to production.

i using db mysql

impossible connector .net to mysql got problem because data access working fine.

 here is the error

An error has occurred while processing Report 'Report2': Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application. ------------- InnerException ------------- Unable to find the requested .Net Framework Data Provider. It may not be installed.

 connection string also same with data access connection string.

 

my code

 

public class CustomReportResolver : IReportResolver
    {
        protected TokenBasedView tokenBased { get; set; }
        public Telerik.Reporting.ReportSource Resolve(string reportCode)
        {
 
 
            Telerik.Reporting.Report report = new Report2();
 
            Telerik.Reporting.InstanceReportSource irs = new Telerik.Reporting.InstanceReportSource();
            irs.ReportDocument = report;
            return irs;
        }
 
}

i hope somebody can help me out. 

 

thank you so much

Zak
Top achievements
Rank 1
 answered on 18 Jun 2015
1 answer
459 views

When I print my report with a watermark from code behind, the Watermark text prints as dotted as opposed to printing from the ReportViewer which prints the watermark as solid. How can I get the watermark to print solid like it does in the ReportViewer from code behind?

 

 

// 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 = typeof(BuildPlanReportLib.Traveler3).AssemblyQualifiedName;

Report3 rep2 = Report3();
rep2.PageSettings.Landscape = true;

reportProcessor.PrintReport(rep2, printerSettings);

 

 

Stef
Telerik team
 answered on 17 Jun 2015
1 answer
131 views

I have one textbox on my report with the value of .55 and the format is set as {0:N2}.  Now when I export to excel the format for said cell becomes [$-1010409]#,##0.00;-#,##0.00 under the Custom Category .  I would like some help in understanding why the format is not behaving as expected for the excel.  I researched and saw this thread:

 http://www.telerik.com/forums/report-lose-formatting-after-export-in-excel

The answer that {0:N2} would be the solution isn't working for me for some reason.  Just in case it's needed I am using the ReportProcessor.RenderReport method for my generation.

Thank you

Stef
Telerik team
 answered on 16 Jun 2015
1 answer
120 views

Hi there

I have some reports that I want to export as .pdf with a custom document name set. While debugging I can see the .DocumentName property is set properly in the report object. 

When the report opens inline in the browser (IE11 with acrobat add-on) and I select "Save as..." the suggested filename is still the default name and not my custom document name.

What am I missing here?

Thank you

 

Stef
Telerik team
 answered on 16 Jun 2015
6 answers
321 views

I just creating a report that can count number of student for a specific age group .using database record i'm generating those reports

Here it looks like

Age                |  Count

18                   |   344

20                   |   356

30                   |   567

Age Unknown |   323

Age 18, 20 , 30 , I able to count using following Edit Grouping and Edit Filtering options

for example , to count age 18 

in Edit Grouping : = Fields.Age = 18
in Edit Filtering   :  

Expression       | Operator | Value
= Fields.Age     |       =       |    18

I want to get count for "Age Unknown" group if age column null in database , what is the grouping and Filtering syntax for that in telerik 

Kelum
Top achievements
Rank 2
 answered on 16 Jun 2015
6 answers
524 views

What are the best ways to use repository/service and dependency injection with reports?

 e.g. If I have an ... ICustomerReportDataService.GetCustomers(<some parameters>) that backs my report, what is the best way to get this into my report?

 

Note that ICustomerReportDataService is an interface that will eventually â€‹be served by the IOC container (that does not have a parameterless constructor)

Stef
Telerik team
 answered on 16 Jun 2015
2 answers
261 views

Hi,

 Just trying for the first time as a possible replacement for SSRS.  In the designer I cannot drag items, e.g. textboxes, or picture boxes for more than a fraction of a second.  It's very strange, if I move the mouse slowly, I can more the textbox a few pixels then it stops as though I've let go of the button.  If I move the mouse quickly I can get more distance, but still stops after a fraction of a second.  I can move the textbox with the arrow keys or by entering the location directly in the properties.  Version is 9.0.15.324 on Win8 .I've tried turning off all the snap options, but the problem is the same.

Scott Waye
Top achievements
Rank 2
Iron
Iron
Veteran
 answered on 15 Jun 2015
1 answer
1.1K+ views

Hello,

 

I need to create a report programmatically and watch this report in a report viewer when i push a button for print this. I have read information but i can't resolve it. This is my code:

 

 

protected void Page_Load(object sender, EventArgs e)
   {
       doReport();
   }
 
   private void doReport()
   {
       DataTable table = new DataTable();
       table.Columns.Add("Col1", typeof(string));
       table.Columns.Add("Col2", typeof(string));
       table.Columns.Add("Col3", typeof(string));
       table.Columns.Add("Col4", typeof(string));
 
       List<datos> datosList = new List<datos>();
       datosList.Add(new datos { dato1 = " lala", dato2 = "lele", dato3 = "lili", dato4 = "lolo" });
       datosList.Add(new datos { dato1 = " lala", dato2 = "lele", dato3 = "lili", dato4 = "lolo" });
       datosList.Add(new datos { dato1 = " lala", dato2 = "lele", dato3 = "lili", dato4 = "lolo" });
       datosList.Add(new datos { dato1 = " lala", dato2 = "lele", dato3 = "lili", dato4 = "lolo" });
 
       for (int i = 0; i < datosList.Count; i++)
       {
           string dato1 = datosList[i].dato1;
           string dato2 = datosList[i].dato2;
           string dato3 = datosList[i].dato3;
           string dato4 = datosList[i].dato4;
           table.Rows.Add(dato1, dato2, dato3, dato4);
       }
 
       Telerik.Reporting.ObjectDataSource objectDataSource = new Telerik.Reporting.ObjectDataSource();
       objectDataSource.DataSource = table;
       objectDataSource.CalculatedFields.Add(new Telerik.Reporting.CalculatedField("FullName", typeof(string), "=Fields.PagePath + ' ' + Fields.Pageviews")); // Adding a sample calculated field.
 
 
       Telerik.Reporting.Report report = new Telerik.Reporting.Report();
       report.Name = "prueba";
       report.DocumentName = "prueba";
       report.DataSource = objectDataSource;
 
       Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
       reportSource.ReportDocument = report;
 
       ReportViewer1.ReportSource = reportSource;
 
       ReportViewer1.RefreshReport();
   }
 
   public class datos
   {
       public datos()
       {}
 
       public string dato1 ;
       public string dato2 ;
       public string dato3 ;
       public string dato4 ;
   }

 

Any idea? Thanks

Stef
Telerik team
 answered on 15 Jun 2015
3 answers
341 views
Hello Support,

I trying using Telerik Reporting tools, I have a report as you see in attachment.
My report is simple read a data from database and fill the text boxes but I face a problem when the textbox has multi lines the textbox did not push down other controls I set the properties CanGrow=True, MultiLine=True and Anchor=Top

I am using ASP.NET 4.5 ,SQL DataSourc and RenderReport to pdf becouse I want to generate the report on the server and save it in database

Please give me your advice

Best Regards
Abdullah
Top achievements
Rank 1
 answered on 15 Jun 2015
1 answer
144 views

Here I am using graph control for showing more that 25 records, If record is less than 10 dynamically populate according to condition then graph is showing properly other wise graph is overlap. 

 

Any one have any idea which properties fulfill this requirement.

Nasko
Telerik team
 answered on 15 Jun 2015
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?