Telerik Forums
Reporting Forum
1 answer
171 views
Hi,

I want to display the data into telerik report viewer control through the Linq with stored procedure.

I have tried this but not get the success. 

Telerik report viewer showing as blank.

I used this source code also without LInq

 Telerik.Reporting.ObjectDataSource objectDataSource = new Telerik.Reporting.ObjectDataSource();
            objectDataSource.DataSource = GetAllData(); // GetData returns a DataSet with three tables
            objectDataSource.DataMember = "VehiclePlanInformation"; /// Indicating the exact table to bind to. If the DataMember is not specified the first data table will be used.
             
            //  objectDataSource.CalculatedFields.Add(new Telerik.Reporting.CalculatedField("PlanCode", typeof(string), "=Fields.PlanCode")); // Adding a sample calculated field.


            // Creating a new report
            Telerik.Reporting.Table report = new Telerik.Reporting.Table();


            // Assigning the ObjectDataSource component to the DataSource property of the report.
            report.DataSource = objectDataSource;
            
            // Assigning the report to the report viewer.
            ReportViewer1.Report =(Telerik.Reporting.IReportDocument)report;


            // Calling the RefreshReport method (only in WinForms applications).
            ReportViewer1.RefreshReport();

but not get the success.

Please suggest me. Its urgent for me.


Thanks

Vikas

Peter
Telerik team
 answered on 26 Mar 2012
1 answer
85 views
Good Morning all!

Definitely new to Telerik.  I'm coming from a slight background in Xcelsius, and I had a question regarding Tables and Charts.  Do these items have the same ability to expand or contract dynamically (IE: new data added on top of exiting data, or items removed as they are no longer relevant.....and the component scales accordingly)?

My organization is looking to shift to Telerik for a project, and I am just trying to arm myself with some knowledge when we do our side by side comparison.

Thanks!
Elian
Telerik team
 answered on 26 Mar 2012
1 answer
140 views
I am an untrained volunteer, attempting to solve a reporting problem.

I am experimenting with the standalone version of the report designer to see if it is a reporting solution that will work for me.

I am able to generate the reports I need individually, by inserting three where variables into the select statement. as follows

Select * from B_MRDATA where System = 'Inglemoor' and Level = 'Rookies' and Split = 'None'
Order By last

There are potentially 309 combinations of the three variables System, Level, and Split. Not all those combinations will be used.. Is there a way to automate a process and generate all the required reports at once?

Here is the xml code for one of the reports - I deleted the connection string.

Thanks in advance for any help you can give me - Billie

