Telerik Forums
Reporting Forum
0 answers
58 views
My crosstab in a sales report is not repeating the rows. it is only giving me the information of one sales person. i debug the Linq datasource and for sure it has values for all the sales personal.

The need crosstab should be like this

Sales person/Week | Week1 | Week2 | week3
empl 1                     | 1000    |  3000   | 5000
empl 2                     | 1050    |  500     | 4000
empl 3                     | 1500    |  6000   | 3000

but its only showing:

Sales person/Week | Week1 | Week2 | week3
empl 1                     | 1000    |  3000   | 5000

any idea ??
daouddajani
Top achievements
Rank 1
 asked on 28 Feb 2011
2 answers
95 views
Locally data can be seen, but when uploaded to whared web server, report dosent show any record. Here is the code


<%

@ Register assembly="Telerik.ReportViewer.WebForms, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>

 

 <%

@ Import Namespace="System.Collections.Generic" %>

 

 <%

@ Import Namespace="System.Data" %>

 

 <%

@ Import Namespace="System.Data.sqlClient" %>

 

 <%

@ Import Namespace="Telerik.Reporting" %>

 

 <%

@ Import Namespace="Telerik.ReportViewer.WebForms" %>

 

 <%

@ Import Namespace="UnityTelerik" %>

 

 

page load code:

Con.Close()

Con.Open()

 

Dim dts As New  DataSet

 

 

da =

New SqlDataAdapter("select * from purchase order by lot_no", Con)

 

 da.Fill(dts,

"purchase")

 

  

 

Dim objectDataSource As New

Telerik.Reporting.ObjectDataSource()

 objectDataSource.DataSource = dts.Tables(0)

  

 

Dim c As New Report1

 c.DataSource = objectDataSource

 

ReportViewer1.Report = c

 ReportViewer1.RefreshReport()

 


Please advice me. to see my uploaded page visit telerik.mallikasoft.com


Jupiter
Top achievements
Rank 1
 answered on 28 Feb 2011
0 answers
55 views
Hi,

I have created a report using the Telerik Reporting product and it is displaying & printing in the Silverlight ReportViewer fine but when I try to save it to a PDF or TIFF image etc it is missing a lot of the data.

I have noticed that the data images that are missing are specifically for controls that I set in code and that the controls that are set like [=Fields.FieldName] are populated fine.

Can anybody help me with this issue? The version of Telerik Reporting I am using is 4.2.10.1221.

Much appreciated,

Nick
Nick Jacka
Top achievements
Rank 1
 asked on 28 Feb 2011
0 answers
127 views
Hey,
I am a new guy with telerik reporting with sqlclr.
I created a sqlclr storedprocedure in MSSQL 2008. it works fine in quary analyzer.
In the stroredprocedure list of the telerik reporting wizard,  it shows the sqlclr storedprocedure, but when i select the sqlclr storeprocedure and click Next button, it shows "the Stored Procedure doesn't exist". 

What's wrong with me. Please suggest me what to do as soon as possible.

Thanks

Md. Habibur Rahman
Technical Lead

Computer Ease Limited
                Information Architects

Mohammad Habibur
Top achievements
Rank 1
 asked on 27 Feb 2011
0 answers
82 views
I watched one of the training videos regarding localization of the reports.  It was simple and straight forward if you are creating a new localization for the reports only.  The solution i have already contains its own localization methodology.  The localization information is stored in XAML files named en-US.xaml and es-ES.xaml.  The application has its own methods for retrieving the information from these files.  For example, in my application if i wish to retrive the label for report name i would use the code App.FindStringResource("ReportName"). 

This code would determine which culture is being used and search teh XAML file for the appropriate string and return the correct translation.  I tried setting my label's value to =App.FindStringResource("ReportName") but when i click the preview button i get Object reference not set to an instance of an object.  If i go into the reports code behind and type in string reportName = App.FindStringResource("ReportName"); I get no compile time errors indicating that Visual Studio is seeing my App.FindStringResource method. 

Am i going about this the correct way and it just won't render until compile time, or is there a better way to handle this?
John
Top achievements
Rank 1
 asked on 27 Feb 2011
7 answers
674 views
Hi,
i have a question, i need to show page header only on the first page and not on the other ones.
Basically i have mulitcolumn report, but when i try to add report header it is not expanded over all the columns, so page header would do - but it is visible on every page which i do not want it to be.

Thank you for the help.
Sam Ur
Top achievements
Rank 2
 answered on 25 Feb 2011
6 answers
182 views
Is there any way in a multicolumn report to have the report header span the entire width of the report instead of just a single column? I have a two column report and on the first page I need to have a title span the entire page before the columns start. If the report header can not be used in this way, is there a way to dynamically change what is contained in the page header after the first page is done? What about making the page header only visible on the first page?

Thanks
Sam Ur
Top achievements
Rank 2
 answered on 25 Feb 2011
1 answer
94 views
Hi guys,

I think i've found something strange:

If I put on a report with a simple group a textbox field on the group header or group footer with this formula on value property:

=(sum(dbfield1)/2000)*100

the results differs from this formula that must be the same:

=(sum(dbfield1)*100)/2000

It is, as I see,  because if result of sum(dbfield1)/2000 is 0 <= x <1 telerik reporting uses 0 to continue with the formula.

For example:

Dbfield1=5

Formula1: =(sum(dbfield1)/2000)*100 = (5/2000)*100 = 0.0025*100 At this point Telerik reporting uses 0 not 0.0025 so 0*100=0

Formula2: =(sum(dbfield1)*100)/2000 = (5*100)/2000 = 500/2000 = 0.25

Is this behavior correct?

Thanks

David


Peter
Telerik team
 answered on 25 Feb 2011
1 answer
208 views

I downloaded Telerik 2010Q3 trial version. Most of the components are useful for our requests but in some of our projects we have to use dot matrix printers. My question is, is it possible to get print out from Telerik reporting to dot matrix character mode printers. I develop web applications and for reporting I want to use Telerik Reporting.

can you please give information about printing into character mode printer for web applications?

thanks

Peter
Telerik team
 answered on 25 Feb 2011
4 answers
191 views

I can not get a report with a dataset datasource to preview with data.  Here is the recipe that shows my problem.

  1. Create Solution & Create Class Project
  2. Add DataSet (XSD) to Project
  3. Add one table adapter with simple SQL (SELECT Field1 FROM Table1) to the DataSet - make sure it returns data
  4. Add Telerik Report 2.0 to Project
  5. Add a text box with a value of [=Fields.Field1]
  6. Drag a Toolbox DataSet to the Report, select the typed dataset from step 2
  7. In the report's properties, select the report's data source instance
  8. Also in the report's properties select the table adapter from step 3
  9. save
  10. look at the data explorer to make sure the report knows about your data - verify that Field1 appears properly.
  11. Click preview or preview HTML and see no data.
  12. Sigh
  13. Remove datasource and datamember properties from report & delete the dataset from the report
  14. Drag a Toolbox SqlDataAdapter to the report & enter the same SQL used in step 3
  15. In the report properties, selecte the report's data source instance
  16. save
  17. click preview or preview HTML and see the data

I am a fairly new user.  Can someone please tell me what I am doing wrong? 

Steve
Telerik team
 answered on 25 Feb 2011
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?