Telerik Forums
Reporting Forum
0 answers
104 views
Hi, I'm a senior .net mvc freelancer.  I've got a contract I'm trying to wrap up and suspect telerik reporting will help me knockout the 10 reports I have left.

The thing is, I've never used it before.  I've just spent about 3 hours playing around with it and am sure I can handle it but I know from experience it will be 10 times faster with a partner with experience. 

So, if you know how to implement reporting over entity framework code first and .net mvc4, I could sure use an hour of remote pair programming!  Of course, I'm willing to pay.  Let me know what you think is fair. - (danschlossberg at  really_big_search_engine_mail.com)

I've attached relevant data model and wireframe of one report.  I can't imagine that anyone would be able to understand how to map it without a detailed conversation.  There are several pivots and intermediary calculations required. 

Oh, maybe the following linq statement will help. :)

var data = from week in base.Db.WeeklyInputs
                 where week.FranchiseId == franchiseId && week.Year == year
                 select new
                   {
                     week.FranchiseId,
                     week.WeekEnding,
                     week.CleaningWages,
                     week.BonusWages,
                     week.TotalMaidsAbsent,
                     week.TotalMaidsScheduled,
                     week.MaidTurnover,
                     week.TotalMaidMinutes,
                     week.AverageTeamSize,
                     week.TravelTime,
                     week.QualityCardsReturned,
                     week.QualityCardPoints,
                     Cancels = week.CustomerCancellations,
                     Name = week.Franchise.Title,
                     TotalRev = week.WeeklySalesByLocation.Sum(sales => sales.Sales),
                     TotalUnitsCleaned = week.WeeklySalesByLocation.Sum(s => s.UnitsCleaned),
 
                     AverageQualityPoints = week.QualityCardsReturned == 0
                                              ? 0
                                              : week.QualityCardPoints/week.QualityCardsReturned,
                     AverageHourlyWage = week.TotalMaidMinutes == 0
                                           ? 0
                                           : (week.CleaningWages)*60/(week.TotalMaidMinutes),
 
                     RegularRev = week.WeeklySalesByLocation
                   .Where(s => s.LocationType == "Regular").Sum(sales => sales.Sales),
                     FirstRev = week.WeeklySalesByLocation
                   .Where(s => s.LocationType == "FirstEntry").Sum(sales => sales.Sales),
                     OnCallRev = week.WeeklySalesByLocation
                   .Where(s => s.LocationType == "OnCall").Sum(sales => sales.Sales),
                     CommercialRev = week.WeeklySalesByLocation
                   .Where(s => s.LocationType == "Commercial").Sum(sales => sales.Sales),
                     Conversions = week.MarketingExpenses
                   .Sum(marketing => marketing.Conversions),
 
                     Locations = week.WeeklySalesByLocation
                   .Select(l => new
                     {
                       l.Sales,
                       l.LocationType,
                       l.UnitsCleaned,
                       l.TeamMinutes,
                       l.MaidMinutes,
                       AverageSale = l.UnitsCleaned == 0 ? 0 : l.Sales/l.UnitsCleaned,
                       AverageTime = l.UnitsCleaned == 0 ? 0 : l.MaidMinutes/l.UnitsCleaned,
                       AverageRevPerMaidHour = l.MaidMinutes == 0 ? 0 : (l.Sales/l.MaidMinutes)*60
                     }),
 
 
                     AverageRevenuePerInHomeMaidHour =
                   (week.TotalMaidMinutes + (week.TravelTime*week.AverageTeamSize)) == 0
                     ? 0
                     : week.WeeklySalesByLocation.Sum(sales => sales.Sales)/
                       (week.TotalMaidMinutes + (week.TravelTime*week.AverageTeamSize))*60
                   };


hmmm...  I didn't think so....

Anxiously awaiting your email...
Dan
Daniel
Top achievements
Rank 1
 asked on 07 Jul 2012
3 answers
195 views
I am trying to assign a report to the report viewer in the code-behind as described in this link: http://www.telerik.com/help/reporting/aspnetreportviewerembedding.html

It looks like this doesn't work if the report viewer is inside an UpdatePanel. Is there any way to make this work?
Michael
Top achievements
Rank 1
 answered on 06 Jul 2012
3 answers
173 views
Hi,

When i try to view the Telerik Report in Report Viewer it is not properly aligned to the browser.
This happens when i use the report in Aspx web form as well as MVC application.
I want the report to be alinged to the browser.

Also how can i attach screen shots, when i post my question?

Thanks.
Srinath.
Steve
Telerik team
 answered on 06 Jul 2012
4 answers
382 views
Hello,

is it possible to use the reporting service only for creating a PDF file directly without showing the the report in a viewer?

In the moment the report ist only shown in a Silverlight viewer.
But now I have the requirement to create the report on the server and sent the report directly as a PDF file via Email to the customers.

