Telerik Forums
Reporting Forum
11 answers
1.2K+ views

Hello.

I use reporting together with entity framework.

Generally the structure is this:

1. I have a winform and there I select what kind of report I want to see, and also select data for the report.

2. I pass this data to report and refresh it.

I have a report that has some tables and lists inside. To pass data to those report elements I defined SetDS method for each report. For example:

public void SetDS(Product product)  
        {  
            EntityTools.LoadReferences(product);  
 
            foreach (WciFilling item in product.WciFilling)  
                EntityTools.LoadReferences(item);  
            foreach (WciAdditionalItem item in product.WciAdditionalItem)  
                EntityTools.LoadReferences(item);  
 
            this.DataSource = product;  
            this.lstFilling.DataSource = product.WciFilling;  
            this.tbGrid.DataSource = product.WciAdditionalItem.Where(o => o.WciAdditionalItemType.Id.Equals((int)EnWciAdditionalItemType.Grid));  
        } 

So, now I want to use one of these reports as a sub-report inside of list, and the question is how can I call SetDS for that subreport?

Or, maybe, I'm going in a wrong way, and there is a better approach?

Thanks.

Best regards,
Oleksandr

Steve
Telerik team
 answered on 03 May 2011
1 answer
56 views
Hi

Is possible to resize , in silverlight report viewer , the documentmap area ?
thx

Luciano Benetti
Solinfo srl
Steve
Telerik team
 answered on 03 May 2011
1 answer
98 views
Hi,
I'm just wondering how to add horizontal scrollbars to charts in the reporting page.
Thanks in advance.
Hayk
Steve
Telerik team
 answered on 03 May 2011
2 answers
278 views
I'm trying to find a way to display two of my report parameters in my Report Header.  The first parameter is a collection of strings and the second is a collection of longs.  I say Collection because they are defined in the report as:
MultiValue = True
.

Basically what I am trying to do is list the users parameters at the top of the page in a nice format - the report header seems like the right place to do this.  When working with single values, this works fine, but I can't figure out how to iterate through the collection and convert every item to a string.

Thanks in advance for the help...

-Scott
Peter
Telerik team
 answered on 03 May 2011
1 answer
128 views

Dear Support Team

We try to generate report items by code (in this case multiple panels with a key/value list).

The problem now is that the PDF rendering does overlap the panels each time after a new page begins.

I have attached a test report that shows the issue.

