Telerik Forums
Reporting Forum
1 answer
91 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
603 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
276 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
115 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
569 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
107 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
306 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
97 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
355 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
1 answer
109 views
In my application, I have List of fields ,related binding fields,Width alignment etc configuration in On Table in DB.On Silverlight application UI user can select fields those he want to display in report(Not all which are exist in table).So I want to create Report's design and binding Dynamically.For that I need to pass List<T> to report which contains Field related configuration(width,Label,Binding Field,Width etc).If I can do that,I will be able to bind data with that table using dynamic Stored Procedure.But in Silverlight,I do not have reference of Report into Silverlight application,as it is in class library.I am not able to get that Report's Object.Please suggest me what to do in such case?
Peter
Telerik team
 answered on 01 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?