(<?xml version="1.0" encoding="utf-8"?>

<Report Width="9.90000025in" Name="report1">

<DataSources>

<SqlDataSource ConnectionString="data &#xA;" SelectCommand="Select * from B_MRDATA where system = 'Bothell' and Level = 'Cubs' and Split = 'Black'&#xD;&#xA;Order By last" Name="sqlDataSource1" />

</DataSources>

<PageSettings PaperKind="Letter" Landscape="True">

<Margins Left="0.5in" Right="0.5in" Top="0.25in" Bottom="0.25in" />

</PageSettings>

<DataSourceRef>sqlDataSource1</DataSourceRef>

<StyleSheet>

<StyleRule>

<Style Color="Black">

<Font Name="Tahoma" Size="20pt" Style="Bold" />

</Style>

<Selectors>

<StyleSelector>

<Type>ReportItemBase</Type>

<StyleName>Title</StyleName>

</StyleSelector>

</Selectors>

</StyleRule>

<StyleRule>

<Style Color="Black" VerticalAlign="Middle">

<Font Name="Tahoma" Size="11pt" Style="Regular" />

</Style>

<Selectors>

<StyleSelector>

<Type>ReportItemBase</Type>

<StyleName>Caption</StyleName>

</StyleSelector>

</Selectors>

</StyleRule>

<StyleRule>

<Style VerticalAlign="Middle">

<Font Name="Tahoma" Size="11pt" Style="Regular" />

</Style>

<Selectors>

<StyleSelector>

<Type>ReportItemBase</Type>

<StyleName>Data</StyleName>

</StyleSelector>

</Selectors>

</StyleRule>

<StyleRule>

<Style VerticalAlign="Middle">

<Font Name="Tahoma" Size="11pt" Style="Regular" />

</Style>

<Selectors>

<StyleSelector>

<Type>ReportItemBase</Type>

<StyleName>PageInfo</StyleName>

</StyleSelector>

</Selectors>

</StyleRule>

</StyleSheet>

<Groups>

<Group Name="labelsGroup">

<GroupHeader>

<GroupHeaderSection PrintOnEveryPage="True" Height="0.20003986in" Name="labelsGroupHeader">

<Items>

<TextBox Value="#" Left="0.02083333in" Top="0in" Width="0.19999949in" Height="0.20000013in" Name="textBox47" />

<TextBox Value="Last Name" Left="0.22091158in" Top="0in" Width="1.17908843in" Height="0.19999981in" Name="textBox48" />

<TextBox Value="First Name" Left="1.4000001in" Top="0in" Width="0.79992135in" Height="0.20000013in" Name="textBox50" />

<TextBox Value="Address" Left="2.21882915in" Top="0in" Width="1.5810922in" Height="0.20000013in" Name="textBox52" />

<TextBox Value="School" Left="4.80007903in" Top="0in" Width="0.99992116in" Height="0.20000013in" Name="textBox55" />

<TextBox Value="Phone" Left="3.80000019in" Top="0in" Width="1in" Height="0.20000013in" Name="textBox57" />

<TextBox Value="DOB" Left="5.80000051in" Top="0in" Width="0.99992116in" Height="0.20000013in" Name="textBox59" />

<TextBox Value="BC" Left="6.80000051in" Top="0in" Width="0.29992167in" Height="0.20000013in" Name="textBox61" />

<TextBox Value="AO" Left="7.10000038in" Top="0in" Width="0.29996109in" Height="0.20000013in" Name="textBox62" />

<TextBox Value="PTS" Left="7.40000025in" Top="0in" Width="0.40000025in" Height="0.20000013in" Name="textBox63" />

<TextBox Value="Wt" Left="7.80000051in" Top="0in" Width="0.49996122in" Height="0.20000013in" Name="textBox64" />

<TextBox Value="Grad" Left="8.30000051in" Top="0in" Width="0.5in" Height="0.20000013in" Name="textBox65" />

<TextBox Value="Ver" Left="8.80000051in" Top="0in" Width="0.29999987in" Height="0.20000013in" Name="textBox66" />

<TextBox Value="AG" Left="9.10000038in" Top="0in" Width="0.29999987in" Height="0.19999981in" Name="textBox67" />

<TextBox Value="textBox68" Left="8.80000051in" Top="0.09992123in" Width="0in" Height="0in" Name="textBox68" />

<TextBox Value="Tot" Left="9.40000025in" Top="0in" Width="0.39988136in" Height="0.19999981in" Name="textBox69" />

</Items>

</GroupHeaderSection>

</GroupHeader>

<GroupFooter>

<GroupFooterSection Height="0.40011819in" Name="labelsGroupFooter">

<Style Visible="False" />

</GroupFooterSection>

</GroupFooter>

</Group>

</Groups>

<Items>

<PageHeaderSection Height="0.28125in" Name="pageHeader">

<Items>

<TextBox Value="Master Roster" Left="0.02083333in" Top="0.02083333in" Width="6.41666667in" Height="0.20000001in" Name="reportNameTextBox" StyleName="PageInfo" />

</Items>

</PageHeaderSection>

<PageFooterSection Height="0.28125in" Name="pageFooter">

<Items>

<TextBox Value="=NOW()" Left="0.02083333in" Top="0.02083333in" Width="3.19791667in" Height="0.20000001in" Name="currentTimeTextBox" StyleName="PageInfo" />

<TextBox Value="=PageNumber" Left="3.23958333in" Top="0.02083333in" Width="3.19791667in" Height="0.20000001in" Name="pageInfoTextBox" StyleName="PageInfo">

<Style TextAlign="Right" />

</TextBox>

</Items>

</PageFooterSection>

<ReportHeaderSection Height="1.51875019in" Name="reportHeader">

<Items>

<TextBox Value="Master Roster" Left="0in" Top="0in" Width="8.99996058in" Height="0.31874998in" Name="titleTextBox" StyleName="Title" />

<TextBox Value="System:" CanGrow="True" Left="0.02083333in" Top="0.31875006in" Width="0.99992116in" Height="0.20000001in" Name="systemCaptionTextBox" StyleName="Caption">

<Style TextAlign="Left" />

</TextBox>

<TextBox Value="=Fields.System" CanGrow="True" Left="1in" Top="0.31875006in" Width="1.19992113in" Height="0.20000001in" Name="systemDataTextBox" StyleName="Data" />

<TextBox Value="=Fields.[Club Rep]" Left="1in" Top="0.51875003in" Width="1.19992113in" Height="0.19999997in" Name="textBox1" />

<TextBox Value="Club Rep:" Left="0.02083333in" Top="0.51875003in" Width="0.99992116in" Height="0.19999997in" Name="textBox3" />

<TextBox Value="=Fields.Level" Left="1in" Top="0.71875in" Width="1.19992129in" Height="0.20000013in" Name="textBox4" />

<TextBox Value="=Fields.Split" Left="1in" Top="0.91875013in" Width="1.19992129in" Height="0.19999981in" Name="textBox5" />

<TextBox Value="Level:" Left="0in" Top="0.71875in" Width="0.99992116in" Height="0.19999997in" Name="textBox6" />

<TextBox Value="Head Coach:" Left="0in" Top="1.1187501in" Width="0.99992116in" Height="0.19999997in" Name="textBox8" />

<TextBox Value="=Fields.[Head Coach]" Left="1in" Top="1.1187501in" Width="1.19992145in" Height="0.20000013in" Name="textBox9" />

<TextBox Value="Assistant:" Left="0in" Top="1.31875006in" Width="0.99992114in" Height="0.19999997in" Name="textBox10" />

<TextBox Value="Split:" Left="0in" Top="0.91875013in" Width="0.99992114in" Height="0.19999997in" Name="textBox11" />

<TextBox Value="Assistant:" Left="2.21882884in" Top="0.31875006in" Width="0.99992114in" Height="0.19999997in" Name="textBox12" />

<TextBox Value="=Fields.[Assistant 1]" Left="1in" Top="1.31875006in" Width="1.17908812in" Height="0.20000013in" Name="textBox13" />

<TextBox Value="Assistant:" Left="2.20000013in" Top="0.51875003in" Width="1.01875019in" Height="0.19999997in" Name="textBox7" />

<TextBox Value="Assistant:" Left="2.21882915in" Top="1.31875006in" Width="0.99992114in" Height="0.19999997in" Name="textBox14" />

<TextBox Value="Assistant:" Left="4.26049582in" Top="0.31875006in" Width="0.70000013in" Height="0.19999997in" Name="textBox15" />

<TextBox Value="Assistant:" Left="2.21882884in" Top="0.71875in" Width="0.99992114in" Height="0.19999997in" Name="textBox16" />

<TextBox Value="Assistant:" Left="2.21882884in" Top="1.1187501in" Width="0.99992114in" Height="0.19999997in" Name="textBox18" />

<TextBox Value="Assistant:" Left="2.21882884in" Top="0.91875013in" Width="0.99992114in" Height="0.19999997in" Name="textBox19" />

<TextBox Value="=Fields.[Assistant 2]" Left="3.30000019in" Top="0.31875006in" Width="0.96041679in" Height="0.19999997in" Name="textBox17" />

<TextBox Value="=Fields.[Assistant 3]" Left="3.30000019in" Top="0.51875003in" Width="0.96041679in" Height="0.19999997in" Name="textBox20" />

<TextBox Value="=Fields.[Assistant 4]" Left="3.30000019in" Top="0.71875in" Width="0.96041648in" Height="0.19999997in" Name="textBox21" />

<TextBox Value="=Fields.[Assistant 5]" Left="3.30000019in" Top="0.91875013in" Width="0.96041648in" Height="0.20000013in" Name="textBox22" />

<TextBox Value="=Fields.[Assistant 6]" Left="3.30000019in" Top="1.1187501in" Width="0.96041679in" Height="0.19999997in" Name="textBox23" />

<TextBox Value="=Fields.[Assistant 7]" Left="3.30000019in" Top="1.31875006in" Width="0.96041648in" Height="0.19999997in" Name="textBox24" />

<TextBox Value="Ball Boy:" Left="4.26049582in" Top="0.71875in" Width="0.70000013in" Height="0.19999997in" Name="textBox25" />

<TextBox Value="Ball Boy:" Left="4.26049582in" Top="0.51875003in" Width="0.70000013in" Height="0.19999997in" Name="textBox26" />

<TextBox Value="First Aid:" Left="4.2604955in" Top="0.91875013in" Width="0.70000013in" Height="0.19999997in" Name="textBox28" />

<TextBox Value="=Fields.[Ball Boy 1]" Left="5in" Top="0.51875003in" Width="1.1770045in" Height="0.19999997in" Name="textBox29" />

<TextBox Value="=Fields.[Assistant 8]" Left="5in" Top="0.31875006in" Width="1.1770045in" Height="0.19999997in" Name="textBox30" />

<TextBox Value="=Fields.[First Aid]" Left="5in" Top="0.91875013in" Width="1.13742065in" Height="0.20000013in" Name="textBox32" />

<TextBox Value="=Fields.[Ball Boy 1]" Left="5in" Top="0.71875in" Width="1.1770045in" Height="0.19999997in" Name="textBox31" />

<TextBox Value="Pt Rng:" Left="4.30007903in" Top="1.1187501in" Width="0.70000011in" Height="0.19999997in" Name="textBox27" />

<TextBox Value="Eq Allow:" Left="4.30007903in" Top="1.31875006in" Width="0.70000011in" Height="0.19999997in" Name="textBox33" />

<TextBox Value="Cap Wt:" Left="6.17708349in" Top="0.31875006in" Width="0.70000011in" Height="0.19999997in" Name="textBox34" />

<TextBox Value="=Fields.[Pt Range]" Left="5.00015767in" Top="1.1187501in" Width="1.17684682in" Height="0.19999997in" Name="textBox35" />

<TextBox Value="=Fields.[Equip Allow]" Left="5.02307447in" Top="1.31875006in" Width="1.17684682in" Height="0.19999997in" Name="textBox36" />

<TextBox Value="=Fields.Capweight" Left="6.87716293in" Top="0.31875006in" Width="1.1228377in" Height="0.20000013in" Name="textBox37" />

<TextBox Value="Home Jer:" Left="6.20000013in" Top="0.91875013in" Width="0.70000011in" Height="0.19999997in" Name="textBox39" />

<TextBox Value="Awy Jer:" Left="6.20000013in" Top="1.1187501in" Width="0.70000011in" Height="0.19999997in" Name="textBox40" />

<TextBox Value="Helmet:" Left="6.17708333in" Top="0.51875003in" Width="0.70000011in" Height="0.19999997in" Name="textBox41" />

<TextBox Value="Pants:" Left="6.20000013in" Top="0.71875in" Width="0.70000011in" Height="0.19999997in" Name="textBox38" />

<TextBox Value="=Fields.Helmet" Left="6.90007909in" Top="0.51875003in" Width="1.09992154in" Height="0.19999997in" Name="textBox42" />

<TextBox Value="=Fields.[Jersey Away]" Left="6.90000025in" Top="1.1187501in" Width="1.09996096in" Height="0.20000013in" Name="textBox43" />

<TextBox Value="=Fields.[Jersey Home]" Left="6.90000025in" Top="0.91875013in" Width="1.10000038in" Height="0.19999981in" Name="textBox44" />

<TextBox Value="=Fields.Pants" Left="6.90007909in" Top="0.71875in" Width="1.09992154in" Height="0.19999997in" Name="textBox45" />

</Items>

</ReportHeaderSection>

<ReportFooterSection Height="0.28125in" Name="reportFooter" />

<DetailSection Height="0.29988162in" Name="detail">

<Items>

<TextBox Value="=Fields.Last" Left="0.19999997in" Top="0in" Width="1.19999997in" Height="0.20000013in" Name="textBox46" />

<TextBox Value="=Fields.[#]" Left="0in" Top="0in" Width="0.20000005in" Height="0.20000013in" Name="textBox49" />

<TextBox Value="textBox51" Left="4.90000025in" Top="0.09988181in" Width="0in" Height="0in" Name="textBox51" />

<TextBox Value="=Fields.First" Left="1.40007877in" Top="0in" Width="0.79984252in" Height="0.20000013in" Name="textBox53" />

<TextBox Value="=Fields.Address" Left="2.21882915in" Top="0in" Width="1.5810922in" Height="0.20000013in" Name="textBox54" />

<TextBox Value="=Fields.School" Left="4.80007903in" Top="0in" Width="0.99992116in" Height="0.19999981in" Name="textBox56" />

<TextBox Value="=Fields.Phone" Left="3.80000019in" Top="0in" Width="1in" Height="0.19999981in" Name="textBox58" />

<TextBox Value="=Fields.BC" Left="6.80000051in" Top="0in" Width="0.29999987in" Height="0.19999981in" Name="textBox70" />

<TextBox Value="=Fields.AO" Left="7.10000038in" Top="0in" Width="0.30000051in" Height="0.19999981in" Name="textBox71" />

<TextBox Value="=Fields.Points" Left="7.40000025in" Top="0in" Width="0.39992078in" Height="0.19999981in" Name="textBox72" />

<TextBox Value="=Fields.Weight" Left="7.80000051in" Top="0in" Width="0.49988238in" Height="0.19999981in" Name="textBox73" />

<TextBox Value="=Fields.Grade" Left="8.30000051in" Top="0in" Width="0.5in" Height="0.19999981in" Name="textBox74" />

<TextBox Value="=Fields.Verified" Left="8.80000051in" Top="0in" Width="0.29999987in" Height="0.19999981in" Name="textBox75" />

<TextBox Value="=Fields.AG" Left="9.10000038in" Top="0in" Width="0.29992104in" Height="0.19999981in" Name="textBox76" />

<TextBox Value="=Fields.TOTAL" Left="9.40000025in" Top="0in" Width="0.39992078in" Height="0.19999981in" Name="textBox77" />

<TextBox Value="=Fields.Expr23" Left="5.80000051in" Top="0in" Width="0.99992116in" Height="0.20000013in" Name="textBox60" />

</Items>

</DetailSection>

</Items>

</Report> )


