🔧 Crystal Reports API Test Page
🔐 API Security Token
API Token (required for all endpoints)
Get this token from Web.config → appSettings → ApiSecurityToken
1. Health Check
GET /api/Health.ashx
Check API Health
2. Generate Basic Report
POST /api/ReportGenerate.ashx
Report Name (required)
The .rpt file name in the /Reports/ directory
Selection Formula (optional)
Crystal Reports selection formula for filtering
Connection Name (optional)
Connection name from Web.config (e.g., ERPConnection, PayrollConnection)
Generate Report
Clear
3. Generate Ledger Report
POST /api/ReportGenerateLedger.ashx
Report Name (required)
Selection Formula (optional)
SQL Query (optional)
Custom SQL query for dataset binding
Formula Array (optional, JSON format)
JSON object with formula field names and values
Connection Name (optional)
Connection name from Web.config
Generate Ledger Report
Clear