Telerik Forums
Reporting Forum
1 answer
166 views
I've read through all the posts I can find about how to hide a row dynamically and it seems I'm in the minority since I'm using the designer to build my reports.

How would I configure it so that a row is hidden if a particular value is null via the report designer?

In my case, each record is represented by three rows, the third being a pictureBox.  If a particular field is null, I need to hide the picturebox row.

Thanks in advance!
Stef
Telerik team
 answered on 23 Jan 2013
6 answers
395 views
Ever since I upgraded to the latest version of Reporting the SqlDataSource will not pass parameter values to my stored proc.  I'm using Silverlight.  It ALWAYS says procedure or function expects parameter...  Even if I hard code the value it will not pass it!

It worked fine in the previous version.

ObjectDataSource DOES pass parameters, but a stored proc will not work.
Bob
Top achievements
Rank 1
 answered on 22 Jan 2013
1 answer
84 views
I have a report that is being generated programatically and saving the results to a PDF file which then gets sent to the client. I have a panel that the location is set to X: 0px Y: 73px. However, when it renders on the screen the left is offset by what looks to be the width of the panel directly above it. Here is the XML (Serialized from the programmatic report definition) for the panel that is being offset (Email Address 2) and the panel directly above it (Email Address). I have also attached a screenshot of how it is being rendered. Can anyone see anything in the definition that might be causing this?

<Panel Size="0px, 19px" Location="0px, 54px" Name="pnlE75877F0-849B-4730-90EA-6ED68B904D87">
                     <Style BackgroundColor="Green" />
                     <Items>
                        <TextBox Value="Email Address:" Size="97px, 16px" Location="0px, 0px" />
                        <TextBox Value="=[Person.EmailAddress]" Size="0px, 16px" Location="97px, 0px">
                           <Style>
                              <Font Bold="True" />
                           </Style>
                        </TextBox>
                     </Items>
                  </Panel>
                  <Panel Size="0px, 19px" Location="0px, 73px" Name="pnlA675AD23-718F-4220-B957-C6F250780ECA">
                     <Style BackgroundColor="Green" />
                     <Items>
                        <TextBox Value="Email Address 2:" Size="109px, 16px" Location="0px, 0px" />
                        <TextBox Value="=[Person.EmailAddress2]" Size="0px, 16px" Location="109px, 0px">
                           <Style>
                              <Font Bold="True" />
                           </Style>
                        </TextBox>
                     </Items>
                  </Panel>

Thanks!
Steve
Telerik team
 answered on 22 Jan 2013
3 answers
133 views
Hi,

we have the following request:

c# WPF-Project, n-qlite Databases (1 to n Datasources) and 10 Fix Reports. One sqlite-Database is one company of a Group.
The Application could handle n-companies, so we neeed 1 to n Databases.

Now we have a wpf.application with a report-viewer which shows us 10 Fix-designed reports. But i have to change the Datasource
from company to company, is this possible?

And how does we do this?

Thanks
best Regards
Rene
Stef
Telerik team
 answered on 21 Jan 2013
1 answer
57 views
I got Microsoft Visual Studio 2010 Express installed on my machine. However as I try to install the Telerik_Reporting_Trial_Installer_Q3_2012_SP1_v6_2_13_110 it does not recognize the currently installed vs. The checkbox is unchecked which I think it wasn't able to find the installed vs and no way I could check on the checkbox items.

With that installation problem, I could not find the Telerik Report Wizard on my vs project.

Please advice.

Thanks,
Alpe
Teodor
Telerik team
 answered on 21 Jan 2013
3 answers
270 views

Plotting Pie chart issue:

Data Structure: QuestionID, QuestionName, Answer, ResponseCount

Requirement : Need to plot six pie charts per page (Horizontally 3 per line)

Problem Statement: We are getting the pie chart plotted in vertical and not in horizontal

Solution tried:

We need to plot a pie chart based on the Answer and responsecount. We tried this below option of plotting the chart in the groupheadersection of the report.
 
Chart Title: Question Name
Chart series Item Y Value : ResponseCount
Chart series Item Name : Answer

GroupHeaderSection ItemDataBinding :

In this, we are getting the datatable from the report datasource and binding it to the chart. The piecharts are rendered correctly but getting only 3 pie charts per page in vertical.

We are tried this option based on the below link:

http://www.telerik.com/community/forums/reporting/telerik-reporting/graph-for-each-group.aspx

Note:
We have attached the datastructure in the spreadsheet,generated pie charts (refer image).

Expected Output:
6 Pie charts per page (3 pie charts per line horizontally)

