This is a migrated thread and some comments may be shown as answers.

Telerik.Reporting.Table from code level

18 Answers 968 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

18 Answers, 1 is accepted

answered on 13 Nov 2009, 05:08 PM

Hello Michal,

The Table / Crosstab report item is not a mere grid of cells and has a very complex internal structure. The Report Designer does a great deal of work to simplify common tasks, such as creating the table structure/ adding/removing column/rows, merging cells etc from the table, but the underlying code is far from trivial to post it here. Could you, please, be more specific about what are you trying to accomplish? Perhaps there is a simple solution to your problem, that does not involve a lot of coding.

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 18 Nov 2009, 01:50 PM

Hello Michal,

Probably the easiest way to create a crosstab with Telerik Reporting is to use the Crosstab Wizard. Simply drag the item called "Crosstab Wizard" from the toolbox to your report and the wizard will start automatically. I am not quite familiar with your specific scenario, but from the provided screenshot it appears you need a very simple crosstab with a single row group and a single column group that aggregates some data. If you still have trouble creating your crosstab with the wizard, could you please elaborate on what are your specific requirements, so we can provide you further assistance?

Regarding the alternating colors of the crosstab columns: this can be accomplished rather easily with conditional formatting without any coding on your side at all. The Crosstab report item supports the ColumnNumber and RowNumber build-in functions which can be used in a formatting expression. The following KB article discusses this technique in-depth. The provided example is about alternating rows of a report, but this works exactly the same way for the crosstab.

Best wishes,
Ivan
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 23 Nov 2009, 01:25 PM

Hello Michal,

The error you receive in the designer looks like something that can happen if you have different assembly versions in your project. Please use the Upgrade Wizard to make sure all assemblies and references are the correct version. Also if you have more than a single version of Telerik Reporting available on your machine, make sure you use the correct toolbox item when dragging items in the designer i.e. it is incorrect to drag & drop an item from Q2 onto Q1 designer and vice versa.
This is the only reason we can think of that could cause such error message which is not even correct as you can cast the CrossTab to Table.
As for doing this with the crosstab item directly, this is not a problem as you have a single row group and column group aggregating some data. What is your goal/specific requirements that you cannot accomplish with it/need guidance, so we can provide you further assistance?
We would appreciate any additional information you could provide, if still having problems.

Sincerely yours,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 28 Oct 2010, 02:18 PM

screen1.png

screen2.png

Hello Sasan,

Thank you for the clarification. The problem is coming from the fact you're trying to apply this conditional formatting to the crossTab item itself, when it should be applied to the cells in the body of the crosstab (see attached screenshots).

All the best,
Steve
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

answered on 28 Oct 2010, 03:46 PM

Thanks for your response. So I tried putting the conditional formatting rule on the crosstab Cell instead of the whole crosstab. That makes sense to me. When I did this, I did not get any errors, but I am not seeing the effect of the rule either. Is there something overriding the conditional formatting? I don't have a css style sheet set up for the report, so that can't be affecting it. I am adding the values to the crosstab in the needdatasource event as follows:

private void crosstab2_NeedDataSource(Object sender, EventArgs e)

{

  Telerik.Reporting.Processing.Table crosstab2 = (Telerik.Reporting.Processing.Table)sender;



  string

sql =@"Here is my query"

string connectionString = "my connectionstring"

;

  MySqlDataAdapter adapter =

new

MySqlDataAdapter(sql, connectionString);

  DataTable myDataTable =

new

DataTable();

  adapter.Fill(myDataTable);

  crosstab2.DataSource = adapter;

}

On the design side I'm not doing anything special. I added some background colors to cells. I don't have any background images. Is there any guidance you can give me? If you need any additional information please let me know. Thanks.

answered on 28 Oct 2010, 04:28 PM

crosstab.zip

Hi Sasan,

I've attached the modified CrossTab demo report I've used to show you how to achieve this functionality. Paste it in the C:\Program Files\Telerik\Reporting Q2 2010\Examples\CSharp\ReportLibrary\Crosstab folder and check its settings.

All the best,
Steve
the Telerik team

answered on 01 Nov 2010, 05:56 PM

Hi Sasan,

Place the RowNumber() function as Value for the textbox in the CrossTab body and see whether it returns the expected result. I suspect that you have set the conditional formatting to a textbox that is part of a static row group, thus it would be displayed once only. For more information on Table item structure review the following articles:

Greetings,
Steve
the Telerik team