Telerik Forums
Reporting Forum
1 answer
105 views
Hi. Tell me please. Am I can react on the printDialogResult in the report. I use telerikReportViewer Silvelight.  On OK I'd like to insert into database and on Cancel nothing action, Help me please 
Steve
Telerik team
 answered on 26 Mar 2012
1 answer
174 views
I have created a crosstab, and it works fine. 
It shows months in each column, and sales per month. The problem is when a month doesn't have sales, this month will be hidden in the crosstab. I want the crosstab to show this month with zero values! is there a setting to avoid this tab-behaviour?

I'm using telerik 2012 Q1
Elian
Telerik team
 answered on 26 Mar 2012
3 answers
357 views
I am adding a Barcode filed to a report I'm using to print Avery labels for a parts Bin system. Each Bin label has the barcode of the Bin Number, pretty straight forward. I have not yet coded anything to read in the barcode but I would like to be able to test it before printing hundreds of labels. Is there some quick way of testing that the barcode will in fact return the Bin Number assigned to it? I am including an example of the labels I am creating and the barcode represents the bold number (Bin Number) on the top left of each label.
Elian
Telerik team
 answered on 26 Mar 2012
1 answer
213 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
122 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
161 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
225 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
109 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
199 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
183 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
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?