private void groupHeaderSection2_ItemDataBinding(object sender, EventArgs e)
        {
            Telerik.Reporting.Processing.GroupSection groupHeaderSection = (Telerik.Reporting.Processing.GroupSection)sender;
            Telerik.Reporting.Processing.Report report = groupHeaderSection.Report;
            var group = groupHeaderSection.DataObject["QuestionID"];
            DataTable table = (DataTable)report.DataSource;
            DataRow[] rows = table.Select(string.Format(CultureInfo.InvariantCulture, "QuestionID={0}", group), "ResponseCount DESC");
  
            Telerik.Reporting.Processing.Chart chart = (Telerik.Reporting.Processing.Chart)groupHeaderSection.ChildElements.Find("Chart1", true)[0];
            Telerik.Reporting.Chart chartDef = (Telerik.Reporting.Chart)chart.ItemDefinition;
  
            chartDef.IntelligentLabelsEnabled = false;
  
            Telerik.Reporting.Charting.ChartSeries chartSeries = new Telerik.Reporting.Charting.ChartSeries();
            chartDef.Series.Clear();
            chartSeries.Type = Telerik.Reporting.Charting.ChartSeriesType.Pie;
            chartSeries.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels;
            chartDef.Legend.TextBlock.Visible = true;
            chartSeries.Appearance.ShowLabelConnectors = true;
            chartSeries.Appearance.StartAngle = 270;
  
            Telerik.Reporting.Charting.Styles.ChartMargins chartMargins2 = new Telerik.Reporting.Charting.Styles.ChartMargins();
  
            chartMargins2.Bottom = new Telerik.Reporting.Charting.Styles.Unit(20D, Telerik.Reporting.Charting.Styles.UnitType.Percentage);
            chartMargins2.Top = new Telerik.Reporting.Charting.Styles.Unit(5D, Telerik.Reporting.Charting.Styles.UnitType.Percentage);
            chartMargins2.Right = new Telerik.Reporting.Charting.Styles.Unit(5D, Telerik.Reporting.Charting.Styles.UnitType.Percentage);
            chartMargins2.Left = new Telerik.Reporting.Charting.Styles.Unit(5D, Telerik.Reporting.Charting.Styles.UnitType.Percentage);
  
            chartDef.PlotArea.Appearance.Dimensions.Margins = chartMargins2;
  
            foreach (var row in rows)
            {
                chartDef.ChartTitle.TextBlock.Text = row["Description"].ToString();
                ChartSeriesItem item = new ChartSeriesItem();
                item.YValue = Convert.ToDouble(row["ResponseCount"]);
                item.Name = row["Value"].ToString();
                item.Appearance.Exploded = true;
                item.Appearance.FillStyle.FillType = FillType.Solid;
  
                item.Label.TextBlock.Text = row["Value"].ToString() + " - #%";
                chartSeries.Items.Add(item);
            }
            chartDef.Series.Clear();
            chartDef.Series.Add(chartSeries);
            
            chartDef.SeriesOrientation = ChartSeriesOrientation.Horizontal;
  
   
        }

Stef
Telerik team
 answered on 21 Jan 2013
3 answers
93 views
Hi There,

We are upgrading our Reports to Q32012 and work on table based layout feature of it.
We create the telerik reports dynamically and assign NeedDatasource event to load the data.

We have added new references to our project and have changed all possible assembly information correctly
Now in r & d phase things were working fine with older version but now it returns error.
I tried lot of stuffs after browsing few forums on the site but still i am not able to get rid of this error.

I'hv added following code in the constructor.
{
DataSource = null;
NeedDataSource += LoadData;
}


Can anybody have solution on it? Please help.

Stef
Telerik team
 answered on 21 Jan 2013
5 answers
489 views
I am having trouble finding any decent help or examples on how I can display Multi select parameters in a textbox in the report header.
My report has a multi select parameter filled with regions which I want to display as a comma separated list in a textbox.
I would think that this is a commonly required feature so you can display what the report is currently filtering on.
If I use the parameter value or text in the textbox it displays System.Text[]
Chris Gillies
Top achievements
Rank 1
 answered on 21 Jan 2013
3 answers
175 views
Hello All,


One of my report requirement comes to be showing the definition of every item name when mouse moves over the item--namely showing definition in the tool-tips

I am using the table container to hold the data. the medical terms show up in the first column. Right now, I hope i can show definition in tooltips for every term, which is maintained in my back-end table.

Who knows whether it is possible or not showing something in tooltips for the cell in table container?
 
Steve
Telerik team
 answered on 21 Jan 2013
3 answers
466 views
Hi All,
I am new to Telerik Reporting so excuse me if this is a newbie question.
I have searched the forums and it seems that the html textbox will render simple html.  However, when I try and use this control I get all the markup tags mixed with the text.  Is there some trick to getting it to work?
Thanks
Andy
Steve
Telerik team
 answered on 17 Jan 2013
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?