Telrik Reporting Forum…

First, I would like to commend you in developing a great tool for developing Web based reports.    A lot easier than generating the HTML and DB calls.    Bravo!

The reason I am writing is I have an issue that seems common when I Google it and browse Telerik Forums, but I haven’t found the solution that will resolve it for the Customer Service Application I developed.
 
Basically, I pull note data from my SQL Stored Procedure that has embedded carriage returns and line feeds.  The data is then bound to a textobox control on the report.  When the report is viewed, the carriage returns and line feeds are not retained, so all the text is ran together.

I am thinking, but not sure exactly how to to it, I have to some how strip the the carriage returns and line feeds and replace them before rendering control.  The thing is, since I can't see these characters, I am not sure what to search for.   Some of the note data is copied from Outlook E-Mails, maybe Word and pasted in the note field prior to saving the database.

1. With that said, what is best approach for my situation?  
2. What event do I need to place code in do the search/replace?
3. What Telerik Report Control should I use?


The Technical Specs are as follows:
ASP .net 4   VB
SQL 2008 DB
Telerik Q3 2001

Thanks In Advance

Good morning,
Well, I have a problem where I would like for more than two items per line in the report barrade tools.
Follow the image for better understanding.

link for image

Sorry for my english google.

I installed Telerik 2011 Q3 on XP SP3, VS 2008 SP1 succesfull. but when starting VS 2008, An dialog appear :

Package Load Failure
Package 'Telerik.Reporting.VsPackage.VsPackage, Telerik.Reporting.VsPackage, Version=3.20.0, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' has failed to load properly (GUID = {xxxxxxxxxxxxxxxxxxxxx}}. Please contact package vendor for assistance. Application restart is recommended, due to possible environment corruption. Would you like to load this package in the future? you may use 'devenv /resetskippkgs' to re-enable package loading.

and then in VS 2008 I can't see menu Telerik => Reporting ( include submenus of Reporing...) and don't have Data Explore, Group Explore,...window.
I don't know how to fix it. I've installing Telerik Reporting 2011 Q2 and it run normally. After uninstaling Q2 and installing Q3, above err appear.
Please help me.

Hello,

I am working on a report that resembles mostly a crosstab, thatswhy I consider using it. 
My problem is to solve the binding of the objectdatasource, that is a List inside a List.

Looks like the following:

public class GroupedLine
    {
        public string Group { get; set; }
        public BookingType Type { get; set; }
        public BookingStatus Status { get; set; }
        public List<WeeklyStat> WeeklyStats { get; set; }
    }


    public class WeeklyStat
    {
        public DateTime WeekStart { get; set; }
        public decimal Sum { get; set; }
        public int Count { get; set; }
    }

I create a DataSource binding to the CrossTab to this list: List<GroupedLine> GroupedLines.

But I am having trouble figuring out the binding of WeeklyStats that can have as many elements as the number of weeks the user selects in the report parameters. 

I'd like to ask for advice how to accomplish a result like this (in case the selection covers a 5 weeks range):

                                 	Week 22     Week 23     Week 24     Week 25     Week 26
                                        May28-Jun3  Jun4-10     Jun11-17    Jun18-24    Jun25-Jul1
            Group   Type    Status      Cnt. Price  Cnt. Price  Cnt. Price  Cnt. Price  Cnt. Price
            ----------------------------------------------------------------------------------------------
            Group1  Online  New         3   450     0   0       0   0       0   0       0   0
            Group2  Phone   Accepted    0   0       1   80      1   110     0   0       0   0
            Group3  Store   Accepted    0   0       0   0       0   0       1   225     0   0       
            Group3  Store   Invoiced    0   0       0   0       0   0       2   440     0   0           

I have a multi-select Visible report parameter with AllowBlank set to True. When the user de-selects all values in the multi-select, they get a validation error indicating that the parameter is required. Why is this?

Note, if I select AllowNull for the parameter, I get a "NULL" checkbox next to the parameter in the UI, which looks completely ridiculous. I don't want to set it to NULL, I just want to not select any values...

How can I fix this?

We have a report with a chart works fine loading it from the class and setting the data source at run time and load it in the report control works fine. The same report we are serializing(Telerik.Reporting.XmlSerialization.ReportXmlSerializer)

and storing it in the database and deserializing it and then setting the data source at run time but when we load it in the report control it says have no or empty data series. 

Hey All,

I have a text field that I need to format as a date.  Sometimes this field is null, in which case, I can just display an empty value.

I'd like to be able to do this:

=IIf(IsNull(ESR_UDF116, "") = "", "", IIf(Len(ESR_UDF116)=8, Substr(ESR_UDF116,4,2) + "/" + Substr(ESR_UDF116,6,2) + "/" + Substr(ESR_UDF116,0,4),""))

The logic being, if the value is null, then return an empty string.  If the value is not null, then do the formatting.  My formatting hinges on the value being 8 characters long, so I have another embedded IIf that checks the Len of the field.  And that is the problem.

Per the documentation, the functions are evaluated completely *first* and the results passed to the functions.  In this case, when my field is Null, the Len function throws an error and hoses up my report.

It seems logical to me that the functions would be evaluted in precendent order so that the Len call would *never be made* if the field value is Null.

Has anyone ever achieved this desired result?

For a null, show nothing, for a non-null, show a formatted result that involves evaluating on the field itself.

how to bind datasource from C# to the report and load report file .trdx?
please give me an example..
thank you

Hi Telerik,
Please help me how to achieve this:

I have a stored procedure (MS SQL 2008) which is accepting some parameters and returns series of ids of for example invoices. I need to print every invoice on a new paper. I can create  one report for one invoice, but I don't know, how to cycle throug the ids to print all invoices. Or may be, I can create one long for example MS Excell document containing a page breaks to print every inoivce on a new paper. 

Thank you for any help. 

Tom