Telerik Forums
Reporting Forum
7 answers
127 views
Hi,
I am using telerik trial version an try to create a test report. I spend 3 days to do this but did not success.

My scenario is like:
1) I have a WCF Project called "ReportWCF" which is use to connect mysql database and collect data and return in generic list method say "lstGetOrder".

2) I have another project "ReportLibrary" which contain "OrderReport1.cs" and "OrderList.cs" which is use to hold data returned from WCF call back.

Till now everything is fine.
But before my WCF execution is finished my report viewer is appeared in my Silverlight application. I think but not sure it is for Async call because if I put a break point on the "OrderList.cs" after a while the break point will hit but the blank report already rendered in Silverlight?

I use objectdatasource hear.

**************************************************************

How can I do this to overcome this problem.
I was already tried the "ReportServiceClient" implementation in Silverlight page but there is an error called:
Could not find default endpoint element that references contract 'Telerik.Reporting.Service.SilverlightClient.IReportService' 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.

Use like Report.xaml.cs:
ReportServiceClient IReportServiceClientFactory.Create(System.Uri remoteAddress)
        {
            var binding = new BasicHttpBinding() // or BasicHttpBinding(BasicHttpSecurityMode.Transport) overload if SSL is used
            {
                MaxBufferSize = int.MaxValue,
                MaxReceivedMessageSize = int.MaxValue,
                ReceiveTimeout = new TimeSpan(0, 15, 0),
                SendTimeout = new TimeSpan(0, 15, 0)
            };

            var endpointAddress = new EndpointAddress(remoteAddress);

            return new ReportServiceClient(binding, endpointAddress);
        }

private void LayoutRoot_Loaded(object sender, RoutedEventArgs e)
{
          ReportServiceClient client = new ReportServiceClient();
}

In this case how to fix the error and how to call WCF method?
and how can I call my wcf method with this "client" proxy object. My WCF method is CreateReport();
I want to use like client.CreateReportCompleted += .........  ;  client.CreateReportAsync();

Can you please send me a sample application to do get data from WCF call back and populate report?

I have see all the sample but unable to understand.
like : http://www.telerik.com/help/reporting/silverlight-report-viewer.html
http://www.telerik.com/help/reporting/silverlight-wcf-service-overview.html
etc.
Please send me solution asap.
Thanks in advance
Chandan
Peter
Telerik team
 answered on 08 May 2013
4 answers
1.1K+ views
Where are Connection Strings stored after adding in Report Designer?

I have searched my local drive after adding a new entry and can't seem to find the config file anywhere.

Thanks
-Justin
Consinco S/A
Top achievements
Rank 1
 answered on 07 May 2013
3 answers
196 views
Hello telerik

