1 of 7

How Tos

Custorm Grid-Spalte Datumsformat

Create Resport REST

Telerik Extension Functions

Printing in LAN

Custom Grid Column Date Format

Create Report REST

Example of a HTTP Request to the brixxbox

Create Report REST

You can create a report from 3rd party systems by using a http POST call to the brixxbox.

We created a postman solution to demonstrate the call because you have to login first. Run in Postman

3 Environment Variables have to be set in Postman: "UserEmail" and "UserPassword" for the login call an "Workspace" for the url part of the CreatePdf call

You can specify if the report should be archived or not in the post parameters:

// POST call to https://app.brixxbox.net/w/{{Workspace}}/c/default/reporting/CreatePdf
{
   "reportName": "addresslist", 

   //optional parameters
   "archive": false, //optional, false is default
   "configName": "address", //optional, only if you want to archive
   "documentTypeId": 1, //optional, only valid if configName and parameter 'id' is set and archive is true
   "culture": "de-DE", //optional, report has its defaults
   "parameters": { //optional
       "id": 1
   }
}

Telerik Extension Functions

Telerik Page Footer Sum

How to use brixxbox custom functions in telerik

BrixxPageFooterSum

Sums elements in a table up to this footer

Each page sum function can only be used once in a report. Using it multiple times will result in wrong calculated values!

Demo

Telerik Page Header Sum

Sums elements in a table up to this header (carry over from previous footer sum)

Each page sum function can only be used once in a report. Using it multiple times will result in wrong calculated values!

//This function belongs in a PageHeaderSection of a telerik report
=PageExec("textBoxValue",             //put in a textbox from your table row. Typically your value textbox, but whatever is in your row will work. This triggers the accumulation of the values
           BrixxPageHeaderSum(
               Fields.yourValue,      //put in the Value Field you want to sum up
               PageNumber,            //this is fix (the PageNumber variable from your report. this will tell the function when to take a sum)
               ReportDefinition))     //this is fix (it will tell the sum to reset for each new report)

Printing in LAN

How to print on a local Printer in your LAN

This video explains how to print in a local network, when using the brixxbox cloud service.

Create Report REST

Example of a HTTP Request to the brixxbox

Create Report REST

You can create a report from 3rd party systems by using a http POST call to the brixxbox.

We created a postman solution to demonstrate the call because you have to login first. Run in Postman

3 Environment Variables have to be set in Postman: "UserEmail" and "UserPassword" for the login call an "Workspace" for the url part of the CreatePdf call

You can specify if the report should be archived or not in the post parameters:

// POST call to https://app.brixxbox.net/w/{{Workspace}}/c/default/reporting/CreatePdf
{
   "reportName": "addresslist", 

   //optional parameters
   "archive": false, //optional, false is default
   "configName": "address", //optional, only if you want to archive
   "documentTypeId": 1, //optional, only valid if configName and parameter 'id' is set and archive is true
   "culture": "de-DE", //optional, report has its defaults
   "parameters": { //optional
       "id": 1
   }
}

Telerik Page Header Sum

Sums elements in a table up to this header (carry over from previous footer sum)

Each page sum function can only be used once in a report. Using it multiple times will result in wrong calculated values!

//This function belongs in a PageHeaderSection of a telerik report
=PageExec("textBoxValue",             //put in a textbox from your table row. Typically your value textbox, but whatever is in your row will work. This triggers the accumulation of the values
           BrixxPageHeaderSum(
               Fields.yourValue,      //put in the Value Field you want to sum up
               PageNumber,            //this is fix (the PageNumber variable from your report. this will tell the function when to take a sum)
               ReportDefinition))     //this is fix (it will tell the sum to reset for each new report)