I'm facing some issues while connecting my SQL Server using 2 Step Authentication WebServiceDataSource in Telerik Reporting. I have referred the following official documents - Document 1  Document 2

Currently, I'm stuck on a few things:

1. On Configure Data Retrieval window, Can I leave the Data Selector Field Blank? Is it required to specify JSONPath?
2. In Postman I don't have to manually add any Headers to my current Authentication and Data Retrieval Endpoint (content type, accept, authorization, etc. these are automatically added by Postman). In Config Request/Authentication Parameters,  do I need to add any of these headers?
3. In Configure 2 Step Authentication window;
   a. What is the role of Token Path? If it is to retrieve the access_token, as per the documentation is this regex (?:"access_token":")(.?)(?:")* correct? I came up with another regex "access_token":"(.*?)". Let me know which one is correct and why.
   b. What is the Request Body Type? Text or JSON?
4. Due to the above configuration issues I am getting the following error on the Preview DataSource Results window.
   a. Error- Could not get preview.. An error has occurred. Value cannot be null. Parameter name: content

I have my SQL Server on Azure Virtual Machine. I'm trying to use Managed Identity Connection String (without the need of username, password in the connection string) to connect my SQL Server with Telerik Report. I did not find any specific documentation or a question regarding this implementation. Any leads will be appreciated.

I can connect my SQL Server using this normal connection string: Server=tcp:sqlserverendpoint,1234;Initial Catalog=SampleDatabase;Persist Security Info=False;User ID=username;Password=password;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

I'm trying to use this Connection String (which doesn't include username and password): Server=tcp:sqlserverendpoint,1234;Authentication=ActiveDirectoryManagedIdentity;Encrypt=True;Database=SampleDatabase;

Any leads would be appreciated. Thanks.

I have a table in my report and need to let the user pick the item they want the data grouped by.  If I have a parameter in the group by clause, is there a way to fill it with specific fields from the table?  I don't want all of the fields to be available as choices.

Thank you,

Jennifer

Hi all,

When I run telerik report on Telerik Reporting Designer, report run normally. But when I run it on web by HTML5 Report Viewer then error as attach picture. Plesae help to correct it.

Thanks a lot.

Hi all,

I have a question so need to consutant from you. When I run telerik report from Telerik report designer I already get error as attach picture. I guess it relate to timeout. Can you show me how to set it in telerik report designer? Thanks a lot.

im having an issue getting the total to align correctly the Pharm name and quantity line up correctly but the total is getting kicked to the right. i have a attached the report and relevant screen shot

thanks!!

How to display data of subreport according to main report Id.
Now in main report it shows all data of sub reports, but I want to populate the data according to main report Id.

Note: I have created report in telerik report designer tool.

Ex-

Main Report- (Return 2 records)
EmpName1 DOB1
EmpName2 DOB2

SubReport Result-
Address1
Address2

Showing Result Now-
EmpName1 DOB1
Address1
Address2

EmpName2 DOB2
Address1
Address2

Required Result -
EmpName1 DOB1
Address1

EmpName2 DOB2
Address2

Please Help.

Thanks In advance.

I have a report that I am trying to get the number of rows displayed.

I have also tried = Count(Fields.[Inspector Name])

It should only show the 4 for each visible row. What have I done wrong?

Dear Team,

I using telerik report Angular report viewer version 15.0.21.326 , I clicked on export button but no response "export to pdf".

May I know how can i fix this issue ? 

Thank you