Questions on Reporting Forum

3 answers

54 views

Adding text to corner of report in Silverlight Report Viewer

I'm trying to add some text to the top right corner of my report but it's causing the size of the corner to grow absurdly tall. My reports are completely dynamic but I'll narrow it down to one specific case. It has one row group and one column group that has a child. I set the corner like so

table.Corner.SetCellContent(0, 0, new TextBox

{

//Value = "Sum",

StyleName = "HeaderCell",

     Height = new Unit(1),

     Width = new Unit(1),

Style =

{

VerticalAlign = VerticalAlign.Top

}

}, rIndex, cIndex);

Where rIndex and cIndex are the number of rows and columns (2 and 1 in my example). It works perfectly with the code above but if I simply uncomment the Value to try to get it to say "Sum" the Corner grows huge. Like 5 inches of blank space. I've checked in the debugger and none of my Height values have changed. Everything is set to what I specifically set it to. Please keep in mind I won't be using the designer.

General Discussions

answered on 03 Jun 2014

1 answer

164 views

HTML5 Reporting Bar Graph Dynamic Colour

I am using VS2013 to design my report which I am then using in a MVC4 app with the HTML5 Report Viewer.
I have an objectDataSource which returns a list of object which have a total, name and a colour.
I can get the graph up but I don't see how to make each bar on the graph become the colour I have set in the object.
Also the series seem to be out of order

Is there a way to do this?

General Discussions

answered on 03 Jun 2014

1 answer

983 views

hide a table column

hello,
how do I hide a column in a table, depending on the parameter value?

grateful,

Carlos Carvalho

General Discussions

answered on 03 Jun 2014

4 answers

932 views

Start report with zoom to width as default

Hi,

is any possibility to start telerik report (in wpf) with zoom to set into "fit width"?

General Discussions

answered on 02 Jun 2014

1 answer

52 views

save and load report with fields

I would like to be able to 'save' a report from the web backend and 'load' it in a WPF client app to print it.
I only know about the serialization and deserialization of reports using ReportXmlSerializer but this is saving \ loading report definition (without fields).

Is this possible with Telerik Reporting?

General Discussions

answered on 02 Jun 2014

2 answers

130 views

Cannot get a report to show via ReportViewer

I have been trying to get a basic report to show up on a test page using the Telerik Reports (Trial) product, but am unable to be successful. I have retrieved the data (in various scenarios) and bound it to the ReportViewer, but nothing shows up (not even my columns). Am I missing something? Code Below:

01.protected void Page_Load(object sender, EventArgs e)

02.{

03. if(!Page.IsPostBack)

04. {

05. string strFakeToken =

"0x00C1F7F02751764B9E03D36DC1F10C2E010000004D5FE0DA32126BFFD53944A657C59323ED483AA729D6C109632DBD0A56662191094CD17AA16E5BFAFB30C557E4F7F133"

;

06.

07. System.Text.ASCIIEncoding encoding = new System.Text.ASCIIEncoding();

08. byte[] myByteRep = encoding.GetBytes(strFakeToken);

09.

10. Telerik.Reporting.SqlDataSource sdr = new Telerik.Reporting.SqlDataSource();

11. sdr.ProviderName = "System.Data.SqlClient";

12. sdr.ConnectionString = ConfigurationManager.ConnectionStrings["MyDBName"].ConnectionString;

13. sdr.Parameters.Add("@settingID", System.Data.DbType.Int16, 1);

14. sdr.Parameters.Add("@workSpaceID", System.Data.DbType.Int16, 1);

15.

16. sdr.Parameters.Add("@securityToken", System.Data.DbType.VarNumeric, myByteRep);

17.

18. sdr.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;

19. sdr.SelectCommand = "[SOMENAME].[ItemMasterReport]";

20.

21.

22.

23.

24. // Access the Service to pull the Data Reader in the line below

25. IItemMasterReportService imr = new ServiceProxy.ServiceProxy.ItemMasterReportServiceProxy();

26. // Create Data Reader (for use below)

27. IDataReader idr = imr.GetItemMasterReportDataReader(IdentityHelper.CurrentUser.RecentWorkspaceID,1);

28.

29. // Create the Data Table (to be used in the Data Source below)

30. DataTable dt = new DataTable();

31. dt.Load(idr);

32. //dt.TableName = "ItemMasterReport";

33. dt.TableName = "Budget";

34. //dt.TableName = "Capacity";

35.

36. // Create the Data Source (to be used in the Report below)

37. Telerik.Reporting.ObjectDataSource ods = new Telerik.Reporting.ObjectDataSource();

38. ods.DataSource = dt.Rows;

39. //ods.DataMember = dt.TableName;

40. //ods.DataMember = "Budget";

41. //ods.DataMember = "Capacity";

42.

43. // Create the Data Set (not used ??? )

44. DataSet ds = new DataSet();

45. ds.Load(idr,LoadOption.OverwriteChanges,string.Empty);

46.

47. // Build the Report (to be used in the Report Source below)

48. Telerik.Reporting.Report report = new Telerik.Reporting.Report();

49. //report.DataSource = ods;

50. report.DataSource = sdr;

51.

52. Telerik.Reporting.InstanceReportSource irs = new Telerik.Reporting.InstanceReportSource();

53. irs.ReportDocument = report;

54.

55. // Set some basic stuff for UI for diagnostic purposes

56. usertoken.InnerText = IdentityHelper.CurrentUser.Token.ToString();

57. workspaceID.InnerText = IdentityHelper.CurrentUser.RecentWorkspaceID.ToString();

58. settingID.InnerText = "1";

59.

60. rptvwJaredTest.ReportSource = irs;

61. rptvwJaredTest.RefreshReport(); // now that all the sub-work is done, render the report in the report viewer in the UI

62. }

63.}

General Discussions

answered on 02 Jun 2014

1 answer

114 views

Group rows in Table

Hi. I want to create a table with group rows in the second column in Designer. I made group in the first column, but cant do this in the second column. How can I do this?

General Discussions

answered on 02 Jun 2014

1 answer

107 views

How to create multilevel reports in telerik

How I can create multi-level reports using telerik

Reports structure will like this

Subject 1
Sub-subject 1.1
Comment 1
Comments 2

Sub-subject 1.2
Comment 1
Comments 2

Subject 2
Sub-subject 2.1
Comment 1
Comments 2

Sub-subject 2.2
Comment 1
Comments 2

Please provide me any sample link and source code.

General Discussions

answered on 02 Jun 2014

1 answer

82 views

Excel exporting Problem

we are using telerik reports for creating reports.While exporting a report to excel (from report viewer)
its row heading are merged into several ones.Please refer the attachments for more details.

General Discussions

answered on 02 Jun 2014

3 answers

115 views

How to using Chart with CubeDataSource

Hi to all,
I've this problem, I created a CubdeDataSource, my MDX query replay me 4 columns:

Activities
All
Customer
Contact

The first is a dimension that aggregate the visit of salesperson by a particular tipology called Activities (a simple category),
moreover the other dimension is "Type" that has 2 values: Customer and Contact, that aggregates the visits of salespersone based if is customer or contact.
And then the level "All" of dimension "Type" but I'm not interessed.

Now on telerik report I put a char, set a CubeDataSource and specify 2 Series that link to Customer and Contact. Ok!

But now I would show label using Actitivites column. What can I do?

PS: I've attached: result set of MDX query, and chart (evidence in blue)

General Discussions

answered on 02 Jun 2014