Hello.

I need your help please. first my development conditions are limited. i can't use the Design tap just use program code. bcs does not work a sqlDataSource tool in Telerik. to connect a DB server only use our cust command. retrun type is a DataTable when use cust command.

so i found tip and succeeded by reference this code.

------------------------------------------------------------------------------------------------------------

private void table1_NeedDataSource(object sender, EventArgs e)
{
  //HttpContext context = HttpContext.Current;    // If you need the table from Session
  //DataTable dt = (DataTable)context.Session["data"];

  DataTable dt2 = new DataTable();
  dt2.Clear();
  dt2.TableName = "name table 2";
  dt2.Columns.Add("column1");
  dt2.Columns.Add("column2");
  DataRow _rowAdd = dt2.NewRow();
  _rowAdd["column1"] = "11";
  _rowAdd["column2"] = "55";
  dt2.Rows.Add(_rowAdd);

  _rowAdd = dt2.NewRow();
  _rowAdd["column1"] = "22";
  _rowAdd["column2"] = "33";
  dt2.Rows.Add(_rowAdd);

  _rowAdd = dt2.NewRow();
  _rowAdd["column1"] = "aa";
  _rowAdd["column2"] = "bb";
  dt2.Rows.Add(_rowAdd);

  //if you need to rename the columns:
  //for (int k = 0; k < dt.Columns.Count; k++)
  //{
  //    dt.Columns[k].ColumnName = dt.Columns[k].ColumnName.ToLower().Replace("|", "").Replace(" ", "").Replace("\", "");
  //}

  table1.DataSource = dt2;

  Telerik.Reporting.HtmlTextBox textboxGroup;
  Telerik.Reporting.HtmlTextBox textBoxTable;
  table1.ColumnGroups.Clear();
  table1.Body.Columns.Clear();
  table1.Body.Rows.Clear();
  int ColCount = dt2.Columns.Count;
  for (int i = 0; i <= ColCount -1; i++)
  {

    Telerik.Reporting.TableGroup tableGroupColumn = new Telerik.Reporting.TableGroup();
    table1.ColumnGroups.Add(tableGroupColumn);
    tableGroupColumn.Name = i.ToString();  //very important this "Name" because of a Telerik bug is needed
    textboxGroup = new Telerik.Reporting.HtmlTextBox();
    textboxGroup.Style.BorderColor.Default = Color.Black;
    textboxGroup.Style.BorderStyle.Default = BorderType.Solid;
    textboxGroup.Value = dt2.Columns[i].ColumnName;
    textboxGroup.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));
    tableGroupColumn.ReportItem = textboxGroup;
    textBoxTable = new Telerik.Reporting.HtmlTextBox();
    textBoxTable.Value = "=Fields." + dt2.Columns[i].ColumnName;
    textBoxTable.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));
    table1.Body.SetCellContent(0, i, textBoxTable);
    table1.Items.AddRange(new ReportItemBase[] { textBoxTable, textboxGroup });

  }
}

------------------------------------------------------------------------------------------------------------

When i have succeeded up to screen is 'now.png' file and what I want here is a SEQNO cell merge. like 'want.png'

And return table is dynamic. often change a rows of a SEQNO and SUBNO column.

i found cell merge tip in this fourm. but other tips used a Design tap or not dynamic table.

I could not find to code it. so i need help.

Thank you.

Tried to migrate .net frame work version from 4.0 to 4.5.2 and telerik verik version to 16, then I am seeing the below issue for SSRS reports.
Telrik report chart size is not rendering as per the zoom percentage(%) selected. The Chart size is always rendering as 100%, The telerik chart size is fixed to 100%
irrespective of selected zoom percentage. If we select 150% or morethan 150% it is moving to left side in the reportviewer and if I select the zoom percentage is below 100%,
the chart is moving to right side (eg:I selected 10% as zoom, the chart report is rendering as 100% and moving little bit right from the center). The report viewer is inside the table.
I tried below things but nothing woked out.
1. I have changed the width and height styles
2. Removed table and added reportviewer in side the div.
3. tried with AsyncRendering="False/true" SizeToReportContent="True/false" but nothing works.

How do I change the query timout limit value in Telerik Reporting?

In telerik grid I would set
e.command.commandtimeout = 0

is there a command like that for the reporting module also?

Hi,

I am trying to do a Nominal lodger activity report where there is a self referencing hierarchy for the rows and years/months for the columns.  The data is a sum of all transaction values.

I can get the data into a cross tab report but how would I go about making the row groups work with a self referencing hierarchy?  I'd have thought that this was a fairly common requirement but unfortunately I can't find any prior examples of this.

Regards

Jon

i would like to draw a line and put values above and below line like graph in Telerik report




                     3.4              4.6         2.1                                           3.2
             0---------------------------------------------------------------------------------- 100

                     10              25           45                                             95


pls help  

Hi

I need to show a list of people in alphabetical order,but the actual details displayed, such as text boxes / labels are laid out differently depending on one particular column, UserTypeId e.g.

User 1
User Type 1 details | more details
-----

User 2
User Type 1 details | more details

-----

User 3
User Type 2 different details
User Type 2 more details | even more details
-----
User 4
User Type 1 details | more details

etc..

The layouts for each user type are quite specific so a simple table would not work.

My thinking is to create a sub-report for each user type, but what is the best way to dynamically render this sub-report based on the user type value? Can this be achieved through data-binding, or would it be best to take complete programmatic control of the report?

Regards,

Dan.

Hi,

I have a requirement to generate a report for badges of attendees for a conference.

The requirement calls for an A4 print out of 4 badges in a 2x2 grid, so that each bade is effectively A6 size.

There is an additional requirement to have a single attendee details repeated per row.

Do you have any pointers as to the best way to achieve this?

e.g.

 

 

Hi

 

I am trying to only show a section on the last page of my document using the PageNumber = PageCount expressions. However it only seems to work in the page footer and header.

 

I have seen other people run into this issue before on your other forums. Was wondering if there has been an update or a fix i can implement myself.

 

 

Any help would be much appreciated.

 

Regards,

Sam

Hello,

I handle user inputs thru combo box and construct SQL based on the combo box selected values and create dataset and assign it to the report.

When I call the reports first time, it shows the values correctly.

When changed the values of combobox, it displays the report for previously seleted value of the combobox. This behavior is quite consistent.

I check few values during the page load event and based on that i call a function to generate SQL and call report using new report().

Is it a caching issue? How can this be solved?

Thanks
Sundar

Hello,

•  When i generate report in the Report viewer and close that page.
•  When i reopen the page, it shows me the last created report. I want to refresh the

          report viewer on page_load().



Thanks,
Jaspreet.