Telerik Forums
Reporting Forum
1 answer
89 views
I have a query that is returning TotalSubmissions, AcceptedSubmissions, RejectedSubmissions and PendingSubmissions.  These are drawn as four bars on a bar chart.  I want to add two ChartMarkedZones to the chart, one at 10% of the TotalSubmissions and one at 60% of TotalSubmissions.  How do I go about this?

Thomas
Elian
Telerik team
 answered on 20 Feb 2012
3 answers
336 views
I have a crosstab with the following Row Groups:
Year ->
     Month ->
             Sales Unit ->
                       Sub Sales Unit 1 ->
                                  ... Sub Sales Unit N ->
                                                           Product ->
                                                                             Detail.

Groups are linked to each other by parent-child relationship.
In an application this tree structure is dynamic, the level of the Sub Sales Units equals 1...N (for example Nmax=5). User can select Sales Units that are shown on the report.
How to prepare a report with this structure. Is it possible to hide unused levels and show Product and Details?
Detail group in the crosstab is linked with the last child group. How can I show Product and Details if there are less levels than Nmax?
Attached image shows a report with one Sub Sales Unit. I'd like to avoid designing a separate reports for each level.

Thanks,
Sebastian
IvanY
Telerik team
 answered on 20 Feb 2012
3 answers
519 views
Hi,

