Questions on Reporting Forum

0 answers

163 views

Hello to all , I am new at this coding...
My files explains everything . Just want to see the values at the right of the graph like AA - BB... I couldn't change it according coming from db. Just writes there "genelpuani"

my code :

    
            private void chart1_NeedDataSource(object sender, EventArgs e)  
        
                {  
        
                    Telerik.Reporting.Processing.ReportItemBase itemBase = (Telerik.Reporting.Processing.ReportItemBase)sender;  
        
                    int hastaID = int.Parse(itemBase.DataObject["HastaID"].ToString());  
        
                    int formid = int.Parse(itemBase.DataObject["formid"].ToString());  
        
                    Telerik.Reporting.Processing.Chart procChart = (Telerik.Reporting.Processing.Chart)sender;  
        
                    string sql = @"SELECT        kat.KategoriName as kategoriismi, genelpuan.Puan as genelpuani 
        
                                            FROM  GenelPuanlama AS genelpuan INNER JOIN 
        
                                 Kategoriler AS kat ON genelpuan.KategoriID = kat.KategoriID WHERE (genelpuan.FormID='" + formid.ToString() + "') AND (genelpuan.HastaID ='" + hastaID.ToString() + "')";  
        
                    string connectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;User Instance=True";  
        
                    SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString);  
        
                    DataTable datatable = new DataTable();  
        
                    adapter.Fill(datatable);  
        
                    procChart.DataSource = datatable;  
        
                    //chart1.IntelligentLabelsEnabled = true;  
        
                    //chart1.PlotArea.XAxis.DataLabelsColumn = "kategoriismi";  
        
                    //chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 300;  
        
                    chart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = System.Drawing.Color.DarkBlue;  
        
                    chart1.PlotArea.Appearance.Dimensions.Margins.Bottom = Telerik.Reporting.Charting.Styles.Unit.Percentage(30);  
        
            }

General Discussions

asked on 15 Mar 2010

3 answers

118 views

2010 Q1 issue

Hi,

I just upgraded to the Q1 release and have an issue with an InvalidCastException issue. I've looked and couldn't find a breaking changes sheet for this ver so am suprised to get an error (this was working with old 2009 Q3 ver).

For the following code I get a message saying "Unable to cast object of type '<EnumRawData>d___0' to type 'System.Data.DataRow'".

    
            Private Sub locationIDGroupHeader_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles locationIDGroupHeader.ItemDataBound  
        
                Dim section As Telerik.Reporting.Processing.GroupSection = DirectCast(sender, Telerik.Reporting.Processing.GroupSection)  
        
                Dim row As System.Data.DataRow = DirectCast(section.DataObject.RawData, System.Data.DataRow)

The error appears on the second line...

Any workarounds?

Regards,

Jon

General Discussions

answered on 15 Mar 2010

1 answer

143 views

How to Bind Data in Line Chart to Dataset..

I want to bind the series and series items to the dataset (created through Report Wizard). I used the code to bind the data to the datasource given in documentation but it's not helping. Is there any other way to bind the data through series properties or through code in event _NeedDataSoure? The connection, i made is through ODBC.

General Discussions

answered on 15 Mar 2010

1 answer

214 views

PDF Export Page Size

Hi,

I have created a master report with many subreports. When I preview the individual reports, they fit on a single page(A4 Potrait/Landscape). However, when I preview the master report(with all the subreports), I see the individual reports overflow to second page(the rows, not the columns). I do have the "Keep Together" property set to "True". What am I missing here? Just to check, when I set that property to False, I see an additional empty page being added in between the first two pages. How can I stop this overflow?

Thanks for any help.

General Discussions

answered on 15 Mar 2010

1 answer

108 views

Parametrize report

Hi,
I use telerik reporting to build a report,
but when it run in perview it don't show last character in integer but in html perview is correct .
also in perview when i generate a pdf report is correct but don't show last character in perview.

-->> in Persian Calture (in English is fine) <<--

General Discussions

answered on 15 Mar 2010

0 answers

92 views

SQL Server Stored Procedure with mutiple result sets in telerik reproting

Is it possbile to use single stored procedure returning multiple result sets in single telerik report?

First result set will be company name and address that goes into report header section, second result set will be for detailed rows of the report.

I appreciate code reference to any real time examples.

General Discussions

asked on 15 Mar 2010

2 answers

119 views

Silverlight and parameterized queries ?

Hi,

I'm looking for adding a parameterized query into my report. I'm currently in a Silverlight 3 project and cannot play with my Viewer.report property like in the videos because the silverlight report viewer has a string report property instead of a report type property.

My question is quite simple :

My application needs to set a parameter to my report generation to filter some stuff. How can I pass a value to the reporting service to make my report generating with the user selection parameter ?

I know that report processing is in server side but if we can't pass some parameters from a silverlight app to the reporting service I really don't know what we would be able to do with Telerik Reporting.

I've also tried to see if IReportingService would be a solution to my problem but unfortunately I didn't found any example about how to use it.

Thanks

Regards,

Steeve

General Discussions

answered on 15 Mar 2010

5 answers

158 views

data formatting sintax

Hello,
how do I set in the textbox value the sintax to have a conditional formatting of this type :

if(Field.Valore ==1) then 'yes' else 'no' ?

thanks in advance
Paolo

General Discussions

answered on 15 Mar 2010

1 answer

172 views

2010.1 Upgrade Issue - SizeU is not serializable

I got this error on about 5 of my reports when upgrading to reporting 2010.1. The errors were on the resx file of the report.

System.InvalidOperationException: Item named 'detail.GridSize' of type 'Telerik.Reporting.Drawing.SizeU' cannot be added to the resource file because it is not serializable. at System.Resources.ResXDataNode..ctor(String name, Object value) at System.Resources.ResXResourceWriter.AddDataRow(String elementName, String name, Object value) at System.Resources.ResXResourceWriter.AddMetadata(String name, Object value) at Telerik.Reporting.UpgradeWizard.Engine.Utilities.ResourceFile.SaveAs(String fileName) at Telerik.Reporting.UpgradeWizard.Engine.ResourceItem.UpgradeInternal() at Telerik.Reporting.UpgradeWizard.Engine.UpgradeItem.Upgrade()

General Discussions

answered on 15 Mar 2010

6 answers

335 views

Custom Report Parameter Interface

Hi there.

I have a requirement to create a parameter interface that fits better with the look and feel of our application. We have several reports that have parameters that are lengthy string values and when you have a few of those on a report, the parameters don't look very good on top of the viewer. So, with that in mind, can you control the look/positioning of the parameters or is it best to just create another parameter aspx page that then kicks off the viewer and handles the parameters dynamically? Thoughts?

Mike

General Discussions

answered on 12 Mar 2010