Telerik Forums
Reporting Forum
2 answers
177 views
I use localization of reports using the property Localizable=true which is great. The problem is, that I use a lot of expressions in TextBoxes like value=Fields.Info which I want them to stay in original, but they appear in resx file too. I am affraid, that external translator might traslate these expressions and made the report unusable.
Is there any way, how to sign some TextBoxes as "not for localization" to prevent traslation and extraction  to resx file? For instance, aout of 11 TextBoxes I need translate only 3. 

Thank you for help.
Michal
Michal
Top achievements
Rank 1
 answered on 28 Nov 2012
5 answers
189 views
Here's My data:

Account Fund    Amount      Group
Acct1   Fund1   $20     1
Acct1   Fund2   $30     1
Acct1   Fund3   $40     2   
Acct1   Fund4   $50     2
Acct2   Fund1   $60     1
Acct2   Fund2   $70     1
Acct2   Fund3   $80     2
Acct2   Fund4   $90     2

I've created a crosstab report that looks like this:

    Fund1   Fund2   Fund3   Fund4
Acct1   $20     $30     $40     $50
Acct2   $60     $70     $80     $90

I created a group for my "Group" column, but then my report includes all of the fund columns like this:

Group 1
    Fund1   Fund2   Fund3   Fund4
Acct1   $20     $30     0       0   
Acct2   $60     $70     0       0   
  
  
Group 2
    Fund1   Fund2   Fund3   Fund4
Acct1   0       0       $40     $50
Acct2   0       0       $80     $90

But what I want is the report to look like this:

Group 1
    Fund1   Fund2   
Acct1   $20     $30 
Acct2   $60     $70 
  
  
Group 2
    Fund3   Fund4
Acct1   $40     $50
Acct2   $80     $90

How do I do that?
Elian
Telerik team
 answered on 28 Nov 2012
4 answers
179 views

Hi,

I have report with one chart. I would like to have chart with dynamic series.

My dataset (attachment): 00ds.png

My C# code:

customChart.DataGroupColumn = "Status";
customChart.PlotArea.XAxis.DataLabelsColumn = "Quarter";

I've got some strange chart as a result: 01.png. Some series are assigned incorrect. For example, in the Q1 there is "Deleted" with value 10, but it should be in the Q3.

I would like to get something like this: 02.png (note that Q3 and Q4 are changed in the X axis).

Is it possible?

Thanks,

Rafal

Elian
Telerik team
 answered on 28 Nov 2012
4 answers
273 views
Is there any way to achieve the following report?

The report should have the following:
1. a header that should show up only on the first page, and it should extend over the complete width of the page (i.e.. it will cover both columns in the detail section below).
2. a detail section with 2 columns.

I tried the following but did not work:
1. page header, since I can not restrict it to the first page only.
2. report header and group header, both will follow the 2 columns structure and will not extend over the complete page width.

Any help will be appreciated, thanks.
Nate
Top achievements
Rank 1
 answered on 27 Nov 2012
3 answers
105 views
Hello,

I'm not able to separate the bars to display according to the label. How can I separate a bar the other?
Steve
Telerik team
 answered on 27 Nov 2012
1 answer
360 views
Hello,

As a feasibility study on whether the Telerik Reporting control is fit for our purpose, we're trying to create the above and have downloaded / tweaked some sample code from this forum but the final solution is not getting us where we want to be.

I want to add columns to a table object at runtime
  • the table will have
    • column headers
    • groups
      • each group will have a
        • group header
        • group footer and
        • a subtotals column (on a quantity column)

The core of the code is shown below

The group headers / footers are NOT displaying - once this is accomplished the rest should be easy 

Telerik gods we beg you, please tell us what we're doing wrong!!!

 

//DataSet passed in as parameter

 

foreach (DataColumn dc in reportDS.Tables[0].Columns)

