Telerik Forums
Reporting Forum
1 answer
551 views
Hey,

for our project we use some data to generate general reports about events happening. For this we have a master report containing header and footer and specific reports for various data. We are using a table to display our data and when trying to fill the table it tries to fit as many entries on one page as possible and this, however, leads the first page being almost empty with only the header and the title on it. The data that exists is displayed on the next page. Setting the property "KeepTogether" to false of the table lead to no results. It seems like the table checks if there is enough space to fit in all data available on a single page doesn't matter whether it's the first page or not and if so it adds it there. (See screenshots)

So my question is if there is a way to tell the table to insert the data without checking if it can be made fit on one page? 

Thanks in advance,
Alen
Peter
Telerik team
 answered on 16 Jan 2015
11 answers
440 views
Is it possible to capture a click event in a cell of a report Telerik?
Peter
Telerik team
 answered on 16 Jan 2015
1 answer
193 views
We have an application that uses both telerik winforms controls (Q2 2011) and telerik reporting (Q1 2011) that is deployed using ILMerge to create a single exe.  The application works fine in debug, release, and deployed VIA a setup program.  However, the exe created by ILMerge generates the following error when I try to render a report or display the report in the winforms report viewer:

System.ArgumentException: Extension of type 'Telerik.ReportConverter.ActiveReports.ActiveReportsConverter' does not have name specified.
   at Telerik.Reporting.Processing.ExtensionInfo.AssertValidName()

There doesn't seem to be any other issues as I have added "Telerik.WinControls.RadTypeResolver.Instance.ResolveTypesInCurrentAssembly = True" when the first form is initialized.

Does telerik reporting (any version) support ILMerge distribution? 

If so, I have added Telerik.ReportViewer.Winforms.dll and Telerik.Reporting.dll to our ILMerge script but are there any other dependent files for telerik reporting?
Nasko
Telerik team
 answered on 15 Jan 2015
3 answers
1.8K+ views
Hi,

I have a tabular report. I have two tables inside the report. one displays summary and another displays details. Both tables are poiting to different datasources.

Now I want to display one db field value from one of the dataset into header part. I have added new textbox but I am not able to see any fields to be added into textbox in the expression window.

I have identified that when we set report datasource property, we can see the datasource fields in the textbox expression but if I add that it messes up my report as I have two tables and both have different datasets.

Please advise how to get db field value in textbox without setting datasource property of the report. I have two datasets added to the report and both are set to different table.

Thanks,
Hardik
Candice
Top achievements
Rank 1
 answered on 15 Jan 2015
1 answer
275 views
-My project is asp.NET MVC 4 web application.
-My project use VS integrated designer with report templates being .cs files.
-My project still use old ASPX report viewer.

I want to set specific fonts and other 'Style' properties for each localized culture. (for example, I want to use Font_A as default, Font_B for en-US and Font_C for en-GB.)

I tried localizing them the normal way like how I localized the texts. (Starting from changing 'Localizable' property to True and switch 'Language' property to put the localized text in, which in this case, set a font specific for that culture)

The problem is, the designer didn't count changing 'Style' properties as a part of localization and didn't store the data in .resx files.

Any solution or work-around?

PS. I don't want to change into new version.
Hinata
Top achievements
Rank 1
 answered on 14 Jan 2015
3 answers
158 views
Hi,

we have the following use case: we want to render reports (made by the standalone report designer, that means TRDX files) as RTF or DOCX files and display these output files in a browser embedded texteditor. So that the user can change the content of the report as he/she likes. In the main use case the reports would be predefined letters (in which the user is able to change the content).

My questions are:

1. Is it possible to export metadata into the output RTF or DOCX file? Examples for metadata would be: information about the data source (what data is displayed), used aggregate functions, inserted sub reports etc. This metadata we would like to show in the texteditor at the respective site (e.g. somehow highlighted or in a tooltip).

2. Is it possible to use the Telerik HTML Editor for this purpose?

Thanks,
Felix
Nasko
Telerik team
 answered on 14 Jan 2015
4 answers
485 views
I have a tabular report. Report has below casecading parameters.

Country
City

City parameters fills the value based on the country selection. both are database driven.

When I changed the default value of any of these parameters, it gives me below error and filter is not working properly.

"Collection was modified, enumeration operation may not execute"

Please advise. I am new to telerik reporting.

Thanks in advance.
Hardik
Top achievements
Rank 1
 answered on 14 Jan 2015
1 answer
158 views
Hello.

We have created a custom ADO.Net provider that accesses web service and returns a DataTable object. I have successfully inorporated into the Report Designer and everything works fine except when we have a parameterized SQL statement. When you create a data source with SqlClient Data Provider and it has a parameterized SQL statement a Data Source Parameters dialog box shows up where you can specify data types and default values. 

The command class is inherited from DbCommand and adds parameters when CommandText was changed:
public class AbstractCommand : DbCommand
{
        private string commandText;
        private AbstractParameterCollection parameters;

...
        public override string CommandText
        {
            get
            {
                return this.commandText; 
            }
            set
            {
                this.commandText = value;
                this.CreateParameters();
            }
        }

        protected override DbParameterCollection DbParameterCollection
        {
            get 
            {
                if (this.parameters == null)
                {
                    this.parameters = new AbstractParameterCollection();
                }

                return this.parameters;
            }
        }

        private void CreateParameters()
        {
            this.Parameters.Clear();
            if (this.commandText == null)
            {
                return;
            }

            string[] lines = this.commandText.Split(new char[] { '@' });
            for (int i = 1; i < lines.Length; i++)
            {
                string line = lines[i];
                string[] split = line.Split(new char[] { ' ', '\t' });
                if (split.Length == 0)
                {
                    continue;
                }
                split = split[0].Split(Environment.NewLine.ToArray());
                if (split.Length == 0)
                {
                    continue;
                }
                this.Parameters.Add(
                    new AbstractDataParameter()
                    {
                        ParameterName = "@" + split[0],
                    });
            }
        }
}

I have comfired that the parameters are populated correctly and the dialog box still don't how.

FYI, the config file has this:
<system.data>
    <DbProviderFactories>
        <add name="Local Abstract Data Provider"
             invariant="LocalAbstractDataProvider" 
             description="Data Provider for Netsmart VR" 
             type="LocalAbstractDataProvider.AbstractDbProviderFactory, LocalAbstractDataProvider, Version=1.0.0.0" />
    </DbProviderFactories>
</system.data>  

Do you have any idea?


















Shoji Kaburagi
Top achievements
Rank 1
 answered on 13 Jan 2015
1 answer
279 views
Hello together

I have two nearly identical reports and in both the same problem:
I've got three subreport items side by side but even when I put them next to each other there are horizontal spaces between the three subreports.
The subreport items' sizes match the actual report sizes and I already tried making the subreport items a bit wider than the actual reports.
I even had the problem that the right margin of the 3rd subreport item didn't fit right below the line above even though in the designer they were aligned properly.
This one I was able to fix (don't know how exactly) but the spaces between the reports I wasn't able to fix.

Thanks for any help
Nasko
Telerik team
 answered on 13 Jan 2015
3 answers
376 views
Hi ,

I have a table created from a table wizard  and now i want to insert a subreport below it  based one of its fields.

CustomerId Customer Report
Sub report related  to  Each customer ID

I have done the passing of the Customer ID field to the Subreport  customer Id  filter....but   an error keeping coming saying

Exception: Invalid value of report parameter 'CustomerID'.]

Can anyone throw some light on it please?

 
Nasko
Telerik team
 answered on 13 Jan 2015
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?