Questions on Reporting Forum

1 answer

84 views

can not see T report in Visual Stodio installed Template

down load the trial version Q2 2009,

PC configuration:

Visual studio web express 2008, net 3.

General Discussions

answered on 07 Aug 2009

3 answers

159 views

Parameter question

Hello

I need help.

I have a report that displays Column "FullName" And Column "Antal" (quantity).

This is my query for that.

SELECT CONCAT(u.FirstName, ' ', u.LastName) AS FullName, COUNT(*) AS Antal

FROM Bookings b

INNER JOIN Users u ON u.Id = b.BookedById

INNER JOIN CompanyUsers cu ON (cu.Id = u.Id)

WHERE cu.CompanyId = 2

GROUP BY u.Id

ORDER BY Antal DESC;

I have added two parameter values from the ReportParameter-collection of the report, one for Year and one for Month. These values displays in two dropdowns. I have also added a filter. =Fields.Year = =Parameters.Year AND =Fields.Month = =Parameters.Month

This is my query for that.

SELECT DISTINCT MONTH(BookedDate) AS Month, YEAR(BookedDate) AS Year

FROM Bookings b

INNER JOIN CompanyUsers cu ON cu.Id = b.BookedById

ORDER BY Year DESC, Month DESC;

The textboxes that displays FullName and Antal is empty when I choose a value from the "dropdowns". But if I remove the filter FullName an Antal displays with the overall quantity.

How can I get my Report to interact with the parameters value in my dropdowns. When I choose a month from the dropdown I want the quantity for exactly that month. Not the overall result.

Excuse my English

Thanks

/Emil

General Discussions

answered on 07 Aug 2009

5 answers

149 views

How do I format a TextBox where I have put in a sum funktion?

Hi
I am trying to make a report where I have a colum where I am using the sum- function, but I have to format the result of this colum to be a price in $. It is not working to use the normal Format property and the TextBox - object. Then my idear was to use the System.String.Format- funktion but this don`t work.

Pls. help me out.

    
            TextBox o = new RapportDataFelt("sum(" + kolonne.KolonneNavn + ")}", kolonne.HeaderStyle).Textbox;  
        
            o.Style.TextAlign = HorizontalAlign.Right;  
        
            o.Style.Font.Bold = true;  
        
            o.Format = "{0:C2}";

Sincerely,
Janus S. Andersen
Denmark

General Discussions

answered on 06 Aug 2009

2 answers

361 views

Report Viewer Height

Hi,

I'm trying to make the report viewer height 100%. I tried following the example in best practices. I can make it work with this doctype:

    
            <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

I tried to use the doctype from the demo:

    
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

Here's my ASPX:

    
            <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="EventMetrics.aspx.cs" Inherits="GateSureWeb.Reporting.EventMetrics" %> 
        
            <%@ Register assembly="Telerik.ReportViewer.WebForms, Version=3.1.9.701, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %> 
        
            <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > 
        
            <html xmlns="http://www.w3.org/1999/xhtml" > 
        
            <head runat="server"> 
        
                <title>Event Metrics</title> 
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server" style="height: 100%;"> 
        
                <div id="content" style="height: 100%;"> 
        
                    <telerik:ReportViewer ID="ReportViewer1" runat="server" Height="100%" Width="100%" 
        
                        Report="EnveraReports.EventMetrics, EnveraReports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"> 
        
                    </telerik:ReportViewer> 
        
                </div> 
        
                </form> 
        
            </body> 
        
            </html>

Here's my CSS but it didn't work:

    
            body 
        
            { 
        
                font-family: Arial, Helvetica, Sans-Serif; 
        
                font-size:10pt; 
        
                height:100%; 
        
            } 
        
            form#form1, div#content 
        
            { 
        
                height: 100%; 
        
                width: 100%; 
        
            }

I had to style the report viewer right in the ASPX.

What am I doing wrong?

Thanks,
Darren

General Discussions

answered on 06 Aug 2009

3 answers

194 views

Generate Telerik Report from DOC or RTF?

Are there any plans to create a tool that can generate a Telerik Report from a Word document or RTF file? We have a need to be able to get reports from clients that can be presented in Word or RTF format, insert data into the reports and present it to the user as a PDF document (or other supported formats). I wasn't sure if this was even on the radar to do.

It'd be so much easier if we could just take their reports, generate a Telerik Report from it and put it into the application.

Thoughts?

General Discussions

answered on 06 Aug 2009

7 answers

192 views

report rendering blank page

Hi,

I have a report with 6 columns, nothing fancy, and bound with a dataset having about 22000 rows, it takes forever to generate and when it is "done", it just show a blank page.

Any idea? I read you knowledge base and I don't think I could put them into seperate subreports.

Thanks,

Scott

General Discussions

answered on 05 Aug 2009

2 answers

132 views

ReportViewer: add method to Refrish report

Hi
I am trying to make a server- side methode to refresh- report button on the ReportViewver in a webpage.

I am using IE and use the newst version og Telerik Report.

I have fund http://www.telerik.com/help/reporting/winforms-report-viewer-serverapi.html, but can`t find a way to put in a method server- side that is called when the button is pushed.

Pls. help me there.

Best Regaards from
Janus S. Andersen
Denmark

General Discussions

answered on 05 Aug 2009

2 answers

306 views

Empty first page, report starts on page 2

Hi,

I created a report with only a pageheader, size 0cm and one detail section with several subreports in panels. The sizing seems to fit, at least there are no warning exclamation marks regarding page size, etc.

Nevertheless the report starts on page two.

When I resize the page header and put some text in, it appears on page one, with the detail section still on page two.

I guess I am missing some obvious setting, that currently I am unable to find,

Thanks for helping out

Andreas

General Discussions

answered on 04 Aug 2009

1 answer

164 views

Complex Report - Is this possible?

I have a report to produce that is an assembly of different sections all merged together with continuous page numbering and a table of contents. Haven't been able to use ANY reporting package to be able to create this report, but wonder if I could make a set of reports and use the Report Book to assemble them into one unit.

Here's what I need to do. Is this possible, or are pieces of this possible?

Title Page (static text)
Blank Page
Table of Contents (approx 3 pages - linked to section headings)
Intro Section (static text 2 pages)
Network Section (dynamic data, in 3 column format, xx pages, section headings linked in TOC)
Provider Section (dynamic data, in 3 column format, xx pages, section headings linked in TOC)
Long Term Care Section (dynamic data, in 2 column format, xx pages, section headings linked in TOC)
Pharmacy Section (static text 1 page)

I need the page numbers to start at page 1 and run through all sections, without gaps.

General Discussions

answered on 04 Aug 2009

1 answer

100 views

Textbox formatting goes wrong on print.

I've just installed the latest release [Telerik_Reporting_2009_2_701_dev].

The textboxes in the header and footer seem to have a bug. In design view the formatting is fine but when previewed or generated in the application it wraps or overlaps lines.

Here are two screen shots:

Design view

Preview

It also effects the report title in the header but the body of the reports seem uneffected.

Thanks,

Gary

General Discussions

answered on 04 Aug 2009

	TextBox o = new RapportDataFelt("sum(" + kolonne.KolonneNavn + ")}", kolonne.HeaderStyle).Textbox;
	o.Style.TextAlign = HorizontalAlign.Right;
	o.Style.Font.Bold = true;
	o.Format = "{0:C2}";