Telerik Forums
Reporting Forum
9 answers
223 views
My report will not be the typical one whereby I have fixed columns and x amount of rows (depending on the amount of
data from a SQL source), I need to create a report with these requirements:
- it will have a fixed amount of pages, say 15 pages
- each page has a different user interface (say checkboxes, frames, text boxes, labels, circles, squares, etc)
- the data for these pages will come from a data source (that's the only similarity with the old one)

I know this have to be done programatically and NOT using the wizard, my question is how (give me a hint)?

can you provide an example of creating say a text box, a field, adding a page, a label and what not on certain page?
and hooking this textbox with a data source.
regards
Wadigzon
Top achievements
Rank 1
 answered on 08 Feb 2013
3 answers
142 views
Is there any way from within the report to determine what report export format is being used.

I'm having an issue where the Column width is calculated wrong when exporting to excel.
Telerik Column Width = 0.85in
Excel Column Width = 0.92in


If I can determine the export is excel within the ItemDataBinding event perhaps I can shrink the columns and textboxes accordingly.


Thanks
Steve
Telerik team
 answered on 08 Feb 2013
3 answers
216 views
I have a report with a horizontal grouping, simple table with column details and static rows.

The page renders to a single page, but when exporting to Excel, I get a page break before the last column.
Export to PDF and Word are fine and Excel has the same page margins.

Its about 60 pixels off, would this be with an issue of calculating Telerik.Reporting.Drawing.Unit to Excel widths or a different box model calculation from padding?

Telerik Column OpenXML (Excel Column)
0.85in 11.66 = 0.92in
Steve
Telerik team
 answered on 08 Feb 2013
6 answers
108 views
Hi Team,

This is M.Madhan Kumar and involved in development of silverlight applications since 2 years,like dashboard application which includes RadGridView,RadChart to display reporting information.

We have a requirement to export each GridView and RadChats into PowerPoint Slides and as we are aware there is no direct way to export charts and gridview into ppt,we would like to use Reporting tools from Telerik.

Here instead of converting all existing silverlight applications into Reporting applications we wpuld like to reuse existing Silverlight application with the help of Reporting tools.

Can you please send me sample code to do that?

Thanks in advance.
Madhan.
Steve
Telerik team
 answered on 08 Feb 2013
3 answers
151 views
Hi,

I am working to convert all Crystal Reports to Telerik Reports. And I see that the Telerik Chart Builder Wizard does not allow to narrow down only selected fields to display on the chart like Crystal Reports (see the attached snapshot). I am new to customize Telerik Report charts and need help to create a pie chart (like the attached image). How can I select only needed fields from a big data source and use aggregate SUM function to display a pie chart with field names shown in the legend.

Thank you for your support.
Khoa
Elian
Telerik team
 answered on 08 Feb 2013
1 answer
95 views
Hello,

We are using Silverlight Report Viewer, how can we set the DataView as the datasource?

Steve
Telerik team
 answered on 08 Feb 2013
6 answers
220 views

(objectDataSource While Getting data From WCF)

Hi All,,

From your demos I fall in love with your products *_*,, So thank you a lot ....

I'm kind off new to Telerik Reporting Tool..

I have a WPF Application Built In MVVM (Model-View-View Model) and it Gets the data inside the Model from a WCF..
It works as a charm..

Now I want to replace the reporting feature in the application with the one your product is providing...

so I've started by creating a ReportsLibrary Project..
Then I've Created the DataSource as an objectDatatSource (So It Reads the data from the following method in the Model Class)

public static List<ALERT> Load()
        {
            List<ALERT> myList = new List<ALERT>();
  
            AlertServices.AlertServiceClient AlertClient = new AlertServices.AlertServiceClient();
            AlertClient.ClientCredentials.UserName.UserName = "usrName";
            AlertClient.ClientCredentials.UserName.Password = "password";
  
            ALERT[] dtAlerts = AlertClient.getAllAlerts();
  
            foreach (ALERT alrt in dtAlerts )
                {
                    myList.Add(alrt);
                }
  
            AlertClient.Close();
            return myList;
        }

Everything went smoothly with the report design which I have called AllAlerts..

when i tried to review the report before adding it to the WPF application I have got this Error Message...
(An Image Is Attached)

An error has occurred while processing Report 'AllAlerts':
Exception has been thrown by the target of an invocation.
------------- InnerException -------------
Could not find default endpoint element that references contract 'AlertServices.IAlertService' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element.
   
Telerik Reporting v5.0 trial version. Copyright Telerik © 2002-2011.
To remove this message, please obtain a commercial version from www.telerik.com  

Noting That I have Added The Project In The Same Solution That All It is Projects Are working soo fine..

And The Following (app.config) Configuration File is located in the ReportsLibrary Project..

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <system.serviceModel>
        <bindings>
            <wsHttpBinding>
                <binding name="wsHttpAlrEndpoint" closeTimeout="00:01:00" openTimeout="00:01:00"
                    receiveTimeout="00:10:00" sendTimeout="00:01:00" bypassProxyOnLocal="false"
                    transactionFlow="false" hostNameComparisonMode="StrongWildcard"
                    maxBufferPoolSize="524288" maxReceivedMessageSize="1024000"
                    messageEncoding="Text" textEncoding="utf-8" useDefaultWebProxy="true"
                    allowCookies="false">
                    <readerQuotas maxDepth="32" maxStringContentLength="8192" maxArrayLength="16384"
                        maxBytesPerRead="4096" maxNameTableCharCount="16384" />
                    <reliableSession ordered="true" inactivityTimeout="00:10:00"
                        enabled="false" />
                    <security mode="Message">
                        <transport clientCredentialType="Windows" proxyCredentialType="None"
                            realm="" />
                        <message clientCredentialType="UserName" negotiateServiceCredential="true"
                            algorithmSuite="Default" />
                    </security>
                </binding>
            </wsHttpBinding>
        </bindings>
        <client>
            <endpoint address="http://muaath.local/TRDWCFSurv/TRDWCFSurvServices.AlertService.svc"
                binding="wsHttpBinding" bindingConfiguration="wsHttpAlrEndpoint"
                contract="AlertServices.IAlertService" name="wsHttpAlrEndpoint">
                <identity>
                    <certificate encodedValue="AwAAAAEAAAAUAAAAxtusZ48yxeG84lIeb9af1Wg7ib8gAAAAAQAAAMwBAAAwggHIMIIBNaADAgECAhDGybGTRx4Fg0xdc1+CAK0SMAkGBSsOAwIdBQAwETEPMA0GA1UEAxMGSWRDZXJ0MCAXDTEwMDMyNDEyMDI1MloYDzQwMDgxMTI0MTIwMjUyWjARMQ8wDQYDVQQDEwZJZENlcnQwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAKl6oADCxSKQ+isZMfBzjafbEDPmE9Hn6yStKCoXjGlskH5Yqmwp7q4hrLbPmJT7iE4NEtmtJ9MCmXxJuGJuT8mgVadzAHNFnlHCG0DhdZJrg4tSe+vOo0yYVq96zMH6I8QCLyALBS15bdWcG0QpOa5mm6ZeO9hp23cYwJhgeHiPAgMBAAGjJzAlMBMGA1UdJQQMMAoGCCsGAQUFBwMBMA4GA1UdDwQHAwUAsAAAADAJBgUrDgMCHQUAA4GBAEGNLlMfqLpAx8fg35D/NVZIbE2psK2M7BgiTOd/KFgYTbiWT/I7zfPlcQ1DFQ59NtuVbODVsTCZQdmmNr6iZIEnEBsdfsdfjsdfjklsdf78sdjfkjsdklf8Y4XXNQMpIcjcTK+dpM6KcnK4ocmLhXzLbgKcR5YUWmsdxSdt" />
                </identity>
            </endpoint>
        </client>
    </system.serviceModel>
</configuration>

I hope That I will find the solution here.. *_*

By The Way I've Tried To View The Rreport from The WPF ReportViewer but I've Got Errors Adding The Viewer Control To The WPF View.. (So Lets Find a Solution for the First Problem First Then I Will Give You More Details About The Second One) *_*

My Best Regards..
danparker276
Top achievements
Rank 2
 answered on 07 Feb 2013
1 answer
75 views
I am binding my main report to an instance of an object that looks like this:

public class foo {
    public Bar Header { get;set; }
    public List<Baz> ListOfStuff { get;set;}
}

I have a sub-report that will display .ListOfStuff, but I'm at a loss on how to bind the sub-report so it has access this data from the main report.

At a high-level, this is how my main report is binding to the original source:

                var report = new TestReport();
                var ods = new Telerik.Reporting.ObjectDataSource();
                ods.DataSource = instanceOfFoo;
                report.DataSource = ods;
               
                instanceReportSource.ReportDocument = report;
                ReportViewer.ReportSource = instanceReportSource;

My sub-report doesn't have a DataSource set, so I've tried using NeedDataSource, but I'm not sure what exactly I need to do to bind to the parent data.

I'm sure I'm missing something really simple, but at this point, I'm stuck.
Michael Eaton
Top achievements
Rank 1
 answered on 07 Feb 2013
6 answers
390 views
Hello,
in a report I have a table which has a rotated layout: headers at the left and data in columns.
How can I center the table horizontally in the page?
Patrick
Steve
Telerik team
 answered on 07 Feb 2013
2 answers
222 views
I use the below custom function to convert the numeric value in my Risk column to its text equivalent.

= ReturnRiskLeveltext(Fields.RiskLevel)
public static string ReturnRiskLeveltext(int rId)
{
    using (DataEntities ctx = new DataEntities())
    {
        var RiskLevel = ctx.RiskLevels.Where(x => x.RiskLevelID == rId).SingleOrDefault();
        return RiskLevel.Level;
    }
}

However, in the footer row I wish to display an Average Risk Level
= Avg(Fields.RiskLevel)

Would be correct because it returns a 2. however, I wish to again display the Text equivalent.
= ReturnRiskLeveltext(Avg(Fields.RiskLevel))

Throws an error 'An error has occurred while processing TextBox 'textBox11': The expression contains undefined function call ReturnRiskLeveltext().'

Ideas?

Tim
Top achievements
Rank 1
 answered on 07 Feb 2013
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?