Telerik Forums
Reporting Forum
3 answers
123 views
Hey,

I have an issue generating .pdf reports with the Telerik reporting software. The problem is that I've changed the font size in the code behind of the report but this isn't shown in the pdf, which still has the old font size.

Please see the screenshots for an example. Please dont mind the Dutch. I added numbers so it's easier to see.

So I changed the font of some of the text fields like this:

 TextUserControl.Style.Font.Size = new Unit(12);

And in the .pdf file it´s still about 16 points.
What can I do to fix this?

Thanks.

PS. I'm using the Silverlight tools.
Steve
Telerik team
 answered on 16 Mar 2011
0 answers
49 views
Hi please, how can sorted a graphic up to down


Thank you
Roger
Top achievements
Rank 1
 asked on 15 Mar 2011
2 answers
100 views
I have a report where I am including 2 subreports into the detail section of the parent report.  The problem is that when running the parent report everything works up until the 2nd subreport is processed.  For some reason subreport 2 is retaining the datasource for the subreport 1. When the detail section is processed for subreport 2 if throws exception because the dataset is for the first subreport.
Here is the method:
In Sub New of the parent report I set the 2 supreports report source:
Dim subRpt1 As ReportServer.subrptContacts = New ReportServer.subrptContacts
srContacts.ReportSource = subRpt1
Dim subRpt2 As ReportServer.subrptCFR = New ReportServer.subrptCFR
srCFRs.ReportSource = subRpt2

 

 

sqlContacts.ConnectionString = strConn
sqlContacts.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
sqlContacts.SelectCommand = "get_contacts"
sqlContacts.Parameters.Add("@p_activity_id")
sqlContacts.Parameters("@p_activity_id").Value = USER2
Me.DataSource = sqlContacts

 

 

subRpt2:

sqlCFRs.ConnectionString = strConn
sqlCFRs.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
sqlCFRs.SelectCommand = "get_cfrs"
sqlCFRs.Parameters.Add("@p_activity_id")
sqlCFRs.Parameters("@p_activity_id").Value = USER2
Me.DataSource = sqlCFRs

 Why is the second subreport not using the dataset I am assigning???

Robert
Top achievements
Rank 1
 answered on 15 Mar 2011
6 answers
451 views
Hi! I am looking at the demo app where the main page is the report catalog, and each report name has a view report link, I dont see no code behind the View Report link. Is there a demo that shows the Report Catalog? I would like to display a grid with list of customers and in earch row have a ViewReport link, so when they click on the link they can see the Specific customer report based on his id.  Thanks.
John
Top achievements
Rank 1
 answered on 15 Mar 2011
0 answers
167 views
I'm getting the following erro when trying to use a report parameter as datatype datetime.

'An error occurred while processing the table 'ChangeRequestTable' Table':
Arithmetic overflow error converting expression to data type smalldatetime.

If I display the value of the ReportParamter I get a value like
13/03/2011 13:05:48

If I try to use a value in this format in my SqlDataSource I get the same Arithmetic Overflow error.
The SqlDataSource works fine if the value is in the following format:
2011-03-13 00:00:00

Can you tell me how I can get the ReportParamter to return the date in a format that the SqlDatasource will accept?

I've tried numerous things...
I've tried wrapping the paramter in the SQLDatasource query...i.e.
    CONVERT(VARCHAR(19),@StartDate,120)
I've tried converting the paramtyer expression...
    =CDATE(Paramters.ReportPeriodStartDate.Value).ToShortDateString
I've tried changing the databasedata type from smalldatetime to datetime...
I'm out of ideas...

I've opened a support ticket but no response yet :-(

