Last post May 23, 2014 06:02 AM by itityagi
May 17, 2014 02:57 AM|Sudhi_kpza|LINK
i have to create a static document (eg- terms&conditions etc) using crystal report.
is this possible?
i am using asp.net with c#.
ReportDocument crystalReport = new ReportDocument(); // creating object of crystal report
crystalReport.Load(Server.MapPath("~/Report/CrystalReport.rpt")); // path of report
CrystalReportViewer1.ReportSource = crystalReport;
please suggest me some sample code
May 18, 2014 05:43 AM|PatriceSc|LINK
I would use a source that returns the single row I need that is:
SELECT 'The title' AS Title, 'This is the body.' AS Body, 'The thing written in small so that nobody can read it.' As ImportantClause etc... ;-) - If using SQL Server the FROM clause is not needed (ie your SELECT can return hardcoded values).
For example later you could add a select to still return a single row but have actually a table so that it can be changed or so that you can store multiple languages...
May 23, 2014 06:02 AM|itityagi|LINK
Then put the static text in a table and add the datasource after querying the database.
This can give you the flexibility of changing the static text in near future and this is also a good practise.