Elian
Telerik team
 answered on 26 Mar 2012
3 answers
202 views
Dears,

I've just installed trial version of Telerik Reporting Q2 SP1 from your download center. Unfortunately, when used with VS2010, i can see the document template "Telerik Report" in Add New Item dialog, but, when added to my project, it only creates a cs file without wizard. There is no other way i could find to run wizard from any context or program menus.

In the forums, i've found something related to WPF environment in VS2010 that we must use .NET Framework 4.0 as our target framework. I also tried it but no luck.

I want to use reporting controls in pure ASP.NET website.

What can be the problem ?

Best Regards,

Ozan GUNCELER
Steve
Telerik team
 answered on 26 Mar 2012
1 answer
87 views
Why doesn't Telerik reporting have a built-in export button for exporting to pdf, excel, etc.? It seems like that would be a basic functionality.
Steve
Telerik team
 answered on 26 Mar 2012
1 answer
163 views
I have a scenrio in which If report is generated in 5 pages, If click on page no which is generated like a treeview, It should be redirected to corresponding page. Can u provide a sample Ex or solution for it.
Elian
Telerik team
 answered on 23 Mar 2012
2 answers
149 views
Hi 
Actually i want to use Telerik Reporting for generating a bill for specific Patient (i m making sample project for hospital management).My issue is i can't navigate through the patients data..i mean when i select Patient ID from report's combobox , data on the reports is not changing...
Any Help 
I just see That INVOICE REPORT example just like that example i want to generate bill but don't want that lower table which is in that INVOICE REPORT i just want to retrve that specific contact information..I can't understand that demo video perfectly its making me confused because there is sub-report portion also have and i'm beginner..