I'm sure this shouldn't be a difficult thing.
Its always the small unexpected things that puts a spanner in the works :-( 

Many Thanks in advance, Des
des white
Top achievements
Rank 1
 asked on 15 Mar 2011
2 answers
102 views
I have created a report and it runs just fine if I manually put the parameter values in the query builder. I am using a SQL Data source that looks like this:
SELECT     REJECT_REPORT.VENDOR, COUNT(DISTINCT REJECT_REPORT.REJECT_ID) AS QTY_RRs, RR_CATEGORY.CATEGORY, @startDate AS STARTDATE,
                      @endDate AS ENDDATE
FROM         REJECT_REPORT LEFT OUTER JOIN
                      RR_CATEGORY ON REJECT_REPORT.CATEGORY = RR_CATEGORY.CATEGORY_ID
WHERE     (REJECT_REPORT.OCCURENCE_DATE BETWEEN @startDate AND @endDate)
GROUP BY REJECT_REPORT.VENDOR, RR_CATEGORY.CATEGORY, REJECT_REPORT.CATEGORY
 
I have tried all sorts of things trying to input the parameter. Including:
ReportViewer1.Report.ReportParameters("@endDate").Value =
frmDateInput.dtpEnd.Value.ToShortDateString

Dim report As New CategoryReport

        report.ReportParameters.Add("@startDate", Telerik.Reporting.ReportParameterType.DateTime, "9/1/2010")
        report.ReportParameters.Add("@endDate", Telerik.Reporting.ReportParameterType.DateTime, "9/30/2010")

        ReportViewer1.Report = report
Dim report As New CategoryReport

        report.ReportParameters.Add("@startDate", Telerik.Reporting.ReportParameterType.DateTime, "9/1/2010")
        report.ReportParameters.Add("@endDate", Telerik.Reporting.ReportParameterType.DateTime, "9/30/2010")

        ReportViewer1.Report = report
Dim report As New CategoryReport

        report.ReportParameters.Add("@startDate", Telerik.Reporting.ReportParameterType.DateTime, "9/1/2010")
        report.ReportParameters.Add("@endDate", Telerik.Reporting.ReportParameterType.DateTime, "9/30/2010")

        ReportViewer1.Rep

Dim report As New CategoryReport
 
        report.ReportParameters.Add("@startDate", Telerik.Reporting.ReportParameterType.DateTime, "9/1/2010")
        report.ReportParameters.Add("@endDate", Telerik.Reporting.ReportParameterType.DateTime, "9/30/2010")
 
        ReportViewer1.Report = report

Am I doing this right?

I just want to send 2 date values to my report.

Thanks,
Charles Hawk
des white
Top achievements
Rank 1
 answered on 15 Mar 2011
2 answers
388 views
Hi,

   How can I get the group record rows count and display in the footer of group? I tried =Rowcount  as expression in a textbox but didn't worked.

   Thanks,
Jeremy Greenberg
Top achievements
Rank 1
 answered on 15 Mar 2011
0 answers
163 views
Telerik report not showing correctly when it is printed in pdf format

I have an ASP page with a report viewer for showing a telerik report.The report viewer's width property  is given 100%, height property  is given 100% and Zoom mode property is given as FullPage .
The telerik report is given with legal paper kind  (8.5  x 14 inch) . The telerik report's  width  property is set to 8.5 inch.
When the page is executed the report is showing correctly, but when it given for printing in pdf format with preference given as legal size and portrait, the pdf print format output shows only part of the report with vertical and horizontal scroll bars of report viewer.
I am attaching the pdf print output of the report.
Mike Treat
Top achievements
Rank 1
 asked on 15 Mar 2011
8 answers
153 views
I have a page called Report.aspx that has the Telerik ReportViewer control on it.  During the OnLoad event of Report.aspx I would like to set the report that will be viewed.  How do I do this?
Robert Dennyson
Top achievements
Rank 2
 answered on 14 Mar 2011
1 answer
115 views
Hello,

    We are evaluating telerik report control to see whether it can support our requirement.  so far we have these two questions:
1. Can we develop a custom chart control and use it in the report, the reason why I ask is, one of our chart is quite unique, the standard chart control can't support it. 
2 Can we extend the export feature of report, I mean, we need to export the report to native word document, I know telerik can export to rtf format , but it is not good enough, as we need to generate image numbers, control the font used in word, and furthermore, once it has been export to word(doc), customer can easily to change it. if it is possible we would like to provide a custom export feature, but so far we don't know how to do it. 

Could you please let me know whether it is possible? if it is possible how to do it , where is the technical materials(document).

Thanks and regards

Johnny

Steve
Telerik team
 answered on 14 Mar 2011
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?