Hi,

This is my first foray into the Telerik Reports so please excuse my lack of knowledge.  I am attempting to develop a report where the user can enter a start date and an end date.  I am connecting to a SQL 2008 Data Source and running SQL similar to this:

SELECT     COUNT(*) AS ProductCount, ProductDescription, StateCode
FROM         ProductSales
WHERE     (SaleDate > @StartDate) AND (SaleDate <= @EndDate)
GROUP BY  ProductDescription, StateCode
ORDER BY StateCode, ProductDescription 

When I step through the designer wizard I can connect to the data source without a problem, can add the sql without a problem, define the parameters without an issue, can set the parameters and view the results of the SQL and finish/create the report.

So I have a report with the above SQL contained in it.  OK...now I need to set the parameters so I go into the designer, select the report and edit the properties.  In the ReportParameters it has No ReportParameters so I go and add 2...

Name: StartDate 
AllowBlank = false
Visible = true
Type = DateTime

Name: EndDate 
AllowBlank = false
Visible = true
Type = DateTime

Then I save the file and build the project.  All goes well and when I preview the report indeed the StartDate and EndDate inputs are there.  I select the same (or any other) dates that I chose when I ran the wizard above and click the preview button.  The report is generated but no data is returned.  It is like the report totally ignores the parameters.  

If I code into the SQL the dates the report works fine.  I think I am doing something wrong with the parameters in the SQL...there they are @StartDate etc. and in the parameters editor I enter StartDate (can't enter the @StartDate as it is invalid).

In a nutshell I can see the data in the wizard or if I hard code the dates but once I get to the designer I cannot see them.  Any thoughts on what I am missing?  Your assistance is appreciated!

Thanks in advance,

Kelvin






                      

Hello All,

I am setting my textbox binding as
Me.txtDisplayName.Bindings.Add(New Telerik.Reporting.Binding("Style.Font.Size", "=IIF(Fields.sequenceID=1950, 10,8)")

But it wont work and says "txtDisplayName" set not property for fontszie.

How to achieve this function?

Hello
Since the telerik reporting standalone beta has been removed, do you have a licence model for this tool ?
can a end user use it with no licence cost ?

thanks 
sebastien

Hi friends,

I want to mange the visibility of some element(ts) using the parameter value True/False" being passed.



Thanks,
-Aarsh
here are my reports: http://sdrv.ms/T95zWi

Hi everybody,

i need to make an application for reporting in telerik. I need to pass the dataset using SQL Server query statement.
Is there any example to set the dataset manually on c# and also set the design report manually on c# (like visibilty or the value).

Can anyone help me please?

Thanks,
Dhenny

Hi,

How can I load reports to a reportbook by path name programatically?

How do I add a support page to end of the report.  Heard something about using the report book, like to see an example on how to do this.  As much detail as possible, thanks in advance.

Hi. I have built a DLL that generates  a PDF. The problem is that the error message "PDF rendering format is not available" appears, unless the Telerik dlls are referenced in the calling application.

How do I need to proceed?

Here is the code in the Calling Application:

This is the code that is failing in the DLL:

Of course, it fails on the "Render" call.

I have a report where I display the data in 2 columns, side by side.
In the group section I said to do a pagebreak when the group item changes.
However, the instead of going to the next page, it goes to the next column.

Therefore I tried to give a page break before and after the group. But it didn't help either.

Any idea on how to fix this bug?

Thanks.

Hi

Is that in any way possible to set the detail section to a specific height and keep it even though there is not enough data in the child list to expand it? 
I have a fix layout, where the detail section has to have a background company logo that has to be shown on all pages.

As of now, when the list in the detail section expands to a second page, and takes up only one row, the rest of the detail section on that page is blank, and no logo is shown.

Is there a way to overcome this behaviour? (Please don't say it's design behavior ;) )

Thanks.