Questions on Reporting Forum

6 answers

127 views

[Solved] Changes to chart properties are reverted after save/build

Hi, I'm facing problem with latest reporting (Q3 2012). I'm trying to format charts on one report, but everytime I save and build, those changes are reverted as if I did nothing.

What I'm trying to change is to:

hide series labels
change series empty value display type
change PlotArea dimension properties (margins, etc.)
change display mode of legend and its positioning

I'm using VS2008, fully patched. In this project, I use Reporting Q3 2012, but I have installed Reporting Q2 2009 SP1 and Reporting Q1 2012.

Is there any way how to fix it myself/known workaround. Thanks in advance.

Daniel

General Discussions

answered on 26 Oct 2012

1 answer

93 views

[Solved] Telerik reporting Chart starting position

Hello, I have a question. Is there some possibility to "Stick" the starting point of my chart to Y-axis? Now it is some free space between Y axis and my chart. You can see an example in attachment.

I will be glad if you could help me.

Regards, Pawel Janda

General Discussions

answered on 26 Oct 2012

5 answers

994 views

How do I get a IReportDocument from a TRDX file?

I'm trying to follow these instructions to directly export reports from their definitions to the end file (Word or PDF) without passing through a viewer. This is the requirement of the application I'm doing.

I know how to obtain the PDF given the IReportDocument, but how do I get an IReportDocument from the TRDX file I just created using the Standalone builder?

General Discussions

answered on 25 Oct 2012

1 answer

197 views

XML DataSource from a field in SQL DataSource

What I want to do is pull a field from SQL that contains XML, parse that XML into a class, then use that as my object data source.
I have sqlDataSource1 that will get the text (XML) field from the DB using my ReportParameter (so it only gets 1 record).
I also have objectDataSource1 that will display the data from my class.
Right now objectDataSource 1 is the Report's datasource.

I also have a NeedDataSource event trigger on the report.

The question is "Can I have the event trigger tell the sqlDataSource1 to go get the data, parse it, then feed it to objectDataSource1 to display on the report?"

This sample shows how to read in an xml file, parse it, then feed it to data source to display. So I imagine I should be able to do it. Does someone do the same thing? Am I going about it the hard way?

General Discussions

answered on 25 Oct 2012

1 answer

189 views

how to specify connection string for detail report

Hello TElerik,

My web application enables a user to choose database at runtime. I have a more connection strings in a web.config.

Selected connection string key is stored in a session.

I can read this key during loading a page with a report web viewer.

My main report is accepting connection string parametr using its constructor, but I dont know, how to specify this for a details subreports.

Can you advice me how to solve this?

Thank you very much.

Tom

General Discussions

answered on 25 Oct 2012

1 answer

240 views

dynamic report with many tables

I am trying to build a dynamic report with many tables which have different columns definition.

My source is a list of data table

My code is:

public EntregaReport()

{

InitializeComponent();

var list = Entrega.GetEntregaDocumentos("BERK_122");

HtmlTextBox textboxHeader;

HtmlTextBox textBox;

foreach (DataTable dataTable in list)

{

Table table = new Table();

//SetTableProperties(ref table);

detail.Items.Add(table);

table.ColumnHeadersPrintOnEveryPage = true;

table.DataSource = dataTable;

Telerik.Reporting.HtmlTextBox textboxGroup;

Telerik.Reporting.HtmlTextBox textBoxTable;

table.ColumnGroups.Clear();

table.Body.Columns.Clear();

table.Body.Rows.Clear();

int colCount = dataTable.Columns.Count;

for (int i = 0; i <= colCount - 1; i++)

{

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

table.ColumnGroups.Add(tableGroupColumn);

table.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Unit.Inch(1)));

textboxGroup = new Telerik.Reporting.HtmlTextBox();

textboxGroup.Style.BorderColor.Default = Color.Black;

textboxGroup.Style.BorderStyle.Default = BorderType.Solid;

textboxGroup.Value = dataTable.Columns[i].ColumnName;

textboxGroup.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));

tableGroupColumn.ReportItem = textboxGroup;

textBoxTable = new Telerik.Reporting.HtmlTextBox();

//textBoxTable.Style.BorderColor.Default = Color.Black;

//textBoxTable.Style.BorderStyle.Default = BorderType.Solid;

textBoxTable.Value = "=Fields." + dataTable.Columns[i].ColumnName;

textBoxTable.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));

table.Body.SetCellContent(0, i, textBoxTable);

table.Items.AddRange(new ReportItemBase[] { textBoxTable, textboxGroup });

}

It´s seems the tables are created but the data is not bind, do I miss something.

Thanks Jochanan

General Discussions

answered on 25 Oct 2012

7 answers

274 views

"Report is unavailable or session has expired" after web deployment

Help! I am supposed to demo some reporting tomorrow but after deploying to my web server I get the error:

"Report is unavailable or session has expired"

The reports are built into their own class library. Then I use the report viewer in a web page to view the report.

This works perfectly on my development machine running locally. But, after compiling and deploying I get the above error.

Help!!!

General Discussions

answered on 24 Oct 2012

1 answer

117 views

Deserializing to specific base class

Hi guys,

is it possible to serialize/deserialize using ReportXmlSerializer from/to specific report base class?

Core problem is that I need to access IDictionary in my report. Because of that I introduced user function that helps to solve this. But user function must be placed in an assembly where the actual report is placed. My report is xml serialized, so I have decided to create common base class which will change the assembly where telerik is searching for user functions. And there I stand in front of the problem that ReportXmlSerializer does not seems to support specific report base class.

Thanks for answers

General Discussions

answered on 24 Oct 2012

2 answers

567 views

Carriage Returns & Line Feeds Are Removed from Textbox

Telrik Reporting Forum…

First, I would like to commend you in developing a great tool for developing Web based reports. A lot easier than generating the HTML and DB calls. Bravo!

The reason I am writing is I have an issue that seems common when I Google it and browse Telerik Forums, but I haven’t found the solution that will resolve it for the Customer Service Application I developed.

Basically, I pull note data from my SQL Stored Procedure that has embedded carriage returns and line feeds. The data is then bound to a textobox control on the report. When the report is viewed, the carriage returns and line feeds are not retained, so all the text is ran together.

I am thinking, but not sure exactly how to to it, I have to some how strip the the carriage returns and line feeds and replace them before rendering control. The thing is, since I can't see these characters, I am not sure what to search for.   Some of the note data is copied from Outlook E-Mails, maybe Word and pasted in the note field prior to saving the database.

1. With that said, what is best approach for my situation?
2. What event do I need to place code in do the search/replace?
3. What Telerik Report Control should I use?

The Technical Specs are as follows:
ASP .net 4   VB
SQL 2008 DB
Telerik Q3 2001

Thanks In Advance

General Discussions

answered on 23 Oct 2012

2 answers

94 views

Change position itens toolbar telerik

Good morning,
Well, I have a problem where I would like for more than two items per line in the report barrade tools.
Follow the image for better understanding.

link for image

Sorry for my english google.

General Discussions

answered on 23 Oct 2012