Telerik Forums
Reporting Forum
1 answer
101 views
Hi, 

I have a Line Chart Setup and it is working great with one ChartSeries. However when I add two sets of data my legend overlaps my labels. Is there any way to prevent this ? My Chart could have 1 set of data or 5 sets of data and my legend should be able to accomdate that. Any help would be appreciated. 

Thanks, 

Stefen 
Stefen
Top achievements
Rank 1
 answered on 03 Jun 2011
1 answer
130 views
Is a have a report created which shows a basic shape and a textbox with the value of [= Parameters.SomeParameter.Value].

I have code in my Silverlight client which passes the param as 
args.ParameterValues.Add("SomeParameter", "Some text");
in the RenderBegin event.  This code fires off, but I just receive an error from the Silverlight Report Viewer of:

One or more parameters are not set or have invalid values.

Can I bind to just report parameters?  I am doing this because it is ungodly hard to pass over my objects for the report from the Silverlight client.


Keith
Top achievements
Rank 1
 answered on 02 Jun 2011
6 answers
662 views
How do I set up gridlines so it looks like the data is in a table with lines. Like Excel. I've search the docs and forums but cant find what I'm looking for.

Long week, sorry if this doesn't make sense.

Andy
Steve
Telerik team
 answered on 02 Jun 2011
6 answers
377 views
I have a fairly basic tabular report. If I export the report to excel and then try to sort it I get an error that it can't sort because the merged cells are not all sized the same. I don't need or want merged cells in the excel file. How can I get the excel export to not merge cells?
Gersh
Top achievements
Rank 2
 answered on 02 Jun 2011
2 answers
133 views
Hello 

I need to create (reporting) chart on aspx codebehind programmaticaly. I couldnt find out how to do it .  All  programmaticaly examples which i ve seen were creatiıng programmaticaly chart on report.cs instead of aspx.cs.

Im waitin for ur helps.

Thanks..


 
engin
Top achievements
Rank 1
 answered on 02 Jun 2011
1 answer
609 views
Hi,

I'm trying to set height of table element in report. Whatever I enter as value height in pdf reportheight is always bigger. I want to set for example height to 0,4 cm but in report its more then 1 cm. I try to set cangrow to false but no use. I aslo try to set value to 11 cm and then height is like that.

Paddings are all set to 0 and I dont know why row height cannot be like I set in designer (0,4 cm). You can see in pictures what I'm talking about.

Marko
Stephan
Telerik team
 answered on 02 Jun 2011
3 answers
136 views
Recentelly Installed 5.0.11.316 version of Telerik.ReportViewer.Silverlight
But I am getting attach error please let me know how we can resolve it!

Thanks,
Ed
Massimiliano Bassili
Top achievements
Rank 1
 answered on 02 Jun 2011
1 answer
355 views
 Hello,

I have report datasource like the following:

SELECT

 

 

 

 

,firstname

 

 

 

,lastname

 

 

 

,email

 

 

 

,amount

 

 

 

,dcomments

 

 

 

 

 

FROM

 

[donation]

WHERE

 

firstname LIKE '%'+@firstname+'%'

 

OR

 

lastname LIKE '%'+@lastname+'%'

 



How do i pass @firstname parameter value from report. I am trying to display textbox where user can key in but i could not. I can do dropdown for firstname but i am trying to do textbox.

Do you have any example for my issue?
Thanks,
Steve
Telerik team
 answered on 02 Jun 2011
0 answers
123 views
Hi
I have placed a Textbox in Report header section and name it prm2
i set its value in Report_NeedDatasource event but its value are not displayed when preview the report
For other non cross tab reports it works fine 

Here is my code

 private void crosstab1_NeedDataSource(object sender, EventArgs e)
        {
            SqlConnection CN = new SqlConnection();
            SqlCommand cmd = new SqlCommand();
            SqlDataAdapter adp;
            try
            {
                string strQuery = "", strWhere = "";
                //--- Criteria
                string vToDate = sftParser.NullToVal(prm["toDate"]);
                string vFromDate = sftParser.NullToVal(prm["fromDate"]);
                if (vFromDate.Equals(""))
                    vFromDate = common.registry.getOpeningDate();
                if (vToDate.Equals(""))
                    vToDate = "2050-12-12";
                 //-----------------------------------------------------------------------
                strQuery = @"Select ExternalCode,ProductName,PackingName,WareHouseId,WareHouseTitle,Type,SUM(Qty) as Qty
                    FROM         StockTransaction ST 
                    WHERE    ST.TransactionDate>=@FromDate And ST.TransactionDate<=@ToDate
                    Group by Pro.ExternalCode,Pro.ProductName,PP.PackingName,WH.WareHouseId, WH.WareHouseTitle,Type";

                cmd.CommandText = strQuery; cmd.Connection = CN;
                cmd.Parameters.AddWithValue("@FromDate", vFromDate);
                cmd.Parameters.AddWithValue("@ToDate", vToDate.Equals("") ? null : vToDate);
                
                //passing null value to parameters not supplied
                foreach (SqlParameter Parameter in cmd.Parameters)
                {
                    if (Parameter.Value == null)
                        Parameter.Value = DBNull.Value;
                }
                adp = new SqlDataAdapter(cmd);
                
                DataTable tbl = new DataTable();
                adp.Fill(tbl);
                adp.Dispose();




                Telerik.Reporting.Processing.Table table = (Telerik.Reporting.Processing.Table)sender;
                table.DataSource = tbl;
                //-------------------------------------------------------------------------
                vToDate = sftParser.NullToVal(prm["toDate"]);
                this.prm2.Value = "From: " + String.Format("{0:dd/MM/yyyy}", Convert.ToDateTime(vFromDate)) + " To: " + (vToDate.Equals("") ? " All " : String.Format("{0:dd/MM/yyyy}", Convert.ToDateTime(vToDate)));

               // or apply this did not work
 Telerik.Reporting.TextBox txt = this.Items.Find("prm2", true)[0] as Telerik.Reporting.TextBox;
                txt.Value = "From: " + String.Format("{0:dd/MM/yyyy}", Convert.ToDateTime(vFromDate)) + " To: " + (vToDate.Equals("") ? " All " : String.Format("{0:dd/MM/yyyy}", Convert.ToDateTime(vToDate)));

               
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                cmd.Dispose();
                CN.Close(); CN.Dispose();
            }
             

Saima Gul
Top achievements
Rank 1
 asked on 02 Jun 2011
2 answers
388 views

Hello everybody,

I want to pass a dynamic DataSet which has been generated by
an outside code (request) to telerik's report.

Exemple

 
//Library Report DataSet 
 
DataSetReport{ 
column1, 
column2, 
column3, 
column4 
 
 
//OutSideCode 
 
request = "Select * from Telerik"
DataSet dataSetReport = request.Result().DataSet(); 
 
LibraryReportDataset libraryReport = new LibraryReportDataset (); 
 
//To this report, i want to associate my dataSetReport... 
 
libraryReport.AssociateDataSet(dataSetReport); 


and after, the result is going to be a report with the dataSetReport's data...

I searched everywhere but i found nothing...

Can someone help me?

Thanks...
Daniel Botero Correa
Chris @ Intrinsic
Top achievements
Rank 1
 answered on 01 Jun 2011
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?