Telerik Forums
Reporting Forum
1 answer
160 views
Hello,

I have  a problem with chart series label format. I have set DefaulLabel Value to #Y{N2} and in designer mode it looks OK, but when i run the preview, values have more than 2 decimal numbers and my chart layout is messed up. I have attached images for better understanding of the issue.

Peter
Telerik team
 answered on 16 Mar 2011
2 answers
142 views
I'm creating a VS 2010 Silverlight 4 web application and plan to compile to 64bit for use on our IIS7 server (64bit).  We have the the Q3 2010 release of Telerik Reporting, does this support Silverlight 4 and 64bit compile?

Thanks, Rob.
Rob Ainscough
Top achievements
Rank 1
 answered on 16 Mar 2011
2 answers
206 views
Ive created a new report from a sql statement.

the statement runs in the wizard & all looks good, but when i go to the preview tab, i get the swirly 'generating report" but then i get the message
"Input string was not in a correct format"

I'm unsure where I should be looking for this error??

This is a new project where im following the tutorial (except for the SQL statement)

with thanks
michael
Peter
Telerik team
 answered on 16 Mar 2011
3 answers
140 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
55 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
113 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
470 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
181 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
110 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
414 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
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
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?