Telerik Forums
Reporting Forum
2 answers
248 views
I have a report that has a 3 "rows" of textboxes in the Page Header section: a report title at the top, a date range in the middle, and a bunch of column headers in the last row.

Designer Image

When I do a report preview all of the text boxes show appropriately.

Preview Image

When I view the report in the application at runtime the title and column headers show, but not the textbox in the middle. We also use Excel exports a lot and the row is missing from there also.

In app image

What do I need to do or check to get this textbox to display on reports and exports?  As far as I can tell all the properties other than name, value, and fonts are the same between the top textbox and the middle one.

(Note: Placing the date here is a customer request... moving it really isn't an option.)
Dan A
Top achievements
Rank 1
 answered on 23 Apr 2012
1 answer
119 views
Dear People,

In my ASP.NET/C# application I create a SQL String based on user input. This SQL String can contain a different table, colums etc. everytime the user sets values. Now I need to make a report containing the return data of the database. The problem is, there are no default tables and colums, so I can't predefine them in the designer. Is it possible to generate a report in code, without predefining the tables and or colums? If yes, how can i realize this?

Thank you in advance!

Kind regards,
Wesley
Petio Petkov
Telerik team
 answered on 23 Apr 2012
2 answers
258 views
Hi,

this is my situation: I've a report library referenced in a Web Application; a Silverlight application can display reports using a WCF hosted on that web application, like is explained in this page. If I use a static connection strings (in the web.config file) all works fine. 

But I need to change the connection string based on user who request reports. For example User A have to access to database A_DB, user B have to access to database B_DB and so on.
I tried to pass user through a parameter so I can get the correct connection string and pass it to the datasources. But on report's constructor I don't have parameters data (I think this object will be populated with values passed from the client later in the report rendering's pipeline).

I think that I can pass the connection string on report's contructor, but this way will work on WinForm where I can create an instance of a report, but via WCF it is possible? Can I make a custome implementation of the Telerik.Reporting.Service.IResourceService interface?

What is the best way to achieve this?

Thanks
Gabriele
Top achievements
Rank 1
 answered on 23 Apr 2012
1 answer
239 views
Hi freinds,

I am using the telerik reporting control and when i deploy my project on the server the following error comes up

Parser Error Message: Could not load file or assembly 'Telerik.ReportViewer.WebForms, Version=6.0.12.215, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The system cannot find the file specified.


I have the following pathe mention in the http handlers of web.config:
<add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=6.0.12.215, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Line 128: validate="true" />

Can some one please specify the reason for this ..Thank you in advance

akpaga akpaga
Top achievements
Rank 1
 answered on 20 Apr 2012
7 answers
167 views
When I generate docx file with some images and diagrams, open it in Word and try to update all fields in document (select all, and then F9) all images are deleted from document and I see only rectangle with text, that image is broken.

This is the file, that was generated from telerik, where you can see such behavior. 

What is the right way to solve this problem? It's nesessary to generate table of content in document in my task.
Steve
Telerik team
 answered on 20 Apr 2012
5 answers
133 views
is there any way to get a copy of the SQL queries from the Telerik reporting Demos?

more specifically thie one: http://demos.telerik.com/reporting/sales-dashboard/demo.aspx
Steve
Telerik team
 answered on 20 Apr 2012
3 answers
140 views
Hi, I have recently upgraded from a very old version of Reporting to the latest, and I am having some issues.

My reports will render the headers etc but no rows are returned.  I have a class library project defining the reports, used in a VB web site.

So I have a development environment and it was showing no rows, I ran a trace and saw it issuing FMTONLY in the queries.  I googled that for hours and found lots of references to the use of temp tables in stored procedures in your report data sources.  but my TableAdapters do not use stored procs at all. They use sql views, and have select queries in the Adapters.

So I tweaked this and that until it got to be very late at night and then finally, at some point, it started to work!  It now issues correct queries and returns rows of data.

So I deployed it to my production environment... and now it has the no-rows problem.

I don't know what finally fixed the problem.  

I suspect it was a SQL Server setting as I have confirmed that the code running in both environments is the same.
don
Top achievements
Rank 1
 answered on 19 Apr 2012
3 answers
192 views
I have a problem with Reporting since I upgraded to 2012Q1.
In the designer I see my chart correct, but in the browser it shows the chart's plotarea expanded and clipped.
Also the chart looks like it is zoomed-in
See attached pictures to see what I mean.
Can anyone tell me what to do to get the size of the chart correct?
Regards
Frank
Steve
Telerik team
 answered on 19 Apr 2012
1 answer
154 views
Hello,

I think i have this mostly figured out but im getting errors. Im getting trouble at this line: labelItem1.TextBlock.Text = procChart.Report.Parameters["Due Beyond"].Value.ToString;...My understanding of C# is limited so i dont see where im going wrong. Can you help me figure this out?

namespace Reports
{
    using System;
    using System.ComponentModel;
    using System.Drawing;
    using System.Windows.Forms;
    using Telerik.Reporting;
    using Telerik.Reporting.Drawing;


    /// <summary>
    /// Summary description for DeliveryStatus___Client.
    /// </summary>
    public partial class DeliveryStatus___Client : Telerik.Reporting.Report
    {
        public DeliveryStatus___Client()
        {
            //
            // Required for telerik Reporting designer support
            //
            InitializeComponent();}


            //
            // TODO: Add any constructor code after InitializeComponent call
            //
        private void chart1_ItemDataBinding(object sender, EventArgs e)
{
            var procChart = ((Telerik.Reporting.Processing.Chart)sender);


            Telerik.Reporting.Charting.LabelItem labelItem1 = new Telerik.Reporting.Charting.LabelItem();
            Telerik.Reporting.Charting.LabelItem labelItem2 = new Telerik.Reporting.Charting.LabelItem();
 
                labelItem1.Marker.Visible = true;
                labelItem1.Name = "LegendItem1";
                labelItem1.TextBlock.Text = procChart.Report.Parameters["Due Beyond"].Value.ToString;
                labelItem2.Marker.Visible = true;
                labelItem2.Name = "LegendItem2";
                labelItem2.TextBlock.Text = procChart.Report.Parameters["Due Monday"].Value.ToString;
                this.chart1.Legend.Items.AddRange(new Telerik.Reporting.Charting.LabelItem[] {
                labelItem1,
                labelItem2});
            this.chart1.Legend.Items.AddRange(new Telerik.Reporting.Charting.LabelItem[] {labelItem1,});
}




            






   
}
        }
}


    
Steve
Telerik team
 answered on 19 Apr 2012
4 answers
154 views
Hi,

I am using Telerik Reporting v5.3 trial version. After I built a report, I displayed it in the Silverlight ReportViewer control, however, I found no way to print my report because the print button in the ReportViewer toolbar is always gray. And neither is there a Print Preview button available. Is this because I am using the trial version?

Thanks a lot!

Xinfeng
Xinfeng
Top achievements
Rank 1
 answered on 19 Apr 2012
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?