Telerik Forums
Reporting Forum
1 answer
323 views
Hi,

I am using table in which I have Items, quantity and price. I have set the datasource of my table using stored procedure. My tables resides in the detail section. After that I placed a textbox control in the report footer section to calculate the total quantity. By using the following expression.
=Sum(Fields.Quantity). But total doesn't appear in the report.

Expalanation in Steps:

1) Table is placed in a detail section (bind with a stored procedure)
2) Textbox in a report footer section to display total. (not appearing  in the report) =Sum(Fields.Quantity)


Items Quantity Price Total

ItemA 2            10       20
ItemB 3              5        15
5 (It is a textbox in a report footer section but it's not displaying the total quantity and appears blank in a report)



Hristo
Telerik team
 answered on 01 Jul 2011
2 answers
304 views
I have a report that has a ReportHeader section that has a couple of fields that I set in code - that aren't populated from a DataSource.

That is, in the designer I put aTextBox in the ReportHeader section, and leave it's value blank.

I'm displaying the report on a web page, using the standard Telerik ReportViewer.  The Website is not running with InProc session.

I set the value in onNeedDataSource() to a value I extract from Session[].  (We simply can't run production websites with InProc session state, so these values and the parameters for the queries that populate the DataSources are passed through Session[].)

The report runs fine.  The fields populate correctly, the detail section populates correctly, and the tables in the ReportFooter that have separate DataSources populate correctly.

But when I print, the fields that are set in code are blank.  Same if I export, or even if I simply hit the refresh button in the ReportViewer.

The fields that are being populated from DataSources are set correctly, these fields that are populated directly are left blank.  When I put a breakpoint in onNeedDataSource(), I see that it is not called, when the report refreshes.  It's like the report is working from remembered data, and that the only data it remembers is what is in a DataSource.

Any ideas as to how I can make this work?  Without going to InProc session state - that's simply not a workable solution.

Jeff
Top achievements
Rank 1
 answered on 01 Jul 2011
1 answer
153 views
We just upgraded to Q1 2011.  Most of our reports are running just fine, we switched out the old reporting dlls with the new ones.  This is a winforms project.  When we open a form and click the report button, the report shows up just fine.  When we click the print button the report viewer toolbar, an error is thrown saying NullReferenceException was unhandled         Object reference not set to an instance of an object.  But when we're debugging, there is no source available, just the error.  We can't figure out why it is just these 2 reports that aren't working when all the other ones are.  Any ideas?
Steve
Telerik team
 answered on 01 Jul 2011
1 answer
656 views
Hi Folks,
I have written a pixel precise (image overlay) report using Reporting Q1 2011 trial. So far so good. After reading the documentation, I decided to create a calculated field for a barcode control. I took an existing field and added some other characters to it. My report is very simple (structure wise) it has a Detail and a report Footer. The field that is using the calculated field is in the Detail section and it will render well in Preview mode (the field is assigned a value from a business object). BUT... when the application is rendered programmaticaly, it fails with "The expression contains object 'BarcodeValue' that is not defined in the current context."

I don`t understand why it works in preview and not when .RenderReport is called.

Thanks

-John
Steve
Telerik team
 answered on 01 Jul 2011
1 answer
81 views
I have a report book being displayed using a silverlight application. The reports generates fine, but when I try to expand my group using the action button nothing happens. if I preview the report under VS, it woks just fine.

I do have a the report viewer in a Radwindow. Does that make a difference ?

Hector
Steve
Telerik team
 answered on 01 Jul 2011
3 answers
246 views
I am trying to use a web service provided by a third party as a datasource in a Telerik Report.  Anyone have a clue how to do that?

So far I have tried attaching it to an objectDatasource and wrote the following code behind (where ODRC_DATA_SERVICE is the web service reference added to the project and getCurrentMedications("A473813") is the method in the Web Service that returns the data.)  BUt so far I've got nuthin'  Tyhe designed can't detect the data source and the report preview, bets the correct number of rows that the service returns, but does not display any data.

Thanks in advance,

Rick Riedel

private

 

 

void GetCuurMedRpt_NeedDataSource(object sender, EventArgs e)

 

{

 

 

//try

 

 

 

//{

 

 

 

ODRC_DATA_SERVICE ws = new ODRC_DATA_SERVICE();

 

Telerik.Reporting.Processing.

 

Report report = (Telerik.Reporting.Processing.Report)sender;

 

report.DataSource = ws.getCurrentMedications(

 

"A473813");

 

 

 

 

//}

 

 

 

//catch { }

 

 

 

//finally { }

 

}

 

 

private void GetCuurMedRpt_ItemDataBound(object sender, EventArgs e)

 

{

textBox1.Value =

 

"=Field.RXF_ORD_DATE";

 

textBox2.Value =

 

"=Field.DRG_NAME";

 

textBox3.Value =

 

"=Field.RXF_RX_NUMBER";

 

}

Steve
Telerik team
 answered on 01 Jul 2011
1 answer
151 views
Hi

We are developing a SL application using MVVM and WCF RIA Services and Entity Framework. We want to display reports using Telerik Report Viewer. The navigation follows as:

User selects the report criteria in xaml page(i.e client end) 
On click of Generate Report button, it will navigate to the page containing ReportViewer control.
The Report Viewer is containing the report uri and Report Name.
We have the logic for getting the data in a domain service in the same application.
And we have the method signature like below

public ICollection<UpdateFrequencySummaryReport> GetUpdateFrequencySummaryReport(DateTime? startDate, DateTime? endDate, bool isFixedView, string[] viewIds, int[] facilityIds, int[] regionIds, string[] viewServiceIds, string[] viewServiceStatusIds, string[] viewServiceStatusReasonIds);

It is taking so many parameters including (nullable types and arrays of ints and strings). Please let me know or provide me an example that how should i send the data through ReportParameters? Is there any other way other than report parameter? 

Thanks in advance
Ravindra
Steve
Telerik team
 answered on 30 Jun 2011
1 answer
155 views
Hi

Please let me know if it is possible to assign data to SubReport's DataSource which is lieing on a Mater Report in the detail section. Please provide me the solution as it has come as a very urgent requirement and as only one day left for dead line.

Am very much grateful to you in advance.
Ravindra
Steve
Telerik team
 answered on 30 Jun 2011
1 answer
131 views
Hello,

I have report with a chart object. The chart has to be styled dynamically. Is there a way to export and import stylesheets for a chart?I have tried the more general report stylesheet, but that one does not let me add rules for parts that are specific to a chart, such as the theme or the scale of the axis.

Thank you
Steve
Telerik team
 answered on 30 Jun 2011
1 answer
491 views
I've tried to search this down, but to date haven't found the answer and "trying" hasn't been succesful ..

With grouping by field, normally it looks logically like:

Field.One            (Logical level 1)
    Field.Two        (Logical level 2)
        Field.Three    (Logical level 3)

where the grouping creates a bit of a cascading hierachy which I understand.  Is it possible to concatenate or join fields for grouping at the report level? So for example I can do

Field.One + Field.Two    (Logical level 1)
    Field.Three                (Logical level 2)

... I receive odd results when trying this via an Expression.  Also null values supress data.

Thanks much.
Mark
Steve
Telerik team
 answered on 30 Jun 2011
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?