{

 

//Add table column group

 

TableGroup tableGroup1 = new Telerik.Reporting.TableGroup();

tableGroup1.Sortings.Add(

 

new Sorting(grpTitle1, SortDirection.Asc));

tableGroup1.Name =

 

Group1";

 

//tableGroup1.Groupings.Add("1=1");

 

 

//tableGroup1.Groupings.Add(new Grouping());

tableGroup1.Groupings.Add(grpTitle1);

this.table1.ColumnGroups.Add(tableGroup1);

#region Grouping

 

 

if (!groupingAdded)

{

 

Group group = new Group();

Grouping groupExpression = new Grouping(grpTitle1);

group.Groupings.Add(groupExpression);

group.Sortings.Add(

 

new Telerik.Reporting.Sorting(grpTitle1, Telerik.Reporting.SortDirection.Asc));

group.GroupHeader =

 

new GroupHeaderSection();

group.GroupHeader.Height =

 

new Unit(10.0, UnitType.Mm);

group.GroupHeader.Style.BackgroundColor =

 

Color.LightSteelBlue;

Telerik.Reporting.

 

TextBox tbxGroupHdr = new Telerik.Reporting.TextBox();

tbxGroupHdr.Value =

 

"=" + grpTitle1;

tbxGroupHdr.Size =

 

new SizeU(new Unit(10, UnitType.Mm), new Unit(30.0, UnitType.Mm));

group.GroupHeader.Items.Add(tbxGroupHdr);

group.GroupFooter =

 

new GroupFooterSection();

group.GroupFooter.Height =

 

new Unit(10.0, UnitType.Mm);

group.GroupFooter.Style.BackgroundColor =

 

Color.LightYellow;

Telerik.Reporting.

 

TextBox tbxGroupFtr = new Telerik.Reporting.TextBox();

tbxGroupFtr.Value =

 

"Group Footer";

tbxGroupFtr.Size =

 

new SizeU(new Unit(10, UnitType.Mm), new Unit(30.0, UnitType.Mm));

group.GroupFooter.Items.Add(tbxGroupFtr);

 

this.table1.Report.Groups.Add(group);

groupingAdded =

 

true;

}

#endregion

 

 

//Add table body column

 

//this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Unit.Inch(1)));

txtColumnHdr =

 

new Telerik.Reporting.HtmlTextBox();

SetTextboxStyle(count, columnCount, dc.ColumnName, fntHdr,

 

TextBoxType.Group, ref txtColumnHdr);

tableGroup1.ReportItem = txtColumnHdr;

               

 

 

txtColumnBdy =

 

 

new Telerik.Reporting.HtmlTextBox();

SetTextboxStyle(count, columnCount, dc.ColumnName, fntBdy,

 

TextBoxType.Item, ref txtColumnBdy);

 

this.table1.Body.SetCellContent(0, i++, txtColumnBdy);

 

this.table1.Items.AddRange(new ReportItemBase[] { txtColumnHdr, txtColumnBdy });

count++;

}



IvanY
Telerik team
 answered on 27 Nov 2012
7 answers
207 views
Hi,

I tried to put a sub report in a list of 3 items,  but the subreport only took the information from the first item and repeated for 3 times.

Im not sure what I have missed.  Could you provide me an sample project to help me set it up?  Much appreciated!


Regards,
Bill 
Roland
Top achievements
Rank 1
 answered on 27 Nov 2012
5 answers
526 views
I am experiencing a very peculiar issue using the Telerik Reports(version 2012 Q1) on an ASP.NET 3.5 web application . The same reports as well as the other controls on the ASP.Net page function properly when there is less data but when there are a lot of rows(1000 or so) on the report's table it does not get rendered properly. Some of the data appears at random position in the report viewer. Even the header gets shifted to the bottom of the report. Besides this the rest of the ASP.NET page controls stop functioning correctly for example the buttons do not interact normally any longer.

It seems like the data in the report viewer is not getting formatted properly because of the large number of rows resulting in corruption of HTML output. Can you please help us troubleshoot and resolve this issue? As I understand there is no in-built paging on the report viewer leading to all the data being pulled at once is there any way to develop the report to render fewer items at a time?
Robert Michels
Top achievements
Rank 1
 answered on 26 Nov 2012
4 answers
291 views
I'm trying to connect to an Entity Model using an EntityDataSource but I'm struggling to work out how to do this.

I get to the "Choose Your Data Connection" bit and I "Specify a new connection string" ...

metadata=res://*/MyDB.Model.csdl|res://*/MyDB.Model.ssdl|res://*/MyDB.Model.msl;provider=System.Data.SqlClient;provider connection string="Data Source=MyServer;Initial Catalog=MyDB;Persist Security Info=True;User ID=MyUser;Password=MyPassword;MultipleActiveResultSets=True"

Then I select "Yes, save this connection string with the following name" ...

But then the "Choose an Object Context" dialog is blank.

How does the Report Designer know where to get this? There is no mention of referencing the assembly (MyDB.Model.dll) containing the csdl, ssdl and msl files?

Please don't refer me to any of these ...
http://www.telerik.com/help/reporting/entitydatasource-wizard.html
http://www.telerik.com/help/reporting/entitydatasource-retrieving-data-from-an-entity-data-model.html
http://www.telerik.com/help/reporting/entitydatasource-connecting-to-entity-data-model.html




Darryl
Top achievements
Rank 1
 answered on 26 Nov 2012
5 answers
1.8K+ views
Hi All,

I am getting a very weird error that only appears when I refresh a report or try to export it.  I am guessing that both times the code behind is doing the same requery on the db or something.

The error is: An error has occured while processing Report '':
member

I have no idea where the member bit comes from - there are no variables called member.  Any immediate ideas where this comes from?  If not then I'll create a support ticket with the report inside it.

Regards,

Jon
Steve
Telerik team
 answered on 26 Nov 2012
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?