Telerik Forums
Reporting Forum
0 answers
334 views

Hai Telerik Team,

I was testing , the integration of  Telerik Reporting in my asp.net Core application.But when i load report from my html page , it shows an error , related to connection string not get properly , the error message is that

An error occurred while loading the data schema for "sqlDataSource1": 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.

Report is loading from designer , using same connection string.When i  try to integrate telerik example reports, system shows same error message.

please give me your suggestion to how fixt this issue

 

 

Noufal
Top achievements
Rank 1
 asked on 22 Jun 2021
0 answers
957 views

I want to set up a conditional format to hide an image if the byte array count < 2. I cannot figure out how to simply deal with collections such as arrays and get a count.

I've tried this, but my report won't preview in the designer:

= Count(=Fields.[Logo])

How do I achieve this?

Thanks in advance.

Rick Feuer
Top achievements
Rank 1
 asked on 21 Jun 2021
1 answer
608 views
I have multiple tables that I would like to join together based on e.g. CustomerID. I know I could use a report parameter, which I already am using for the date. What I want to do is filter by the date report parameter, but align the table rows by the Customer ID in each table so it looks like a seamless report. Can I do this through binding?? If so, how?
Todor
Telerik team
 answered on 15 Jun 2021
1 answer
1.1K+ views

Goal: Change a trdx's web services data sources from using web service requests to using inline data strings and then render a PDF.

The trdx was created using the Invoice Report Wizard and has two data sources (one for header and one for detail). Both actually call the same web service method but use different data selectors ($.result and $.result.MemberReceiptDetails). I need to replace these calls with inline json strings (again, they'll be identical) and remove the parameters.  I see the Report class has a DataSource property but how does this relate to multiple datasources?.

 

            XmlReportSource reportSource = new XmlReportSource();

            Report report = GetReportFromResources("Member.DuesReceipt.trdx");

            //Change data sources here

            StringBuilder builder = new StringBuilder();
            using (System.Xml.XmlWriter xmlWriter = System.Xml.XmlWriter.Create(builder))
            {
                Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer =
                    new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();

                xmlSerializer.Serialize(xmlWriter, report);
            }

            reportSource.Xml = builder.ToString();

            var reportProcessor = new ReportProcessor();
            RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, null);

Dimitar
Telerik team
 answered on 15 Jun 2021
1 answer
844 views

Please refer the snapshot attached.

The telerikReportViewer.js file is not loading properly. I checked the path, its linked correctly (Refer Snapshot : telerikReportViewer1.png)

But still my reports are not loading properly.

It looks like its not about the file path, something else seems to be causing this error.

Please help.

Plamen | Lead Technical Support
Telerik team
 answered on 14 Jun 2021
1 answer
304 views

Hello,

I am trying to view a working example of the tr-report viewer, but it does not appear the rest api for the example angular report viewer is working. This is what happens when I run the example application using this serviceUrl: https://demos.telerik.com/reporting/api/reports/

Plamen | Lead Technical Support
Telerik team
 answered on 14 Jun 2021
1 answer
299 views

Goal: I want to create a .NET Standard class library with trdx reports so that I can deploy it with projects on various platforms.

I added a trdx file to the new library and made it an embedded resource but could not access it. I then stepped back, simplified, and added the report to a .NET Framework 4.7 Windows Forms app, again as an embedded resource.

        public Form1()
        {
            InitializeComponent();

            var a = System.Reflection.Assembly
                .GetExecutingAssembly()
                .GetManifestResourceStream("Reports.Report1.trdx");

            TypeReportSource reportSource = new TypeReportSource();
            reportSource.TypeName = "Reports.Report1.trdx";

            var reportProcessor = new ReportProcessor();
            RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, null);
        }

a is populated (as a check) but rendering results in: {"Invalid report type"}

Neil N
Top achievements
Rank 2
Iron
Iron
Veteran
 answered on 11 Jun 2021
1 answer
709 views
As an example, I have a report with two report parameters. The first is year, the second is month. If I have AutoRefresh on, it reruns the query if I pick year OR month. So I disabled the AutoRefresh on the first parameter, so it would only re-run the query after setting the second parameter. However, when I do this, the second parameter does not AutoRefresh, and I have a Preview button.  Is this the way it was designed, or is something wrong??
Todor
Telerik team
 answered on 11 Jun 2021
1 answer
574 views

I have attached the error of the code while trying to integrate it into Core. Image of Report 1 &2 is the actual code, and Error image 3, 4, 5 is the result of the code error.

 

Thanks

Plamen | Lead Technical Support
Telerik team
 answered on 10 Jun 2021
2 answers
513 views

Hi!

My datasource includes one field which is a comma separated list of items. What I like to do is display these items in three columns inside my report.

Items: "item1, item2, item3, item4, item5, ... , itemX"
Displayed as

item1     item4    item7
item2    item5    item8
item3    item6    item9

How can I achieve this?

Regards
Heiko

Plamen | Lead Technical Support
Telerik team
 answered on 09 Jun 2021
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?