Telerik Forums
Reporting Forum
1 answer
140 views
Hi,

Can anyone tell how to implement Group By on datatables using linq in telerik (C# Application).
I have written query as follows:

var query = from 

 

 

dataitem in combinedDataTable.AsEnumerable()  

 

 

 

group dataitem by dataitem.Field<string>("IONumber") into r

select new  

 

 

 

{

IONumber = r.Field<

 

string>("IONumber"),
IOName = r.Field<string>("IOName")
}

I am getting error on 'group' saying:
'Telerik.Web.UI.GridDynamicQueryable.GroupBy(System.Linq.IQueryable, string, string, params object[])' is inaccessible due to its protection level

Can anyone suggest how to update this query to work fine? (I am using telerik 2009)

 

 

 

 

 

 

Veli
Telerik team
 answered on 15 Jun 2011
1 answer
101 views
Hi,
about this subject i have read some trhead in this forum but  could'nt find a solution for my problem.

Here the problem:
i manage the parameter by the build in Ui for parameter, My parameter is setted as multivalues.
Now i would like to get  the values  choosen by the user.

Documetation and intellisense, about ReportParameter.value property, says :
"Gets or sets the value of the parameter. Can be an Expression that evaluates to an object, value of the allowed types, or [!:IEnumerable] containing values of the allowed types. "

But ReportParameter.value  is an object and does'nt expose an enumerator. In same place i read it is an ArrayList so i tried something like that:
ArrayList kl= new ArrayList();
 kl =Report.ReportParameters[0].Value;

and i get the above error:
Unable to cast object of type 'System.Object[]' to type 'System.Collections.ArrayList'.

No matter what typ of collection i tried with( Ilist,List). I get always a casting error.

So i can retrieve the list of values of a multivalues parameter?

Thanks




ciccio
Top achievements
Rank 1
 answered on 15 Jun 2011
1 answer
401 views
I have a very simple report, that pulls from a sample database with no NULL values. I have the report working fine, and have added a parameter and a filter to filter by user name.

I would like the option of running the report for all names. I changed the "AllowNull" value to true. When I try to run the report, I get the following error:

An error has occurred while processing Report 'talksafe1':
Object cannot be cast from DBNull to other types

How do I run both filtered and unfiltered data? Again, I have no NULL values in my database, it only contains 4 records.

=Fields.Manager =  =Parameters.ManagerPrm.Value

AllowBlank = True
AllowNull = True
DataSource = SQLDatasource1
DisplayMember = Fields.Manager
ValueMember = Fields.Manager
Name = ManagerPrm
Text = Select Manager
Type = String
Visible = True
Steve
Telerik team
 answered on 15 Jun 2011
6 answers
430 views
Telerik Reporting
Hello,
    I'm using Telerik report, I want to export to PDF file and send email to group of customers. When the report is expored to pdf, the file size is always 1MB (or more)
    My question is how i can decrease the file size? it's importance per customer requests.

Please Help and Thanks,
Joe
Steve
Telerik team
 answered on 15 Jun 2011
0 answers
132 views
Hi everyone,

I am trying to make arithmetic operation with two fields from two different datasources in a textbox. One of the datasources (A) is datasource of the report and show the fields in the detail section. Another one (B) returns just one row.
In the footer section, I have to make addition with B and sum of A.

Any suggestions ?
Bekir
Top achievements
Rank 1
 asked on 15 Jun 2011
3 answers
85 views
How can i render new report, on a click command. Like a refresh button.

Which function in the Silverlight ReportViewer can be used to request new report, I was not able to find any render Function.
Steve
Telerik team
 answered on 15 Jun 2011
7 answers
532 views
Hi,

I'm evaluating your reporting library with some test samples. One of these is a report with serveral charts and tables (in the pageFooter section there is a textbox with the PageNumber object). When I preview in reportviewer, the report is shown without paging, and the page number value is always 1 (even if the rendered report size has two or more pages). When exporting to pdf the number of pages is correct (and also the page number field in the footer section).

Is it possible to hide the PageNumber field when previewing with Reportviewer (and show it when export to pdf or print)? I've seen your Invoice Report sample works in this way, but I don't know how to get that.

How can I display the correct pages and its numbers when previewing in Reportviewer (like the Preview tab in design mode in VS)? Is it possible?

Regards,
John.
Steve
Telerik team
 answered on 15 Jun 2011
3 answers
811 views
Hi,

I am trying to integrate the WPF Report Viewer into a WPF application.

I would like to:

1.  Generate a "DataTable" object in code at runtime, with a varying amount of rows and columns.

2.  View this datatable in a Telerik Report.

I've been having some difficulty and am beginning to question if this is possible.

Is it?

Thank you,
Justin
IvanDT
Telerik team
 answered on 14 Jun 2011
1 answer
219 views
Hi,
 I am wondering is there a way in telerik reporting, to have data repeater functionality, i.e a section which contains some controls like TextBoxes and repeats itself for a collection of datarows.
Appreciate any help, Thanks in advance,
sid
IvanDT
Telerik team
 answered on 14 Jun 2011
1 answer
377 views
Hi,

I have a problem, I am using Telerik Report Q2 2011 with visual studio 2010 silverlight 4 MVVM (C#). I have managed to pass parameters to the report from my silverlight application and its working okay. Thing is one of my reports contains a subreport, the subreport gets its data from a table thats is more of a reference table - main report gets patient data and the sub report gets a patients chronic conditions if (s)he has any. What I want to achieve is;

1) User passes a parameter to the main report using the silverlight report view from the silverlight app. This is working okay.
2) Pass the patient number to the subreport but check to ensure first that the patient has chronic conditions, and populate chronic conditions sub report only if the patient has records in the patient chronic conditions table  otherwise dont pass any parameter to the subreport since I keep getting error if the patient has no chronic condition. This is where I need help. Please help. Any help will be highly appreciated.

Thanks

Francis.
Steve
Telerik team
 answered on 14 Jun 2011
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?