Builtin Function

Question

Hi everyone, I'm new to boldreport and i have some very simple questions (I hope):

1) I saw in the report designer that there are some built-in functions to get the value of the fields of a dataset: for example the Fields collection

I've searched the documentation but can't find any specific references about the Fields collection, for example I don't know if there are any other attributes besides .Value for each item in the collection.

2) I would like to know if there are other functions like First (Field, Dataset) and Sum (Filed, Dataset) to manipulate datasets.

3) Can I somehow use GraphQL as a datasource?

4) Can i refer to a dataset without First or Sum Functions for example when i'm using a basic image control on the header

5) Can I develop with visual studio core or do I need visual studio 2019 and in the latter case is the community version sufficient?

Mahendran Shanmugam · Accepted Answer

Hi Andrea, 

Please find the below response for your queries. 





Query 

Response 


1) I saw in the report designer that there are some built-in functions to get the value of the fields of a dataset: for example the Fields collection 
I've searched the documentation but can't find any specific references about the Fields collection, for example I don't know if there are any other attributes besides .Value for each item in the collection. 

We are having more Built in functions in our Bold Reports Report Designer component. Please find the below help documentation for your reference. 
https://help.boldreports.com/enterprise-reporting/designer-guide/report-designer/compose-report/expressions/using-built-in-functions/ 
  


2) I would like to know if there are other functions like First (Field, Dataset) and Sum (Filed, Dataset) to manipulate datasets. 


3) Can I somehow use GraphQL as a datasource? 

We have checked the GraphQL as a datasource in that we are progressing the JSON data. So we can able to pass the JSON data in our Report Designer application. Please find the below help documentation for your reference. 
RestAPI: https://help.boldreports.com/enterprise-reporting/designer-guide/report-designer/manage-data/data-connectors/rest-api-data-source/ 

JSON: https://help.boldreports.com/enterprise-reporting/designer-guide/report-designer/manage-data/data-connectors/json-data-source/ 



4) Can i refer to a dataset without First or Sum Functions for example when i'm using a basic image control on the header  

If you are using the Tablix report item then you can able to use the dataset without built-in-function, so you can add the field without any function when using the dataset fields inside the Tablix. Please find the below help documentation for your reference to create a Tablix report item. 
https://help.boldreports.com/enterprise-reporting/designer-guide/report-designer/report-items/tablix/assign-data-to-tablix-data-region/ 



5) Can I develop with visual studio core or do I need visual studio 2019 and in the latter case is the community version sufficient? 

You can able to create a Bold Reports Report Designer application in Visual Studio 2019. Please find the below help documentation for your reference to create a application. 
https://help.boldreports.com/embedded-reporting/aspnet-core-reporting/report-designer/add-web-report-designer-to-an-aspnet-core-application/ 

Yes community version sufficient to create a application. 

Regards, 
Mahendran S.

Query	Response
1) I saw in the report designer that there are some built-in functions to get the value of the fields of a dataset: for example the Fields collection I've searched the documentation but can't find any specific references about the Fields collection, for example I don't know if there are any other attributes besides .Value for each item in the collection.	We are having more Built in functions in our Bold Reports Report Designer component. Please find the below help documentation for your reference. https://help.boldreports.com/enterprise-reporting/designer-guide/report-designer/compose-report/expressions/using-built-in-functions/
2) I would like to know if there are other functions like First (Field, Dataset) and Sum (Filed, Dataset) to manipulate datasets.
3) Can I somehow use GraphQL as a datasource?	We have checked the GraphQL as a datasource in that we are progressing the JSON data. So we can able to pass the JSON data in our Report Designer application. Please find the below help documentation for your reference. RestAPI: https://help.boldreports.com/enterprise-reporting/designer-guide/report-designer/manage-data/data-connectors/rest-api-data-source/ JSON: https://help.boldreports.com/enterprise-reporting/designer-guide/report-designer/manage-data/data-connectors/json-data-source/
4) Can i refer to a dataset without First or Sum Functions for example when i'm using a basic image control on the header	If you are using the Tablix report item then you can able to use the dataset without built-in-function, so you can add the field without any function when using the dataset fields inside the Tablix. Please find the below help documentation for your reference to create a Tablix report item. https://help.boldreports.com/enterprise-reporting/designer-guide/report-designer/report-items/tablix/assign-data-to-tablix-data-region/
5) Can I develop with visual studio core or do I need visual studio 2019 and in the latter case is the community version sufficient?	You can able to create a Bold Reports Report Designer application in Visual Studio 2019. Please find the below help documentation for your reference to create a application. https://help.boldreports.com/embedded-reporting/aspnet-core-reporting/report-designer/add-web-report-designer-to-an-aspnet-core-application/ Yes community version sufficient to create a application.