Default Avatar

ipong

ipong

About

Username
ipong
Joined
Visits
482
Last Active
Roles
Members

Comments

  • a rule of thumb (see attached picture) : 1. datasource contains one or more tables 2. one page links to one or more tables 3. printing in a sequence order, page1 -> page2 -> page3
  • // FROM DOCUMENTATION // This example shows how to merge two reports and preview the result: Report report = new Report(); report.Load("report1.frx"); report.Prepare(); report.Load("report2.frx"); report.Prepare(true); report.ShowPrepared();
  • I suspect 2 problems : 1. open with notepad => relation between 2 tables : parent/child datasource IS NULL, here is the cause of error 'Failed to compare two elements in the array' Delete it :           2. textobject with binar…
    in BUG in preview Comment by ipong May 2018
  • open frx file with notepad: 1. DO NOT USE DOT SEPARATOR IN PARAMETER NAME, because dot separator is internally reserved by fastreport for [TABLENAME.FIELDNAME] change : @Appli.connstring to paramconnstring @Appli.copyright to paramcopyright …
    in BUG in preview Comment by ipong May 2018
  • in app project, with a namespace = WindowsFormsApplication1, define a class: public class DataTransferObject   {                     public int Id { get; set; }         public string Name { get; set; }   } then …
  • wrong room....
    in QRCode Comment by ipong May 2018
  • set report to 'Double Pass' and use script : namespace FastReport {   public class ReportScript   {     private List list = new List();     private bool flag;              // MASTER BAND     private void Data2_BeforePri…
  • get print settings: http://www.fast-report.com/en/forum/?p=/discussion/14645 read documentation: https://msdn.microsoft.com/en-us/library/sy...apersource.aspx
  • fastreport doesnt provide a method to control 'cell' in excel, back to my previous answer, use third party library to modify the resultant of 'fastreport excel exporter'
  • there are properties you must check: 1. can grow 2. lineheight 3. wordwrap note: i dont understand with word 'report template frx for the Excel version' are you expecting the output in excel or screen display
  • did you mean 'row height' in excel? - create excel exporter in fastreport - export to stream - modify the result with third party library, such as https://github.com/dotnetcore/NPOI - write stream to file
  • this way is preferable, can remove anything and less overhead: int[] filter = { 0, 2, 4, 6 }; string output = string.Empty; using (FileStream fs = new FileStream(@"d:\outline.fpx", FileMode.Open, FileAccess.Read)) {     using (GZipStream zip …
  • // list of pages to extract int[] filterPages = { 0, 2, 4, 6 }; FastReport.Report report = new FastReport.Report(); report.LoadPrepared(@"d:\Repeat Headers.fpx"); FastReport.Preview.PreparedPages pages = report.PreparedPages; int maxPage = pages.C…
  • open frx file with notepad, make sure that event is registered:
    in BUG in preview Comment by ipong May 2018
  • this version doesnt need visual studio, open the frx file with designer.exe and make sure that you have Newtonsoft.Json.dll along with designer.exe in the same folder, then preview
  • i deliberately not using frx file [img]style_emoticons/<#EMO_DIR#>/rolleyes.gif" style="vertical-align:middle" emoid=":rolleyes:" border="0" alt="rolleyes.gif" /> after creating business object, just:[/img] FastReport.Report report = new F…
  • i use json data in a different way, create a business object then pass it to fastreport, see my attachment
  • add the "FastReport.Json.dll" reference to your project, then you can use type 'JsonDataConnection'
  • you didn't attach the msaccess database... you must debug it from designer.exe, open the frx file, at report start event, you can set 'dummy parameter value' with code. for instance: Report.SetParameterValue("@appli.copyright", "Test"); then …
  • have you followed the readme file? How to register this dll in FastReport: --------------------------------------- You can do it in several ways: 1) register using the FastReport IDE - open the report designer; - go "View|Options..." menu; - on …
  • based on the example from 'FRNetUserManual-en.pdf (documentation), page 263 : Calculating total', see my attachment, run it from designer
    in sum Comment by ipong April 2018
  • look at FRNetUserManual-en.pdf (documentation), page 263 : Example 4. Calculating total
    in sum Comment by ipong April 2018
  • google topic about MSChart (Microsoft Chart), learn how to use it
  • try SELECT * FROM T1 WHERE Id LIKE '%' & @ID & '%' note: msaccess database
  • http://www.fast-report.com/en/forum/?p=/discussion/14564
  • take a look at application.designer.vb in 'my project' folder Public Sub New()             MyBase.New(Global.Microsoft.VisualBasic.ApplicationServices.AuthenticationMode.Windows)             Me.IsSingleInstance = true   …
  • create your own select command https://www.fast-report.com/en/forum/index....c=14113&hl=
  • 1. in startup.cs using Microsoft.AspNetCore.Builder; using Microsoft.AspNetCore.Hosting; using Microsoft.Extensions.Configuration; using Microsoft.Extensions.DependencyInjection; namespace WebReportCore {     public class Startup     {   …
  • create another project, WebApi with classic dotnet framework, from dotnet core, redirect to classic webapi         public ActionResult Pdf(string file, string label)         {             string page = string.Concat("ht…
  • just an idea, create your own pdf : 1. export report to image 2. attach image to pdf, using iTextSharp 3. don't use it to report with many pages, causes high cpu usage, memory usage, and request timeout