Telerik Forums
Reporting Forum
5 answers
129 views
Very like your work, but don't see some features.

Do you have support for external report templates - like RDL templates in SSRS?
Support of end user report editor?

We are going 100s of reports and we dont want them to be hard coded in .cs.


Rossen Hristov
Telerik team
 answered on 18 Aug 2008
6 answers
539 views

Will Telerik Reporting 2008 Q1 support LINQ datasources?
Svetoslav
Telerik team
 answered on 18 Aug 2008
1 answer
89 views
HI,

I'm just wondering whether visual studio 2008 express supports the telerik reporting tools?

Thanks
Rossen Hristov
Telerik team
 answered on 18 Aug 2008
2 answers
246 views
Hi:

I have a few simple questions - i hope.

Q1. ----------------------------------------------------

I have a report that needs to retreive its data from an SQL function. The SQL Function requires 3 parameters (company,startdate,stopdate)  to be passed to it, and then it returns a table with the desired information.

I created a report (using the wizard)  that has 3 Report Parameters. They are defined as:

1. MyCompany, 2. MyStartDate, 3. MyStopDate

All are these are set as visible, so that they show up in the Report Viewer, and allow the user to select the 3 required values.

What I need to do is have the Report Parameters to be automatically passed to the SQL function.

For ex. Whatever the user enters for "MyCompany" to automatically be used as the "company" parameter when calling the SQL Function.

We can do this with MS SQL Reports, but can't seem to get your report system to make this work.


Q2. --------------------------------------

Also, another problem I'm having is that I can't seem to get the Refresh button on the Web Report Viewer to actually refresh a report. I can't find any event that gets raised when the Refresh button is clicked. Please tell me how I can use this button with server side code. I need to know when the button is clicked on the web page, so that I can somehow rebuild the report, and have the refreshed report re-displayed on the web page.


Thanks for any help you can provide.










Glenn Miller
Top achievements
Rank 1
 answered on 16 Aug 2008
3 answers
529 views
We have created a very dynamically generated report (meaning that it adds subreports and columns depending on the data that is bound to it). When I run the report as a PDF, it works just fine. However, when I export the report as an MHTML or XLS, I get the "Parameter is not valid" exception when it attempts to render the report.

Dim mimType As String = String.Empty 
                Dim extension As String = String.Empty 
                Dim encoding As System.Text.Encoding = Nothing 
                Dim buffer As Byte() = Telerik.Reporting.Processing.ReportProcessor.Render("MHTML", tReport, Nothing, mimType, extension, encoding) 
                Dim fs As New FileStream("C:\Report" ID & ".MHTML", FileMode.Create) 
                fs.Write(buffer, 0, buffer.Length) 
                fs.Flush() 
                fs.Close() 

Like I said, it renders everything perfectly find as a PDF, but when it attempts to render it as an MHTML file or XLS, it blows up.

We are using the NeedDataSource event handler of the SubReports inside of the Main report as described by Telerik as the right thing to do, and it does work flawlessly for PDF. From there we are adding columns and sizing things in the subreport for each section that needs to be added to the report.
Rossen Hristov
Telerik team
 answered on 15 Aug 2008
1 answer
77 views
Hello all -

I have a quick question about series.  Given the following result set:

 
Content Knowledge           Other Supervisor    3.846153 
Content Knowledge           Peer                4.423076 
Content Knowledge           Primary Supervisor  4.571428 
Content Knowledge           Self                4.000000 
Cross Cultural Intelligence Other Supervisor    3.933333 
Cross Cultural Intelligence Peer                4.941176 
Cross Cultural Intelligence Primary Supervisor  5.000000 
Cross Cultural Intelligence Self                4.333333 
Emotional Intelligence      Other Supervisor    4.375000 
Emotional Intelligence      Peer                4.363636 
Emotional Intelligence      Primary Supervisor  5.000000 
Emotional Intelligence      Self                3.888888 
Leadership Attributes       Other Supervisor    4.045454 
Leadership Attributes       Peer                4.157894 
Leadership Attributes       Primary Supervisor  4.916666 
Leadership Attributes       Self                4.083333 
Social Intelligence         Other Supervisor    4.050000 
Social Intelligence         Peer                4.625000 
Social Intelligence         Primary Supervisor  4.181818 
Social Intelligence         Self                4.200000 

Is it possible to auto generate the series rather than having to create them manually?  In this example there should be 4 series (Self, Peer, Other Supervisor, Primary Supervisor).  The x-axis grouping should be Content Knowledge, Emotional Intelligence, etc.  The y data value should be average score.

It seems if I don't manually create the series but only set the following properties on the chart object, it will create the series for me automatically but it is always of type bar chart and I need a line chart.

 
chart1.DataGroupColumn = "RaterType"
chart1.Legend.Appearance.GroupNameFormat = "#VALUE"
chart1.PlotArea.XAxis.DataLabelsColumn = "QuestionSetName"

Having to create the series manually seems like a lot of work.  Any insight to this matter will be greatly appreciated.

Thanks!



Chavdar
Telerik team
 answered on 14 Aug 2008
3 answers
113 views
Hi team

i need to ask about feature that is exit in the crystal reports

in crystal reports if the last  record fields doesn't completed in the page
the record transferred to the next page so all the record field will be in one page

is there is any property in the telerik reporting that can do that
Milen | Product Manager @DX
Telerik team
 answered on 14 Aug 2008
1 answer
206 views
Hello all -

I'm currently evaluating Telerik Reporting and am attempting to create a simple chart.  I have a TableAdapter on the reporting surface as well as a Chart control.  When I bring up the ChartUI I am unable to databind it to the TableAdapter (I'm assuming this is possible?).  The following message is displayed: To dynamically populate the chart with data use the NeedDataSource event.

Is it not possible to define the databindings at design time rather than from within code-behind?  I'm sure I'm just doing something silly but if someone could shed some light on my problem that would be great!

Thanks!
Chavdar
Telerik team
 answered on 14 Aug 2008
1 answer
226 views
Hi

I earlier wrote a post on how to do what was almost a cross join and how to print this using Telerik Reporting, this was currently not very easy.

I figured that the best way simply was to load the data into a Object List and the bind the report to the list.
This all works very well however what iam wondering now is whether it is possible to call a function of the object from the report.

        public string getDayShift(int mDay)  
        {  
            foreach(shift mShift in myShifts) {  
                if ((int)mShift.Start.DayOfWeek==mDay) {  
 
                    return mShift.ToString();  
                }  
            }  
            return "";  
        }  
        public string getShift1  
        {  
            get { return getDayShift(1); }  
            set {  }  
        }  
        public string getShift2  
        {  
            get { return getDayShift(2); }  
            set { }  
        }  
 

Currently iam using the two last functions to allow me access to the function from Telerik reporting, however this gives me quite some redundant code.

Is there any way to call this function directly or is this the only way ?
Rossen Hristov
Telerik team
 answered on 12 Aug 2008
5 answers
624 views
I have been searching for the right code to allow Telerik Reporting Q2 2008 to export the contents of a report to Excel without displaying it in an ASP.NET viewer.  I simply need to hit a button in the webapp and email an attached Excel spreadsheet created in Reporting.  Does anyone have some code or an example.  I have successfully done TIFFs and PDFs this way but not XLS.

Thanks in advance.
Doug
Rossen Hristov
Telerik team
 answered on 12 Aug 2008
Top users last month
Top achievements
Rank 1
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ivory
Top achievements
Rank 1
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
YF
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?