Regards
Dirk
Dirk
Top achievements
Rank 1
Iron
 answered on 05 Jul 2012
1 answer
129 views
Hi

I have created a couple of reports using Telerik reports. All looked good so we have emailed them to customers.

Customers have replied saying that when they print them they get big black boxes or failure to print messages.

The customers are using Adobe but we have also found version 4 of foxit pdf reader has issues as well. The latest version of Foxit does print the reports.

The code is below that produces the pdf 

   
Dim rptContract As New rptSinglePageContract
        Dim rptProcessor As New Telerik.Reporting.Processing.ReportProcessor
        Dim Contract() As Byte
        rptContract.reportHeader.ConnectionString = GetSQLConnectionString()
        rptContract.reportDetails.ConnectionString = GetSQLConnectionString()
 
        rptContract.ReportParameters("ID").Value = m_contract.ID
        Contract = rptProcessor.RenderReport("PDF", rptContract, Nothing).DocumentBytes
 
        If printersettings.PrinterName <> "" Then
            rptProcessor.PrintReport(rptContract, printersettings)
        End If
 
            IO.File.WriteAllBytes(outputcontractfilename, Contract)

I would have attached examples that you can print yourself to check but .pdf are not accepted. You can get them here http://dropcanvas.com/j10vd

What am I doing wrong? Obviously sending documents to customers that cannot be printed is not acceptable.
Cheers
Steve
Telerik team
 answered on 05 Jul 2012
1 answer
169 views
Is there any way to tell the designer to round widths and heights, or do a more granular method of snapping to the grid?  It is very tedious (and quite frankly, driving me nuts) trying to line up columns, panels and tables when the little triangles keep popping up telling me that my page is too wide or fields are overlapping, when for all intents and purposes, they are not.

When you are dragging textboxes into place and you aren't perfect with the mouse, it can take forever to figure out why the right border of a panel is not printing because the page width changed itself to 8.01 instead of 8 inches, because some field started at 0.01 instead of 0, or I dragged it to far to the right for a millisecond.  And even when they are exact to the designer, it can still say they overlap, and when you look at the Designer.cs code, it appears that it thinks it overlaps because a width isn't really 4.0 like it tells you, but 4.0045234235345345...

If you have any advice of how to make this problem go away, please let me know.
Massimiliano Bassili
Top achievements
Rank 1
 answered on 04 Jul 2012
1 answer
496 views
OK, let's check this off as a first-time stupid newbie question, b/c that's what its got to amount to.

It's my first Telerik report that has a Table control in the detail section and it is bound to a data source. In column 1 of the table is the expression [= Fields.InvoiceNum] and I get an invoice number for every row when I preview the report.

In column 2 of the table, I had an expression that basically amounted to Field2 divided by Field3. But this would always return a zero on every row of the report during preview.

For the sake of testing, my expression is currently [= 1 / 3]. This still returns a zero. If my expression is [= 1 + 3], I get 4. If it is [= 1 - 3] I get -2. If it is [= 1 * 3] I get 3. But [= 1 / 3] always returns 0. If I wrap the expression with [= CDbl(1 / 3)] I still get a zero, and the formatting is {0:#.0000}. So what gives? What am I missing here?

Thanks,
Steve
Peter
Telerik team
 answered on 04 Jul 2012
1 answer
256 views
I've a table item in the detail section of the report. I so far couldn't figure out how to bind just the table, not the entire report, to a data source at run time? Please advice how I can achieve this. Thanks.
Steve
Telerik team
 answered on 04 Jul 2012
11 answers
1.0K+ views

When I do a new report and I want to select the source of data using the wizard Telerik Reporting in the drop-down combo there is no data source (connection). I want to create a new connection and the following message when I press the button "Object Reference not Set to an instace of a object"

This problem also occurs when I want to add a new source of data in the contextual menu in the configure option

How can solves this problem? Thanks

RickyB
Top achievements
Rank 1
 answered on 03 Jul 2012
3 answers
469 views
Good Morning everyone,

i've the following problem. I have a report with hyperlinks assigned to a TextBox. Doing this with the following code in the Detail section:

Telerik.Reporting.NavigateToUrlAction url = new Telerik.Reporting.NavigateToUrlAction();
url.Url = "http://www.telerik.com";
this.textBoxBBlockNo.Action = url;

Working in the Telerik Visual Studio Report Designer i get my hyperlinks when i swtich to the preview tab. When i preview the report in the ReportViewer (WinForms), the hyperlinks are not there.

Any one else experiencing the same behaviour? i'm working on the latest version of Telerik Reporting (Telerik_Reporting_Q2_2012_v6_1_12_611_Dev).

Greetings,
Michael
Steve
Telerik team
 answered on 03 Jul 2012
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
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?