Telerik Forums
Reporting Forum
4 answers
324 views

In MS Access reporting, one of the abilities it has is to keep a report group together based on a column instead of a whole page.

Now, I have read over the documentation on multi column reports and the relevant forum posts as well.  As I understand it so far what I am about to ask is not currently supported, but perhaps it could be in the future.

We have a popular report that is multicolumn that looks as follows:

TOTALS                Store #1            Store #2
Total Units                  5                       10
Product1 Income      $500                  $1000
Product2 Income      $600                  $2000
Product1 Avg           $132                  $325
....

Essentially the first column is a header column going down the page, and then each of the next columns is a different part of the grouping called "stores". 

As I have seen so far telerik reports for multicolum cannot handle this kind of grouping behavior.  Is this correct or have I missed something?  If it does not support this ability, are there plans to add this in the future?

Although in some ways the point is moot since according to the documentation the HTML viewer will only render one column anyway.  I would definitely need it to render all the columns in the HTML viewer since our application is web based.

Thanks for your help.

Steve
Telerik team
 answered on 12 Sep 2011
4 answers
148 views
Hi,

I'm building a report where the data is coming from a WCF Data Service.

I've therefore taken the approach outlined in this thread - http://www.telerik.com/community/forums/reporting/telerik-reporting/getting-data-from-web-service.aspx

In my report class I've added reference to the WCF Service and then implemented an extension - giving me a method that gets the data from the actual WCF service and returns an enumerable of the datatype I need to put into a table in the report.  My new method is called "GetInvoicesDueThisMonth"

I've then added an ObjectDataSource from the toolbox and set it up in exactly the same way as the thread above - with the DataSource being the WCF service client class and the DataMember being the new extension method I implemented.

Next I set the DataSource of the Report to be the ObjectDataSource I added from the toolbox.

Finally I clicked on the Table Wizard from the toolbox and when I select my ObjectDataSource from the "Current Data Sources" - it throws back an error "Method GetInvoicesDueThisMonth() Not found."

I've attached two screenshots - the first showing the method implemented in the service extension and the second showing the error I'm getting...  I've obviously had to blackout parts that I can't show.

Any idea how to resolve this and what I could be doing wrong?

Chris
Top achievements
Rank 1
 answered on 12 Sep 2011
0 answers
102 views
Hi,

as i saw the telerik reporting for ASP.Net AJAX render the report in another request or in some async manner. what i want is how can i tell reportviewer to render the report in the current request (before request finish) ?

Thank You ,
Eastern
Top achievements
Rank 1
 asked on 11 Sep 2011
0 answers
222 views
hi!

i have a report where the textboxes in the GroupHeader and Detail use the Docking = Left to simulate a table. In the Detail section, i use filters to add a border-top and border-bottom depending on a value and also to alternate the background-color of the row.

The code that i use is this:
FormattingRule alternateRowFormatingRule = new FormattingRule();
alternateRowFormatingRule.Filters.Add(new Telerik.Reporting.Data.Filter("= RowNumber() % 2", Telerik.Reporting.Data.FilterOperator.Equal, "0"));
alternateRowFormatingRule.Style.BackgroundColor = System.Drawing.Color.WhiteSmoke;
 
FormattingRule atr99 = new FormattingRule();
atr99.Filters.Add(new Telerik.Reporting.Data.Filter("= Fields.IdRegionTouristique", Telerik.Reporting.Data.FilterOperator.Equal, "99"));
atr99.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
atr99.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.None;
atr99.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
atr99.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(2D, Telerik.Reporting.Drawing.UnitType.Pixel);
atr99.Style.Font.Bold = true;
 
detail.ConditionalFormatting.Add(alternateRowFormatingRule);
detail.ConditionalFormatting.Add(atr99);

Everthing works fine except that when i publish the report in PDF format, the width of border-top is really at 2px but the width of border-bottom is at 1px (check the report.png file)
 
With the test that i've made, i think the problem come from the background color of the next row (gray) that overlap the previous row (white) for 1px. This is why i have a border-bottom of 1px and not 2px. If i alternate the background-color differently (the next row is white and the previous row is gray), the border-bottom have 2px (check the report_alt.png)

Also, if you check the header of the table, you will see that to border-top and border-bottom is different compared to the ones on the other column. I have put a red arrow to show you where exactly. The difference between the two textboxes here is that the first one use a border-left of 1px but not the other one aside. If i remove the border-left, the border-top and border-bottom will be identical of the one aside.

Do you have an idea on how to solve these problems? btw, i've tried to use the Table control but i didnt found how to use it properly on this simple report.

thank you for the help!

alex
Alexandre Jobin
Top achievements
Rank 1
 asked on 08 Sep 2011
1 answer
127 views
I have a SqlDataSource that shows results, but not shown DataExplorer fields, the query is done through a stored procedure that contains dynamic SQL.
Steve
Telerik team
 answered on 08 Sep 2011
3 answers
208 views
Hi there

An old version of Telerik Reports (2.0.1.0) I have on a large web site will not compile (publish) when I have the latest version of your reports installed (5_1_11_713). It keeps adding a reference to the new version of the reports in my config file, even though the old version is all that is referenced.

It adds reference to the new version , and then errors out on a section of code that tries to create PDF files:

 buffer = Telerik.Reporting.Processing.ReportProcessor.Render("PDF", rpt, Nothing, mimType, extension, encoding)
 fs = New FileStream(lblPDF.Text & lstSelected.Items(intYCount).Text & ".pdf", FileMode.Create)