According to your examples, you know the location of elements, their values and element count.
But when I create report, I don't know how many columns will be in my report. Usually 20-40 columns.
A piece of code: (I write by hand, to don't copy the entire code)

//by default standard portrait A4
private void BuilderReport(Telerik.Reporting.IReportDocument report)
{
    report.Width = new Unit(Columns.Count * 1.2, UnitType.Inch); // ≈ 20-25 Inch
 
    // ...
     
    foreach (var column in Columns)
    {
        var dataTextBox = new TextBox { /* Size, Location etc */ };
        report.Items["detail"].Items.Add(dataTextBox);
 
        // ...
        var footerTextBox = new TextBox { /* Size, Location etc */ };
        footerTextBox.Value = string.Format(@"=PageExec(""{0}"", Count(Fields.{0}))", column.Name);
 
        // pageFooter is Telerik.Reporting.PageFooterSection
        report.Items["pageFooter"].Items.Add(footerTextBox);
    }
}


Only each first page contains correctly aggregate values, other pages contsins 0
If replace PageFooterSection to Telerik.Reporting.GroupFooterSection all aggregate items is equals 0

How correctly calculate aggregates, when have too many columns and they are transferred on other pages?

Thanks
Stef
Telerik team
 answered on 07 May 2013
1 answer
59 views
Hi
When I publish the report page, It could't show icon in toolbar,but it work fine in my development environment.
Just like attachment.

<system.webServer>
<handlers>
      <add name="Telerik.ReportViewer.axd_*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=6.1.12.611, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" path="Telerik.ReportViewer.axd" verb="*"  preCondition="integratedMode,runtimeVersionv2.0"/>
 
</handlers>
</system.webServer>
 
<system.web>
<httpHandlers>
 
    <add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=6.1.12.611, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" validate="false"/>
 
</httpHandlers>
</system.web>

 
Stef
Telerik team
 answered on 07 May 2013
1 answer
144 views
I am using Telerik Reporting Q1 2013.  I need to create a crosstable that shows the colums and rows in a specific order.  I cannot use the ascending or descending format.  I am using pre and post data.  Is it possible to specify the order of the row and column data.  I have attached an image of the table that I want to create.  As you can see, I can not order them alphabetically.

Thanks,
Jennifer
IvanY
Telerik team
 answered on 06 May 2013
0 answers
94 views
Hello Telerik,

First of all I am using Q2 2012 version of reporting but I am sure this affects the Q2 2012 SP1 as well. My report is made of a crosstab with a first column which has the following properties enabled : Cangrow, Multiline, TextWrap.
Now the behavior doesn't have any problem when I preview (pic1) the report but when I do the Html rendering (pic2) (which is used in the asp reportviewer it seems) it won't grow normally, some lines will grow a little, others won't grow at all, hiding the text beneath.
So from what I understand, Multiline and Textwrap works well, but Cangrow don't. Also you can see here that the relative size of the text is not the same, being taller in the html rendering, but I can live with that.

Edit : The behavior described above won't apply when the asp ReportViewer is wrapped in an ASP web page, so problem solved.

Thanks in advance for any help,
Cheers.
Jean-Francois
Top achievements
Rank 1
 asked on 06 May 2013
2 answers
210 views
Hello,

I'm working on a Windows Forms Application where I want to load Reports into a Reportviewer after a click on a Button.
This is the Event that gets triggered by pressing on the button in the Code behind of the Windows Form:

private void button1_Click(object sender, EventArgs e)
{
 
    Telerik.Reporting.InstanceReportSource reportSource = new
    Telerik.Reporting.InstanceReportSource();
    reportSource.ReportDocument = new Reportlibrary.Report1();
 
    reportSource.Parameters.Add(new Telerik.Reporting.Parameter("OrderNumber","123456789"));
 
    reportViewer1.ReportSource = reportSource;
    reportViewer1.RefreshReport();
 
}

The problem now is that I have no Idea how I can access / get the parameter I added before Refreshing the Reportviewer.
The Report already has set a Datasource. I don't know if this matters.
This is what I have right now. I've tried everything and I'm just not getting further.

public Report1()
        {
            InitializeComponent();
 
            Position[] all = new Position[]{
 
               new Position("Test", "Test","test"),
 
            };
 
            this.DataSource = all;
 
             MessageBox.Show("Number: " +
             this.Report.ReportParameters["OrderNumber"].Value.ToString());
                 
        }

Is there any way to get this parameter straight after InitializeComponent(); ?
Do I need to add another Event to the report to access it? If yes which on is the best way to do this?

Any help very apreciated.
Thank you
Peter
Telerik team
 answered on 06 May 2013
4 answers
110 views
Environment : 
- Mac OSX (Lion and Mountain Lion),
- Safari (Version 6.0 (8536.25)) and Firefox (15.0 Beta 3)  
- Silverlight Ad-On 5.1.10411.0 

no data when exporting

Please help,

Thanks,
Wit
jean-Marc
Top achievements
Rank 1
 answered on 06 May 2013
1 answer
75 views
Hi, I use Telerik Reporting with Silverlight

All is OK, but when i put data into grid (from DataSource) part of the text is cut off on the preview page. And then if I convert it into 
Word or Pdf situation is the same. But if I convert it into Excel then everything is Ok.

Thank you very much for your prompt response!!!
Stef
Telerik team
 answered on 03 May 2013
1 answer
542 views
We're using Version 7.0.13.220 of the Report Designer to allow users to create reports and upload them into our web application.  The TRDX files are stored in the database and at runtime are deserialized with ReportXmlSerializer.  This works well but is rather cumbersome when subreports are used.

The Report Designer provides two options for defining the source of a subreport: 1) Url or File (this embeds a reference to the subreport file and is not an option for us since we store the report definition in a single data record) or 2) XML markup.  

Currently we are requiring the user to open the subreport in notepad, copy the content, select XML markup as the subreport source, and paste the XML into the dialog. 

Are there any plans to extend the Report Designer to allow selecting the subreport file and pulling the XML to prevent the "Open in notepad" approach?  

If not is there any other way to make it easier for the end user?  I'm currently under pressure to extend our report upload process to reach into the TRDX, iterate the subreports, prompt for upload of those files and then set the subreport source to the uploaded XML.  I'd rather not build in this dependency if the Report Designer can to it instead.

On a separate note, it looks like there is a minor defect in the tool tips for vertical spacing controls in the Layout section of the designer.  They all say "horizontal spacing" rather then "vertical spacing".

Thanks
Hrisi
Telerik team
 answered on 03 May 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?