I am using dynamic query and pivot in MS SQL stored procedure. when i run this stored procedure it returns me result set. In Reporting, when configure the data source it returns me result set on the Preview Data Source Results BUT nothing comes in Data Explorer window.
On the other side if i use SP without Pivot and Dynamic query it works fine.
Following is the SQL SP.
 
ALTER PROC dbo.GetSeminarReportHeaders
    @DiagnosticFormCode VARCHAR(7)
AS 
    BEGIN 

        SELECT DISTINCT
                DiagnosticFormCode ,
                'Section ' + CONVERT(VARCHAR(50), ds.SectionNumber) + ' - '
                + sst.Name AS Section ,
                QuestionNumber ,
                CorrectAnswer
        INTO    #header
        FROM    dbo.DiagnosticQuestions dq
                INNER JOIN dbo.DiagnosticSections ds ON ds.ID = dq.DiagnosticSectionId
                INNER JOIN dbo.SectionSubjectTypes sst ON sst.ID = ds.SectionTypeId
                INNER JOIN dbo.DiagnosticForms df ON df.ID = ds.DiagnosticFormId
         WHERE   DiagnosticFormCode = @DiagnosticFormCode 

        DECLARE @columns NVARCHAR(MAX) ,
            @query NVARCHAR(MAX)

        SELECT  @columns = COALESCE(@Columns + ',', '')
                + QUOTENAME(questionnumber)
        FROM    ( SELECT DISTINCT
                            QuestionNumber
                  FROM      #header
                ) c
        ORDER BY c.QuestionNumber

        SET @columns = REPLACE(@columns, ',[1]', '[1]')

        SET @query = N'Select distinct DiagnosticFormCode,Section,' + @columns
            + '   
FROM   
(SELECT distinct
DiagnosticFormCode,
Section,
QuestionNumber,
CorrectAnswer
FROM #header AS h
) p
PIVOT
(
max([CorrectAnswer] )
FOR QuestionNumber IN
( ' + @columns + ' )
) AS pvt '

        EXEC sp_executesql @query
--EXEC(@query)
        DROP TABLE #header
    END

I created a simple report using all defaults other than setting margins to .25
In the designer everything looks good, in preview it is as if I set the page size to postcard or something. When I print it is the same as the preview. I saw a forum post about Win7 Text size and confirmed that mine is set to, smaller - 100%
I attached screen shots of the designer and the preview

I read the help and also some threads here on the forum, and even then, you can run a report type trdx, no user data source SQL Server and such.
Now my question is, fom customize a report data from a SQL Server data source and call the application through some filters.

In short: I have not seen anywhere here on the site of how to call a report that has its data from a data source, the opening of the report doing some filter data and also now enjoying the DataSource application to why my application is WPF Desktop then the DataSource changes from customer to customer.
With this piece of code could run a report from the folder is located.

XAML
                xmlns:tr="http://schemas.telerik.com/wpf" x:Class="RadControlsWpfApp1.MainWindow"
                Title="MainWindow" Height="350" Width="525">
    <Grid>
        <tr:ReportViewer x:Name="reportViewer1"/>
    </Grid>

C#
            var report = new UriReportSource();
            report.Uri = System.IO.Path.Combine(Environment.CurrentDirectory, "Barcodes Report.trdx");
            //report.Parameters.Add(new Telerik.Reporting.Parameter("OrderNumber", "SO43659"));
            this.reportViewer1.ReportSource = report;

And now how to filter?

is possible for a demo or example a video explaining about, we urgently need our system to pass the work with telerik report.
I thank you.

graciously
André

Is there a sample anyplace that I can see where the Telerik Reporting control is being used in a Kendo UI application?

I'm current creating a test report follow the tutorial http://www.youtube.com/watch?v=t-iA05KpDFM .
After I put report partial view to in index.cshtml, it generated report, but the controls of report become very big.
I'm new in MS MVC. Anyone has any solutions?

I have a report set up with columns representing dates. I want a conditional formating on these column to "grey out" holidays or dates that we are not opened. Those dates are in a SQL table. I have created a second DataSource that successfully gets a list of the closed dates, but I have no clue how (or if it's possible) to access that list of dates within the conditional formating expression.

I do know that I could make a custom function to return that list of dates, but I am using the standalone design and would like to keep it that way. We use express versions of Visual Studio and even if getting a full version is a possibility, I am curently evaluating this reporting service in terms of features vs price. Requiring a full version of Visual Studio greatly affects this ratio.

I am currently testing out Telerik Reporting. I have a trial version of Visual Studio to test the integrated designer but I would like to do without it using with standalone report designer. I have managed to do the operations I wanted after learning I had to cast my report parameter and the AddDays parameter :

= CDate(Parameters.date.Value).AddDays(CDbl(6))

My next requirement was to convert a DateTime into a 1 letter day of week. Simple formatting would not allow me to do this. The further I could go was an abbreviation of the day of the week (thu. for example). What I needed was "T", "M", etc.

AddDays looked very familiar... so I tried adding .DayOfWeek. Result:

= Substr(CStr(CDate(Parameters.date.Value).AddDays(CDbl(6)).DayOfWeek), 0, 1)

This worked, almost. The result is indeed what I expected, with the exception that it does not globalize to French like a simple format would.

How can I get the 1st letter of the DayOfWeek in French without using Visual Studio integrated designer?

Hello,

the roadmap for Telerik Reporting Q2 2013 includes a new HTML5/Ajax based report viewer.
Will it support animations and mouse over effects like the Kendo UI DataViz charts?

Greetings,
Sebastian

Hai Can u send me a sample Example  for Report viewer in MVC 4