Telerik Forums
Reporting Forum
1 answer
265 views

Hello there, I am working on One pager report, and I need to know if data inside exceed one page in advance.

My idea was to get height of table or parent panel and add some space after bindings. But seems like it is not possible to get real height of panel or table, all the time height gets from designer.

Neli
Telerik team
 answered on 12 Nov 2019
3 answers
1.1K+ views

 

Hello,

I try to connect to a prostgres Database with Report Designer.

Connection is successful by connecting via odbc data source. But i fails when i`m using an connection string.

I followed  this example:

https://www.telerik.com/support/kb/reporting/accessing-and-managing-data/details/how-to-register-sqldatasource-data-providers-without-driver-installation

I want to register the npgsql.dll directly in cofig file.

Now, when i select SQL Data Source in Designer _> Build new Data connection -> Data provider (I can choose: Npgsql Data Provider) -> and type in connection string (Server=localhost; Port=5432; Database=DbName; User ID=demo; Password=demo;) 

ERROR: Can not find registered .Net Framework-Data provider  

Npgsql.dll and his dependencies are present in separate bin folder in AppRoot-folder.

Any suggestions?

Best regards,

Bernd

 

 

 

Neli
Telerik team
 answered on 12 Nov 2019
1 answer
343 views

I have a model that looks like this 

public class APV
{
    public string VendorName { get; set; }
    public DateTimeOffset ReportDate { get; set; }
    public string APV_NO { get; set; }
    public string INV_NO { get; set; }
    public decimal? INV_AMT { get; set; }
    public decimal? TOTAL_DEBIT { get; set; }
    public decimal? TOTAL_CREDIT { get; set; }
    public IEnumerable<AccountStatement> AccountStatements  { get; set; }
}
 
public class AccountStatement
{
    public string AccountCode { get; set; }
 
    public string AccountName { get; set; }
 
    public decimal? Debit { get; set; }
 
    public decimal? Credit { get; set; }
}


but I am passing a list of that object such as

var apvDatas = new List<APV>();
apvDatas.Add(item1);
apvDatas.Add(item2);
apvDatas.Add(item3);

I want to create a one page report per item, so I am expecting a 3 page report with different APV_NO or INV_NO as its own page identifier, I just want to create one page report per item with the same header and footer. 

here how my report looks like when I pass a single object but whenever I pass list of object it looks like this 

expectedperItem.png is what it should like per item
somethingiswrong.png is what is happening whenever I try to pass a list of APV

Peter
Telerik team
 answered on 11 Nov 2019
9 answers
1.6K+ views
Hi,

I have a table control on my report. I want to have alternative rows applied two different colors.
I dont find any properties or style for this.
Please help

Thanks
Sony
Peter
Telerik team
 answered on 11 Nov 2019
3 answers
521 views

Hello,

I use Telerik Reporting to auto create PDF-files and I also use the Html5 user.

During loading the report, thousands of files and folders were created in Path C:\WINDOWS\Temp\Html5App\12.0.18.227\...  although I set cache provider to "Memory" in app.config.

On the systems of my customer, the infrastructure occurs problems on these amount of files. Is it possible to disable the creation of these files and folders?

 

Best regards

Patrick

Todor
Telerik team
 answered on 11 Nov 2019
22 answers
653 views

I'm fairly consistently getting a 503.0 error (server has been shutdown) when working with Telerik reports. This is an ASP.NET Core application, currently with a single report with 2 sub-reports. I've published the application to a test Azure app service and that fails pretty consistently when trying to preview the report each time. On most occasions the report opens but as soon as I switch to print preview I receive a report that the service has shutdown with a 503.0 error - racing shows this to be with ASPNetCoreModuleV2.

If I run the application in debug mode from my VS2017 on Windows 10 using IISExpress and Firefox browser, the application works fine and I can navigate around without any issues. If I then run the report it opens and displays correctly. I can switch to print preview and mostly that also shows correctly but when I try to export to PDF I get the 503.0 error. Sometimes the error will come up at print preview stage. The report runs from a SQL data source using a stored procedure. The 2 sub-reports run from separate stored procedures. They are all set to use the same application "ReportsConnection", passing 2 parameters to the report and consequent stored procedure. Can you provide some advice on what might be causing this problem or what to investigate to try to identify the issues?

Todor
Telerik team
 answered on 08 Nov 2019
7 answers
140 views

Hi there,

I have a report with 3 filter, date1, date2 and driver.
The report parameter driver is set to multivalue.

How can I set the report so that each selected driver
gets its own table in the report and is displayed on a separate page?

Example:
In the report, 3 drivers were selected.
So there are 3 tables in the report each on a DINA4 page.

---
Can I realize this with a ReportViewer or should I better take a ReportBook?

Is there an example project for download?

 

Best regards

 

Simon

Simon
Top achievements
Rank 1
 answered on 08 Nov 2019
6 answers
2.9K+ views

In my report I'm using 2 data sources: webServiceDataSource and jsonDataSource. The main DataSource for the report is webServiceDataSource. I'm using jsonDataSource just for storing some report meta data and I want to read this jsonDataSource source from c# code.

Part of my code:

Telerik.Reporting.Report report = ... - (it's report object)

var dataSource = report.DataSource;

We have access to DataSource property. But, we don't have access to DataSources collection property in code. I tried to use DataSources property in Watch window(Visual Studio 2019), it is now showing on intellisense, but if you write DataSources property manually then it works.

Question is how can I read DataSources collection property and get jsonDataSource programmatically?

Todor
Telerik team
 answered on 07 Nov 2019
1 answer
408 views

 

When I try to alternate row color on a table on a report I use the Conditional Formatting =RowNumber()%2

When the report runs I get the error “Aggregate node ‘LeafNumber(Const(RowNumber))’ not found.

José Miguel Herrera G
Top achievements
Rank 1
 answered on 07 Nov 2019
5 answers
776 views
Is it possible to generate data on a button clicked and put that data inside a report which has a pre-defined design? I am using asp.net mvc, any guides or demo I could use?
Aubrey Ivan
Top achievements
Rank 1
 answered on 07 Nov 2019
Top users last month
Ambisoft
Top achievements
Rank 2
Iron
Pascal
Top achievements
Rank 2
Iron
Matthew
Top achievements
Rank 1
Sergii
Top achievements
Rank 1
Andrey
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?