Questions on Reporting Forum

1 answer

96 views

Retreiving data from web service

I am creating a new report which gets it's data from a web service which looks like this:

private ReportDto GetEvaluationReports(Guid evaluationId)

{

var dto = new ReportDto();

var result = (from e in ... ).ToList();

dto.Attributes = result;

return dto;

}

The data provided from the report is fine and everything looks nice untill I have to use the result from the service

The DTO looks like this

public class ReportDto

{

public List<Attribute> Attributes { get; set; }

}

public class Attribute

{

public Guid Id { get; set; }

public string AttributeText { get; set; }

public IQueryable<EvaluationDefinition> DefinitionsQuery { get; set; }

public List<EvaluationDefinition> Definitions

{

get { return DefinitionsQuery.ToList(); }

}

public class EvaluationDefinition

{

public Guid Id { get; set; }

public string DefinitionText { get; set; }

public IQueryable<EvaluationBookmark> BookmarksQuery { get; set; }

public List<EvaluationBookmark> Bookmarks

{

get { return BookmarksQuery.ToList(); }

}

public class EvaluationBookmark

{

}

I now want to have a report which groups by Attributes and has all it's definitions listed underneath them.

I have tried it with =Fields.AttributeText and =Fields.Attributes.AttributeText but had no luck.

Can you please help me
Edit: I am now taking another approach... Instead of generating one dto which hass all the information I generate one with the attribute-definition-bookmark hierarchy and another one which has the summary data also needed... Will post if this works

General Discussions

answered on 07 Jun 2012

1 answer

147 views

Changing font at parameter's label

i have parameters in my report.i cant change label's font on parameters.

any opinion?

General Discussions

answered on 07 Jun 2012

1 answer

128 views

concatenate 2 fields in chart labels

Hello,

I have a bar chart and want to display labels using 2 fields fromDate and toDate
Can u give an exmaple of how can i do this?

Chart1.PlotArea.XAxis.DataLabelsColumn = ?

thanks!
-priti

General Discussions

answered on 07 Jun 2012

1 answer

115 views

Running existing reports

I am having a hard time tracking this down. Perhaps someone can help direct me to where I need to go. I have existing reports on an existing server that I currently access thru an Url (http://server.Reports/Report.aspx?ItemPath=/Directory/ReportName). Is it possible to access these reports thru the Silverlight Report Control and. if so, how do I go about doing it programmatically?

Thanks

General Discussions

answered on 06 Jun 2012

1 answer

230 views

Error Selecting Stored Procedure

Select 'New Report'
Select 'Next' on the Report Wizard
Select 'Current Data Sources' on the left
Select 'Add New Data Source...' on the bottom left
Select 'SQL Data Source'
Select 'OK'
Enter valid connection information
Select 'Next'
Select the 'Stored Procedure' radio option

Error message is displayed 'Expecting non-empty string for 'providerInvariantName' parameter.

FYI, Using the 'Select Statement' radio option, the connection string works without any issue.

Report Designer (standalone)

answered on 06 Jun 2012

2 answers

194 views

Statement of Account with Previous Balance

Hi good afternoon
I have a problem and how I can not solve, I'm trying to make account statement to a client, the particularity of this is that the report should take a customer's previous balance was taken into account in calculating the total of what the customer .

But as I can not do that because to calculate the customer's previous balance, I do a query that brings me the movement of transactions that the customer has not paid yet and add them in doing so I can not bring transactions customer during the time period established in the statement. Why I need 2 Data Sources for fetching a previous balance and one that brings all customer transactions.
As I can do since I'm using a SQL Server database CE 4.0 and Telerik WinForms. For my reports Others fill i use ObjectDataSource for my report in code behind like this
-------------------------------------------------------------------------------------

' Creating and configuring the ObjectDataSource component:

Dim objectDataSource As New Telerik.Reporting.ObjectDataSource()
' GetData returns a DataSet with three tables

objectDataSource.DataSource = vDatos.GetPagos_x_Cliente(gRep3_Cliente_id, gRep3_Fec_Ini, gRep3_Fec_FIn)

Indicating the exact table to bind to. If the DataMember is not specified the first data table will be used.
objectDataSource.DataMember = "GF_PAYS_FOR_CUSTOMER" '

' Assigning the ObjectDataSource component to the DataSource property of the report.

Me.DataSource = objectDataSource

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

so how i use other datasource ??
I attach a picture to describe what I need.

Need help thanks

General Discussions

answered on 05 Jun 2012

0 answers

164 views

Get Textbox Value from ITEMDATABOUND

Hello i have a problem, i want to get the value from one textbox and save the value in a VAR type INT, i try this

**************************************************

Private Sub txt_customer_id_ItemDataBound(sender As System.Object, e As System.EventArgs) Handles txt_customer_id.ItemDataBound  Dim vCustomerID As Integer = Nothing

<br>     vCustomerID = txt_customer_id.Value<br><br>     vRec = vData.GetBalance_Customer(vCustomerID.Value)<br>     vRec.Read()<br><br>      txt_balance_.Value = vRec.Item(

"balance_customer") vRec.Close() End Sub 

************************************************************
but my problen is that " vCustomerID = txt_customer_id.Value " is retrive the name of my field like "=fields.customer_id" i want to get the value

How i solve this ???

General Discussions

asked on 05 Jun 2012

2 answers

306 views

Format Value for textbox

Hi,

I'm setting the value of a text box on the group section Item Data Bound. The text box is formatted to currancy but this is being ignored if I set the value programmatically, is there anyway to format the value to currancy and then set the value of the textbox?

Thanks

General Discussions

answered on 05 Jun 2012

2 answers

144 views

Telerik reporting : chart is not working in web application

Could you please send me a sample code to bind chart programmatically in web application. It is very urgent.

General Discussions

answered on 05 Jun 2012

2 answers

133 views

Dynamic Report and Aggregates

Hi,

Currently, we are using Telerik Reporting for the creation of our dynamic reports. We are generating the reports based on the example you have provided from other threads (AutoGenerateColumns.zip). We have also integrated interactive sorting on our reports. Now, we wish to display the aggregates to the last row of the table depending on the field's data type (we can do it programmatically). Can you provide us an example on how to display aggregates using Table object?

General Discussions

answered on 05 Jun 2012