After click the print button,no dialog display anymore and directly print to a pdf file. I checked the demo(http://demos.telerik.com/reporting/product-sales/demo.aspx)     it's the same.But the previous version is normal.

thanks

Kevin

IvanY
Telerik team
 answered on 20 Feb 2012
13 answers
432 views
I am calling ReportBook from ReportViewer(in silverlight). In silverlight I am passing parameter to reportbook as follows.
void ReportViewer1_RenderBegin(object sender, RenderBeginEventArgs args)
  
{
  
//single value parameter 
  
args.ParameterValues["FormNumber"] = "ABC1";
  
args.ParameterValues["FormID"] = 10;
  
}
In ReportBook I am adding reports as follows.
class ReportBook2 : Telerik.Reporting.ReportBook
  
{
  
public ReportBook2()
  
{
  
this.Reports.Add(new Report1());
  
this.Reports.Add(new Report2());
  
this.Reports[0].DocumentMapText = "Dash Board";
  
this.Reports[1].DocumentMapText = "Product Sales";
  
}
  
}

Report1 needs parameter FormNumber. Report2 needs parameter FormID.
1. How to transfer these parameter to appropriate reports from reportbook?
2. Is there any way to add reports to reportbook from client(Silverlight) with appropriate parameters?


Steve
Telerik team
 answered on 20 Feb 2012
4 answers
313 views
Hi,

I need to put a subreport in a groupfooter, and I can't seem to make it work.
So, I have a Master Report, called List, this object has several properties that have to be set on the Master report.
In the detailsection I've put an SubReport, this Detail Report contains all lines from the List.
Until here, everything works great.
In the detailreport I've added several groups, because the lines have to be grouped.

Example:

Driver A (Driver-Group)
    Customer X (Customer Group)
         Address XYZ (Address Group)
              - Line1
              - Line 2
              - Line 3
          Address XYZ Footer: SubReport with all carriers on line 1,2,3
        Address ABC
              - Line 4
              - Line 5
         Adress ABC Footer: Subreport with all carriers on line 4,5
    Customer Y
    ...
Driver B
...

So I've managed to display all lines corretly,
I've also managed to get all group-data (Driver A, Customer X, Address XYZ)
By storing it in private variable in the detail_ItemDataBound,
when I debug I see that the correct data is being fetched.

private void detail_ItemDataBound(object sender, EventArgs e)
        {
            Telerik.Reporting.Processing.DetailSection detailSection = (Telerik.Reporting.Processing.DetailSection)sender;
 
            TransportListDocument doc = (TransportListDocument)detailSection.DataObject.RawData;
 
            if (doc != null)
            {
                if( String.IsNullOrEmpty(doc.Memo))
                {
                    txtMemo.Visible = false;
                    captionMemo.Visible = false;
                }
 
                txtType.Value = Translator.Translate("_" + doc.DocumentType);
                listId = doc.TransportListId;
                driverId = doc.Driver.Id;
                customerId = doc.Customer.Id;
                addressId = doc.Address.Id;
            }
        }

private void subCarriers_NeedDataSource(object sender, EventArgs e)
        {
            Telerik.Reporting.Processing.SubReport subReport = (Telerik.Reporting.Processing.SubReport)sender;
            if(listId > 0 && driverId > 0 && customerId > 0 && addressId > 0)
            {
                AmountOfCarriers amountOfCarriers = DataFacade.Transport.DFCarrier.GetAmountOfCarriers(listId, driverId, CustomerId, addressId, LanguageId, BranchId);
 
                if (amountOfCarriers != null && amountOfCarriers.Count > 0)
                {
                    subTLCarriers1.SetPrivateDataMembers(Translator, LanguageId);
                    subTLCarriers1.DataSource = amountOfCarriers;
                }
            }
        }


or by using the data I find for each Address-group:

private void groupFooterAddress_ItemDataBound(object sender, EventArgs e)
        {
            Telerik.Reporting.Processing.ReportSection addressGroupSection = ((Telerik.Reporting.Processing.ReportSection)sender);
            Telerik.Reporting.Processing.Group customerGroup = ((Telerik.Reporting.Processing.Group)addressGroupSection.Parent.Parent);
            Telerik.Reporting.Processing.Group driverGroup = ((Telerik.Reporting.Processing.Group)customerGroup.Parent);
            TransportListDocuments docs = (TransportListDocuments)addressGroupSection.Report.DataSource;
 
 
            int selectedAddressId = ((Address)addressGroupSection.DataObject["Address"]).Id;
            int selectedCustomerId = ((ObjectModel.Customer.Customer)(customerGroup.GroupHeader.DataObject["Customer"])).Id;
            int selectedDriverId = ((Driver)(driverGroup.GroupHeader.DataObject["Driver"])).Id;
 
            AmountOfCarriers amountOfCarriers = DataFacade.Transport.DFCarrier.GetAmountOfCarriers(docs[0].TransportListId, selectedAddressId, selectedCustomerId, selectedDriverId, LanguageId, BranchId);
 
            if (amountOfCarriers != null && amountOfCarriers.Count > 0)
            {
                subTLCarriers1.SetPrivateDataMembers(Translator, LanguageId);
                subTLCarriers1.DataSource = amountOfCarriers;
 
            }
        }

which is sufficient to me to get data for the subreport in the footer.


Only the last line of code (subTLCarriers1.DataSource = amountOfCarriers;) sets the datasource on the control on the Detail Report, not the instance of the subreport in de groupFooter, as result, I get the same subreport for ALL the groups in my Detail Report instead of a different subreport for each address-group of lines.

Could you help me find a way to set the DataSource of each instance of the subreport in the Group-Footer,
so that each Address-Group get it's own subreport in it's footer?

Any help is very much welcome since I've been struggling with this for a few days now.



Koen L
Top achievements
Rank 1
 answered on 20 Feb 2012
1 answer
320 views
How to show ellipsis to indicate text overflow in the textblock control in telerik reporting 
Steve
Telerik team
 answered on 20 Feb 2012
0 answers
142 views
Hi,

I have a problem in impleminting the following code (Which is belongs to the RadGrid ASP.NET AJAX control) uisng the Reporting Table control:
protected void MainRadGrid_PreRender(object sender, EventArgs e)
{
foreach (GridDataItem dataItem in MainRadGrid.MasterTableView.Items)
{
int previousItemIndex = dataItem.ItemIndex - 1;
if (previousItemIndex >= 0)
{
if (dataItem["Number"].Text == dataItem.OwnerTableView.Items[previousItemIndex]["Number"].Text)
{
dataItem.OwnerTableView.Items[previousItemIndex]["Number"].RowSpan = 4;
dataItem.OwnerTableView.Items[previousItemIndex]["Number"].BackColor = System.Drawing.Color.FromName("#FAF8BB");
dataItem["Number"].Visible = false;
}
if (dataItem["Color"].Text == dataItem.OwnerTableView.Items[previousItemIndex]["Color"].Text)
{
dataItem.OwnerTableView.Items[previousItemIndex]["Color"].RowSpan = 2;
dataItem.OwnerTableView.Items[previousItemIndex]["Color"].BackColor = System.Drawing.Color.FromName("#B6F1FA");
dataItem["Color"].Visible = false;
}
}
}
}

And which event should I use here: ItemDataBinding or ItemDataBoun

Please, I need your help.

Regards,
Bader
Bader
Top achievements
Rank 1
 asked on 19 Feb 2012
9 answers
454 views
Hi..
 To make invoice-report, I need put the "report Footer Section" , on bottom of last page. (its posible the invoice was multiple pages). Or other wise, is,  if its posible plase the "pageFooter-secction" only was visible on last page . ()
 
Best regards from Barcelona-Spain.






manuelmoraga
Top achievements
Rank 1
 answered on 17 Feb 2012
1 answer
257 views

Hello. I use teleric reporting for ASP.NET MVC

  I want to make visibility  of  one report's  parameter is depend from value of  another report parameter.

 If parameter "1"  is equal to "Value1" I need to specify report's conditions with parameter "2", but if  parameter "1"  is equal to "Value2"  parameter "2" is lost sense and I want to hidden it.  (parameter "1" use AvailableValues mode)

Can I implement this scenario? I didn't found parameter changed value event?  Is exist another way

Thank you.

Vladislav

Elian
Telerik team
 answered on 17 Feb 2012
3 answers
159 views
I am using Silverlight Report Viewer with UseNativePrinting = false.  If Adobe PDF plug-in is not detected then I am prompted to save the PDF file.  Is there a way of detecting this event and prompting the user that they need to install Adobe PDF plug-in?
Steve
Telerik team
 answered on 17 Feb 2012
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?