So can u give me any simple example..
Just show me how to get two fields data from sql database that is Name & Gender on selecting patient id from reports parameter combo box..then when i will change Patient ID from combo box, data on the form  of corresponding patient ID also have to change . 

Kaustubh
Top achievements
Rank 1
 answered on 23 Mar 2012
1 answer
118 views
I am creating a report whichs data is provided by a web service... This web service needs a GUID to be able to get the correct data. I am using an object data source and have set up everything (at least I think so) correctly. I have chosen the service, then the function and got to the configure data source parameters. I have chosen the userId to be GUID and associated it with a parameter variable. the problem is that when defining this parameter in report parameters I can't choose it to be GUID but only string, bool, datetime, integer or float. How can I send this parameter to the web service?
Peter
Telerik team
 answered on 23 Mar 2012
1 answer
156 views

Converting crystal report to telerik and literally every field has the warning:  Overlapping items may not appear as expected in some export formats.  The report is populated with box shapes with multiple fields inside each box.  What approach should I take…convert the box shapes to panels…use a crosstab…other?


Type of project: C# Windows Class Library with a collection of Telerik Report Q1 2011 projects (one per report)

 

Step by step instructions on how to reproduce the problem:
Add the Telerik Report item to the solution and use the Telerik wizard to convert an existing crystal report to telerik.

 

State the software you are using, including: 

OS version and applied service packs. Win 7 Pro, SP1

Exact version of Telerik Reporting. Telerik_Reporting_Q1_2011_v5_0_11_510_dev.msi

Peter
Telerik team
 answered on 23 Mar 2012
0 answers
70 views
At some point in the rendering process, the report resolves the datasource SQL statement and submits it to the database.  Is there a way in the Silverlight ReportViewer or on the Server-side to capture this?  We have an Oracle back end and I don't think I have access to look there.  Thanks.
Simon Kingaby
Top achievements
Rank 2
 asked on 23 Mar 2012
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?