Required multi dimension, huge amount of data in few seconds. Our schedule framework is light and perfect solution for you.
In this video guide you can see how to schedule your own job using admin panel. You can also view other scheduled jobs by just clicking on its name.
In home page you will see different sections having list of reports. click on any job name to view it in details. If you want to schedule your own job follow below steps:
Step 1 : Click on Admin panel in top-right corner.
Step 2 : Then you will be redirected to Create Report tab.
Step 3 : In this tab you have to give report name, description and select section from dropdown list. Click on next to continue.. (Note: If your section name is not exist in section list then you can add it by click on Add New button.)
Step 4 : Now you will be redirected to another page which contains textbox for start date and end date. By default current date will be as start date. you can change it using calender control by clicking on its texbox. and select duration from dropdown list.
Step 5 : You will be redirected to Connection String. in this tab you need to build your connection string to get list of desired tables. For that select database type, provider name from dropdown list. (Note: In this tab you will also get list of connection strings in bottom of page. if your connection string already exist you can select it from list. No need to create new connection string.)
Step 6 : As per selection of database type and provider name you will get further options. like
If you select database type Microsoft SQL Server and provider SQL Server then you need to give servername,username and password. then click on Get Database button to get list of database. and select any one from the list. you will see connection string in its textbox. and click on add to view it in connection string's list.
If you select database type JASON Service and provider JASON Web Service then you need to give Service url and click on get result button.
If you select database type SOAP Service and provider SOAP Web Service then you need to give Service url and click on get result button.
Step 7 : After selecting connection string from list you will be redirected to next tab i.e Query
Step 8 : In this tab you will get list of tables. select desired table and fields and click on Get Result to get preview in grid. else click on Get Result In Chart to get preview in chart.
Step 9 : If you select result in chart then you will be redirected to another tab to select chart type and x-axis value.
Note: Once your job is scheduled it will be updated in given duration.
For any inquiries about our service, please contact us.