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

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.

Hi please, how can sorted a graphic up to down


Thank you

 

 

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:

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

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.

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

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:
 
I have tried all sorts of things trying to input the parameter. Including:


Am I doing this right?

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

Thanks,
Charles Hawk

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,

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.

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?