Telerik Forums
Reporting Forum
2 answers
593 views

We are evaluating the Telerik reporting products and one requirement is that the stand-along designer must be able to connect directly to a SQLite database.

Not knowing whether the report designer is only compatible with a particular version of SQLite , we have installed various versions of it but cannot find any option within the designer to allow us to connect to the database. Searching the forum we found a post for a similar request dated back in 2012 that suggested changing the exe 'config' file but that did not appear to work in our case.

Any help would be greatly appreciated.

 

Chris

 

Chris
Top achievements
Rank 1
 answered on 15 Nov 2016
10 answers
1.9K+ views
Hi,
is it possible to bind a report controls value to an index value like
=Fields.Data[0]

In my report I have a table that is bound to an objectdatasource. I want to bind some of the tables columns to a list of values in the objects using an indexer. Can that be done? I haven't found a way so far.

Thx
Katia
Telerik team
 answered on 15 Nov 2016
7 answers
1.5K+ views
I am using Windows 7, 32 bit Operating System
Microsoft Visual Studio 2010 Premium
and have installed Telerik Q1 2011 SP 1

I've run Visual Studio as an administrator.

While following the instruction in the first telerik getting started video, where we were to create a new Class Library and report, everything went well until I was to insert a text object.

On the video, there were Telerik objects listed in the Toolbox.  All I see are Windows Forms, Data, Components, Printing, and General.  No Telerik category.

I don't have long to see whether Telerik would be an adequate solution for our reporting needs.  Please help. 

Stef
Telerik team
 answered on 15 Nov 2016
2 answers
119 views
How do i assign the value of a picture box to a Bitmap  once it has been retrieved from dataset . I need to crop the white space around it
Stef
Telerik team
 answered on 15 Nov 2016
1 answer
717 views

hi

How To Print Directly To The Default Printer On Clicking On Telerik ReportViewer , without showing window.print() window

 

 

 

Regards,

Chaitanya

Stef
Telerik team
 answered on 15 Nov 2016
1 answer
185 views

Hi,

 I only have installed Telerik Reporting R2 2016 SP1 ,An error occurred when open ReportDesigner.

See Attached.

Stef
Telerik team
 answered on 15 Nov 2016
2 answers
602 views

Hello

when a .trdp file contains custom user function,error information see attached.

Telerik.Reporting.UriReportSource uriReportSource =new Telerik.Reporting.UriReportSource(); 
 uriReportSource.Uri = RootDir + "\\TestReport\\HomePage.trdp";
 Telerik.Reporting.Processing.RenderingResult result =reportProcessor.RenderReport("pdf", uriReportSource, deviceInfo);

Victor
Top achievements
Rank 1
 answered on 15 Nov 2016
2 answers
972 views

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.

Hojun
Top achievements
Rank 1
 answered on 15 Nov 2016
1 answer
177 views

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.
Stef
Telerik team
 answered on 14 Nov 2016
12 answers
2.8K+ views
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?
Graham
Top achievements
Rank 2
Iron
Iron
 answered on 14 Nov 2016
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?