I'm using the standalone Report Designer, and I'm trying to export my report to Excel with each order line item on a separate sheet. My report has orders, and each order has one or more line items. Basically, our customer wants to see separate reports on each tab showing the order header data and the line item data.

I've seen suggestions to use the Report Book feature, but we're using the standalone designer, and the report book feature seems to be a programmatic solution. I need a solution I can implement in the designer.

Thanks!

Hi everybody,

   we need to print a report with following format:     

Hi everybody (second try):

    we need to print a report with format attached in file. 

 

    In other words, we need beginning of a subgroup can be bellow parent group. Is it possible?

Very thanks

I have group its header print on every page if the detail will be extended to more pages.

But, I need to do conditional formatting or binding to check if group header is repeated in this page (this group data displayed in previous page or not) or not.

 

Example : 

Product Category 1 Group Header
        Product 1 Detail
        Product 2 Detail

Product Category 1 Group Header
        Product 7 Detail

Product Category 2 Group Header
       Product 3 Detail
       Product 4 Detail

Product Category 3 Group Header
      Product 5 Detail
      Product 6 Detail

I am trying to embed a telerik report into my asp.net web application and am having difficulties.  The report was built in a class library, "blah.Reports" and then the project was added to my application.  I added the reference to the class library as well.  When I try to set the "Report" property of the ReportViewer in my page I get a Visual Studio Error:

Value cannot be null.
Parameter name: key

Because I could not get around this I tried another route:
I looked at some examples and manually set the report property in the xaml with this:
blah.Reports.Statement, blah.Reports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null

Now the report shows up in the page with text boxes to enter the parameters, but as soon as I enter them I receive a new error:

An error has occurred while processing Report 'Statement':
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.

I copied the connection string from the app.config of the class library to my asp.net app's web.config, still no dice.  Same error.  Any help would be greatly appreciated.

I have created one report in standalone report designer (Report.trdp), using object data source (my custom CLR type). It´s possible to programmatically load the report file and set the data source like a report created in Visual Studio (Report.cs)?

 

Idea of code:

 

Regards,

André

Hi,

Cam Anyone please give me code example on how to assign report to HTML5 report viewerin ASP.Net.

For example, report1.trdp, i want to assign it to reportviewer1 in asp.net. And if possible how to also assign data source to report1.trdb.

Please help on this.

Many thanks,

Omar

I have a map which I need to put points very close to each other. The distance from each other should be less than 1 meter. The points must also overlap each other. However, I'm facing an issue which I cannot find a good logic on how it works. 

The attached picture consists of 10 points with the same longitude, but only different latitude. Each has unique Id field. To each point has been added 0.0001 latitude (which translates as roughly 1.12meters). My issue is that points 1,2,5,6,9,10 look great. However 3,4 and 7,8 are grouped/combined/on top of each other. How is it determined which to group and how?

A little bit more relevant information:

I'm using PointMapSeries. 
MarketMaxSize, MarketMinSize, MarketSize is set to 1mm/1px
The seriesGroups groups by Fields.Id and so does the geoLocationGroup.
My dataclass has only Lat, Long & id.

I can provide more information if needed.

Hello,

I have a text box on a form that I want to show when either or both of two conditions are true or selected in the UI. Visible is set to false.

Basically, when CustAcctHold is checked in the UI, I want to show the HOLD text box.

Also, if CustAcctTerms is set in the UI to HOLD, I want to show the HOLD text box.

I have tried  = IsNull(Fields.CustAcctHold.Ticks, 0) with Operator = and Value 1 which I found on another thread, still did not work. Also tried, = IIf(IsNull(Fields.CustAcctHold, 0)= 0, 0,1)

 

I cannot figure out a string an expression that will make this work. Any help would be greatly appreciated!

 

Hi,

I'm using Telerik Reporting Tools version 3.44.1.0 on Visual Studio 2017.

I converted a few of my report parameter data sources from Current Data Sources to Report Data Sources by creating a class as described here (these are data sources that'll be used across multiple reports):

https://docs.telerik.com/reporting/data-source-how-to-add-project-data-source.

I used the Wizard to create the data source and the query works within the Wizard, but once I try to open the report I get the "ConnectionString property has not been initialized" error message.

I've verified the connection string is present in the app.config and I was using the same connection string within the Current Data Sources.

Example below:

namespace ReportLibrary
{
    public partial class ExchangeDateDataSource : Telerik.Reporting.SqlDataSource
    {
        private void InitializeComponent()
        {
            // 
            // ExchangeDateDataSource
            // 
            this.ConnectionString = "Reports.Properties.Settings.IOConnection";
            this.SelectCommand = "dbo.uspSelectExchangeRatesLkUp";
            this.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;

        }
    }
}

Anything I'm doing wrong? Thanks.