The reportlayout.jpg shows the first page with the generated lists (there you can see that all of them have the same distance between each other.

But the first list on 2ndpage.jpg overlaps the next one.

Exporting to HTML or RTF generates those distances correctly.

All panels are generated with Dock.Top, the height is dynamic (based on the number of items in the list).

Is it a known problem of PDF rendering and/or do you have a workaround for that?

Please let me know if you need the code.

Thank you

Björn

Peter
Telerik team
 answered on 03 May 2011
1 answer
124 views
Hi

I am trying to create a report to display job sheets where thumbnails are required for each product ordered.  The report is grouped by categories which allows all products to be manufactured by different departments, the detail section displays the product details eg product code, description, quantity etc.  What I am trying to do is display thumbnails for these product lines in the details section, I would like to display 5 thumbnails for each product but displayed horizontally and not vertically.  I have tried using sub reports but does not work with plugged into the main report.

The attached shows the thumbnails being displayed vertically opposed to horizontally.

Thanks
Steve
Telerik team
 answered on 03 May 2011
2 answers
159 views
I have a report with four sub reports, when I export it to pdf or excel it all looks fine, but when I export it to CSV none of the data from the sub reports is exported. Is this expected behaviour or have I just missed something simple.

Thanks for any help

Patrick
PJB
Top achievements
Rank 1
 answered on 03 May 2011
4 answers
224 views
I have seen various threads on this issue, but have failed to find a solution.

Using Q3 2009, I am creating an invoice report as a master-detail report.  It prints on a pre-printed form.

There is a page header set to print on each page.  There is a page footer which (ideally) I would like printed on the last page only, and contains the totals.  At present it prints on each page, if there is more than one, and I can't find a way of suppressing print on all but last page in code.

I could perhaps delete the page footer, and put the totals in a report footer, which would obviously print on the last page, but then the footer appears immediately after the detail lines, whereas I am printing on a preprinted form, and the totals must be at the bottom of the page.

You have a demo on creating an invoice report, but it seems to me too simplistic.  Most invoices will want running totals (c/f and b/f) and many will want the final totals at the foot of the final page instead of at a random position.

Can anyone advise please?


Theodor
Top achievements
Rank 1
 answered on 02 May 2011
6 answers
259 views
I have a report like that
groupheader1
    groupheader2
        detail
    groupfooter2
groupfooter1

for some groupheader2, i need a page break page.
I write some code, like that :

 

        private void groupHeader2_ItemDataBinding(object sender, EventArgs e)  
        {  
            Telerik.Reporting.Processing.GroupSection headerAgent = (Telerik.Reporting.Processing.GroupSection)sender;  
            LinqEntityBaseLoan.ComAPayer com = headerAgent.DataObject.RawData as LinqEntityBaseLoan.ComAPayer;  
            headerAgent.Visible = com.Agent_ID != com.SuperAgent_ID;  
            if (headerAgent.Visible)  
                this.groupHeaderAgent.PageBreak = PageBreak.Before;  
            else 
                this.groupHeaderAgent.PageBreak = PageBreak.None;  
        } 

but the result is that in the next printed header, the page break will occur.
I try to change to headerAgent.PageBreak = PageBreak.Before but PageBreak is readonly. It seems that the ..Engine.ReportSection is created before Report.ReportSection (it is normal) and can not be changed (but visible can be !).

After a long search, i created a fake group :
groupheader1
    groupheader2fake
    groupheader2
        detail
    groupfooter2
    groupfooter2fake
groupfooter1

And write the event groupHeader2fake_ItemDataBinding.

Is it normal to proceed like this ? A settable Break Page or an event before the creation of Engine.ReportSection can be usefull !


 

danparker276
Top achievements
Rank 2
 answered on 29 Apr 2011
5 answers
163 views
I appreciate the help in advance!

I have some code here for a chart in my report which resides in the NeedDataSource for the chart.  Everything's working great "except one line" which should change the "stacked bar 100" chart Y labels to percentages (I have four databound series which show fine on the chart otherwise):

 

 

For ThisOne As Integer = 0 To 4

 

 

 

Me.Chart1.Series(ThisOne).Name = Me.ReportParameters("DataTitle" + (ThisOne + 1).ToString).Value

 

 

 

Me.Chart1.Series(ThisOne).Appearance.LabelAppearance.LabelLocation = Charting.Styles.StyleSeriesItemLabel.ItemLabelLocation.Inside

 

 

 

Me.Chart1.Series(ThisOne).Appearance.LabelAppearance.Position.AlignedPosition = Charting.Styles.AlignedPositions.Center

 

 

 

Me.Chart1.Series(ThisOne).Appearance.TextAppearance.TextProperties.Color = Color.Black

 

 

 

Me.Chart1.Series(ThisOne).Appearance.Shadow.Blur = 4

 

 

 

Me.Chart1.Series(ThisOne).Appearance.Shadow.Distance = 2

 

 

 

Me.Chart1.Series(ThisOne).Appearance.Shadow.Position = Charting.Styles.ShadowPosition.BottomRight

 

 

 

Me.Chart1.Series(ThisOne).DefaultLabelValue = "#%"

 

 

 

Next

 


I expected from the documentation and forums that the "DefaultLabelValue" line would change the stacked bar labels to percentages but it does not for me.  I can set the DefaultLabelValue property at design time and all looks dandy, however, that property gets wiped out at the time of the NeedDataSource, hence my feeble attempt here to make things right...

Please point me to the errors of my ways so I can wrap up this chart!

Thanks,
Steve
Rose
Top achievements
Rank 1
 answered on 29 Apr 2011
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
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?