fs.Write(buffer, 0, buffer.Length)
  fs.Flush()
 fs.Close()


: The line " Telerik.Reporting.Processing.ReportProcessor.Render" comes back with an 'ambiguous namespace' issue. This code works fine when I uninstall the newer version of the Reports (5_1_11_713).

Thanks - David
Steve
Telerik team
 answered on 08 Sep 2011
2 answers
78 views
Hello.

I'm having trouble with a report. The data source is a list of objects, each of which I know to have certain public properties. My textboxes are bound to those properties in the usual way (e.g. "=Fields.Name").

I am getting errors in my report indicating that it could not find the properties for those textboxes, in certain cases. When my data source objects directly implement a public property "Name", all is well and I get data in the textbox bound to the property Name. HOWEVER, if my data objects inherit from another class, which has a public property "Name", then I get those nasty red boxes that say "An error has occurred while processing TextBox 'Name': The expression contains object 'Name' that is not defined in the current context".

Am I correct that the TextBox is not seeing inherited public properties? If so, is there something I can do so that those inherited public properties will show up in my reports?

Thanks!
Mark
Top achievements
Rank 1
 answered on 08 Sep 2011
0 answers
36 views
Deare All,

i want to know how to concatinate more fields in one textbox seperated by "/" in expression of text box
Mahmoud
Top achievements
Rank 1
 asked on 08 Sep 2011
2 answers
210 views
Hello.

I want to save a report as an pdf-document. Herefore I use following code:


try
{
    ReportProcessor reportProcessor = new ReportProcessor();
    RenderingResult result = reportProcessor.RenderReport("PDF", report, null);
 
    using (FileStream fs = new FileStream(fileName, FileMode.Create))
    {
        fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
    }
}
catch (Exception ex)
{
    return false;
}

This actually works on the working machine debugged with VS2010. But when I want to use this as published version on the server the following error occurs (on rendering the report):

MESSAGE:
ExtensionParameter Unit on extension type Telerik.Reporting.ExcelRendering.Excel97.ExcelReport, Telerik.Reporting, Version=5.1.11.713, Culture=neutral, PublicKeyToken=a9d7983dfcc261be can not assign the specified value. -
 Stacktrace:    bei V10Portal.Core.ScheduledJobs.SendReportJob.saveReportOnHarddisk(Report report, String fileName) in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 408.
   bei V10Portal.Core.ScheduledJobs.SendReportJob.logSaveReports(String& logErrorIn, String reportsPath, List`1 reportsToSend) in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 701.
   bei V10Portal.Core.ScheduledJobs.SendReportJob.Run() in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 186.
 
STACKTRACE:
bei Telerik.Reporting.Interfaces.Attributes.ExtensionParameterAttribute.Apply(ExtensionInfo extInfo)
   bei Telerik.Reporting.Processing.ExtensionInfo.Create(Type extensionType, String extensionName)
   bei Telerik.Reporting.Processing.ExtensionManagerBase.CreateExtensionInfo(String typeName, String extensionName)
   bei Telerik.Reporting.Processing.ExtensionManagerBase.Load(ExtensionInfoCollection extensions, IEnumerable`1 extensionTypeNames)
   bei Telerik.Reporting.Processing.ExtensionManagerBase..ctor(IEnumerable`1 extensionTypeNames, ReportingConfigurationSection section)
   bei Telerik.Reporting.Processing.ExtensionManager.get_Instance()
   bei Telerik.Reporting.Processing.ExtensionManager.ListExtensions(Type extensionType)
   bei Telerik.Reporting.Processing.ReportProcessor.GetRenderer(String name)
   bei Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, IReportDocument reportDocument, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback)
   bei Telerik.Reporting.Processing.ReportProcessor.RenderReportStateless(String format, IReportDocument reportDocument, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback)
   bei Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, IReportDocument reportDocument, Hashtable deviceInfo)
   bei V10Portal.Core.ScheduledJobs.SendReportJob.saveReportOnHarddisk(Report report, String fileName) in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 404. -
 Stacktrace:    bei V10Portal.Core.ScheduledJobs.SendReportJob.saveReportOnHarddisk(Report report, String fileName) in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 408.
   bei V10Portal.Core.ScheduledJobs.SendReportJob.logSaveReports(String& logErrorIn, String reportsPath, List`1 reportsToSend) in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 702.
   bei V10Portal.Core.ScheduledJobs.SendReportJob.Run() in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 186.

May you have a solution or some hints for me what errors could have this exception in consequence?

Thanks.


Best regards

David
Marc
Top achievements
Rank 1
 answered on 08 Sep 2011
1 answer
118 views
Hello!

I have a telerik Report with various Date fields, 2 of them are the report parameters and the other is from my database.

I set the date format for my 2 textbox that shows the Selected date on the DateTimePicker to 01/01/2011
and to my date column i set a format like this: 01/01/2011 08:00 (with time)

My problem is, on development machine all works perfect, but when i deploy my application, the fields show the dates in a differente way,
all of them use this format 1/1/2011 (without the "0").

I tried everything untill now and had no success, my question is, there's something that i need to change to get this format on my date times in the server or something?

I attach a image taht shows the problem.

Thank you!
Steve
Telerik team
 answered on 08 Sep 2011
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
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?