Questions on Reporting Forum

1 answer

735 views

Telerik.Reporting.dll not referenced after build

I have just installed the 2012 Q1 release.
If I create a new project and add a Telerik report,
the Telerik.Reporting and Telerik.Reporting.Design dlls
are added to the project's references.
The designer throws an error that the Telerik.Reporting.Report class is not found.
The Telerik,Reporting assembly is not visible in the object browser.
Afte closing VS and reloading the project, the Telerik.Reporting dll is visible
in the object browser until I either build the project or open the report designer wizard.

I'm using VS2010 SP1 on windows 7 professional 64bit.
Has anyone else run into this issue?
Corrective action?
Thanks,
Mark

General Discussions

answered on 20 Feb 2012

1 answer

57 views

Add ChartMarkedZone to bar chart based on data

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

General Discussions

answered on 20 Feb 2012

3 answers

276 views

Crosstab row groups tree structure

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

General Discussions

answered on 20 Feb 2012

3 answers

320 views

print to pdf directly

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

General Discussions

answered on 20 Feb 2012

13 answers

347 views

How to transfer parameter values from reportbook to added reports

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?

General Discussions

answered on 20 Feb 2012

4 answers

213 views

Subreport in GroupFooter

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.

General Discussions

answered on 20 Feb 2012

1 answer

252 views

Ellipsis in textblock

How to show ellipsis to indicate text overflow in the textblock control in telerik reporting

General Discussions

answered on 20 Feb 2012

0 answers

85 views

Accessing table rows

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

General Discussions

asked on 19 Feb 2012

9 answers

357 views

How can I put a section at the end of the page?.

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.

General Discussions

answered on 17 Feb 2012

1 answer

213 views

Parameter Value changed value

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

General Discussions

answered on 17 Feb 2012