or
1 answer
59 views
Where is the code usually kept？
Momchil
Telerik team
answered
on
28 May 2024
1 answer
93 views
I'm generating a lot of reports using the ReportProcessor class and the RenderReport function to get the PDF and save it in a share drive.
private byte[] GetReport(int param)
{
var reportProcessor = new ReportProcessor();
var reportSource = new UriReportSource
{
Uri = Path.Combine(_environment.ContentRootPath, "Reports", "Report.trdp"),
};
reportSource.Parameters.Add(new Parameter("param", param));
var result = reportProcessor.RenderReport("PDF", reportSource, new Hashtable());
return result.DocumentBytes;
}
This works fine. But if I only run the application and get to generate the reports I get:
"An error has occurred while processing Report 'Report':
Unable to establish a connection to the database. Please verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name
is correct and the connection string settings are present in the configuration file of your application.
------------- InnerException -------------
Format of the initialization string does not conform to specification starting at index 0."
The part that I don't understand is that if I go to the page where I have a HTML5 Report Viewer and generate and view a report from the page the error goes away.
I search a lot about this and tried different things and got nothing.
The problem might be related with the appsettings.
We have different configuration for each env and the appsettings.json is merged with appsettings.ENV.json
I tried to put the con string in the base appsettings and worked fine.
I need a solution because I still need to have diferent connectionstrings in different enviorments and I can't reliable run the report in the viewer before generate the standalone PDF
private byte[] GetReport(int param)
{
var reportProcessor = new ReportProcessor();
var reportSource = new UriReportSource
{
Uri = Path.Combine(_environment.ContentRootPath, "Reports", "Report.trdp"),
};
reportSource.Parameters.Add(new Parameter("param", param));
var result = reportProcessor.RenderReport("PDF", reportSource, new Hashtable());
return result.DocumentBytes;
}
This works fine. But if I only run the application and get to generate the reports I get:
"An error has occurred while processing Report 'Report':
Unable to establish a connection to the database. Please verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name
is correct and the connection string settings are present in the configuration file of your application.
------------- InnerException -------------
Format of the initialization string does not conform to specification starting at index 0."
The part that I don't understand is that if I go to the page where I have a HTML5 Report Viewer and generate and view a report from the page the error goes away.
I search a lot about this and tried different things and got nothing.
The problem might be related with the appsettings.
We have different configuration for each env and the appsettings.json is merged with appsettings.ENV.json
I tried to put the con string in the base appsettings and worked fine.
I need a solution because I still need to have diferent connectionstrings in different enviorments and I can't reliable run the report in the viewer before generate the standalone PDF
Dimitar
Telerik team
answered
on
23 May 2024
1 answer
70 views
Hi,
We're currently investigating Telerik reporting as a replacement reporting product. There are two features we're trying to understand if there is a suitable method in Telerik.
1. Parameters driven report. We want to able to present the user with parameters before the report retrieves any data.
As an example, present a list of sites that the user can choose from and then retrieve the data for only that site in the report. I've included a link to a similar idea seen in another product.
https://developer.mescius.com/activereportsnet/demos/dynamic/parameter-driven
2. Drop down tree filter
When a report is loaded to be able to filter with a drop down tree filter similar to the Kendo component.
As an example, the user opens a report for all sites. This list contains 200 sites. After opening they want to filter to only show a small subset of those sites. The drop down tree would be ideal for this.
https://demos.telerik.com/kendo-ui/dropdowntree/index
Dimitar
Telerik team
answered
on
22 May 2024
1 answer
56 views
This is how i want it to look like. I also want to populate the table without using wizard
Todor
Telerik team
answered
on
20 May 2024
1 answer
68 views
Hi Support,
Is there any documentation on it that i can read? My project is Blazor WASM based.
Dimitar
Telerik team
answered
on
17 May 2024
1 answer
139 views
I have a scenario where I have multiple components, including tables, panels with textboxes, and charts/graphs. I want to add a page break after a specific panel to ensure that it appears on the new page regardless of the size of the content on the previous page. I do not see any straightforward way to do this, and the keepTogether property doesn't always work.
Momchil
Telerik team
answered
on
14 May 2024
2 answers
88 views
Hello
I have these rows of data coming from DataSource example is in the attached file image
- Want to do some math expressions of every row like Subtraction(BRUTO - DESCUENTO) and show the value in NETO painted in the pink line and circle for individual rows of data.
- I tried to use the expressions SUM(DOC_UNID_BRUTO) and SUM(DOC_UNID_DESCUENTO) try to get the Total SUM of these fields but are just getting the individual first value.
- And the last thing is I want to do a subtraction of the total of NETO and DESCUENTO in the last bottom right corner
I have these rows of data coming from DataSource example is in the attached file image
- Want to do some math expressions of every row like Subtraction(BRUTO - DESCUENTO) and show the value in NETO painted in the pink line and circle for individual rows of data.
- I tried to use the expressions SUM(DOC_UNID_BRUTO) and SUM(DOC_UNID_DESCUENTO) try to get the Total SUM of these fields but are just getting the individual first value.
- And the last thing is I want to do a subtraction of the total of NETO and DESCUENTO in the last bottom right corner
Dimitar
Telerik team
answered
on
13 May 2024
1 answer
194 views
Hello there,
I have this issue when generating my report, it duplicates the number of pages based on the amount of rows of data that my DataSource provides to the Report.
Another detail is the external border when generated from the report but in the preview or the designer doesn't show the border
How I can remove it?
I am using a table wizard connected to the data source (SQL Data Source).
Example in the attached file
I have this issue when generating my report, it duplicates the number of pages based on the amount of rows of data that my DataSource provides to the Report.
Another detail is the external border when generated from the report but in the preview or the designer doesn't show the border
How I can remove it?
I am using a table wizard connected to the data source (SQL Data Source).
Example in the attached file
Dimitar
Telerik team
answered
on
13 May 2024
1 answer
256 views
Support team,
I am exploring a trial of Telerik. I have installed the Reports Server on a remote windows server. and it is running. I have made users in the User Management and given them all the permissions.
In the Telerik Report Designer, running on my local machine, I am trying to Add A Report Server. I entered the server URL from my server, then the local user and pwd.
I get the error "Error while logging into the server. Please check the URL and credentials."
I assume I have the right URL. It came from the setting screen on the reports server. I saw another user's ticket with this issue, from years ago, and it suggested installing Fiddler and sending the logs. I have installed Fiddler, but do not know how to simulate logging into the reports server.
Any help would be appreciated.
Thanks
Amy
Dimitar
Telerik team
answered
on
10 May 2024
1 answer
84 views
Hello again,
We are getting an unexpected scrollbar which allows us to scroll between pages one and two of our reports list. We would rather just use the nav bar to switch between both pages.
Is there something perhaps in the backend designer that needs to be updated ? Some property somewhere ? Or just a css class override on the front end ?
ex/ see page-wrapper class
class="trv-page-wrapper active"
And using the navbar, we would rather just switch between pages via those left/right arrow icons - and NOT have the scrollbar shown here in the screenshow.
In the meantime, I'm doing some debugging to see if I can find the solution...
thanks,
Bob
Momchil
Telerik team
answered
on
10 May 2024
