Hi

What is the best way to view Telerik reports inside a silverlight application, also i wish to pass parameters for the report from the silverlight gui ( dates etc. )

Regards,

Hello, this going to be a very specific scenario that I can't find any documentation on.

I created a Subreport that builds a chart that accepts a parameter  ( TerritoryId ),
when I run that report by itself it works fine. (see subreport.png )

When I create a Master report and pass in the parameter, the parameter seems to pass in ok. But the chart,
says Specified cast is not valid. (see master.png)
You can see from the msater.png that the parameter is being passed to the text box on the subreport, but not the chart.



The code for the  chart NeedDataSource on the subreport:

The attached images are the subreport by itself, and the subreport inside a master report, passing in the parameter.

This just uses the AdventuresWork DB
The following  is the StoredProc used for the dataset.


Here's how the designer code for the Master:

And the desinger code for the SubReport:

Basically the subreport has a textbox that echos out the passed in parameter and the chart.
running it alone the textbox populates and the chart populates.

Running the MasterReport with the Subreport , the textbox populates but the chart causes the cast error.

Dear Telerik,

Can you please help me, how do I do a group footer textbox which value based on group header textbox value.

For example. if the headerGroup textbox value is an "A" then the footerGroup textbox value should be the sum of "A".

Thank you for you Help
Molivia

Hello,

My team is very excited to move into Telerik Reports, however we have first been trialling the software and came accross an issue that we are unable to solve.  Unfortunately we're on a tight deadline, and would sincerely appreciate any prompt responses.

[See Sample Project, Code & screenshot: http://www.addeight.net/telerik-issue.zip]

We are having trouble binding a sub report based on repeating datafrom a parent (master) report. What we need to be able to do is have a masterreport that repeats SolutionIDs (the primary key), and sub reports (which holdall the totals/information based off a single SolutionID). I cannot useFilters, as the data being returned in the sub reports is complicated.

We have seen these articles as references, and have tried (to our knowledge)everything in them:

http://www.telerik.com/community/forums/reporting/telerik-reporting/i-need-to-know-when-to-pass-parameters-to-a-subreport.aspx

http://www.telerik.com/documents/TelerikReporting-LearningGuide.pdf

http://www.telerik.com/community/forums/reporting/telerik-reporting/how-do-i-pass-parameters-to-subreport-sproc.aspx

http://www.telerik.com/support/kb/reporting/designing-reports/using-data-source-with-parameters-in-telerik-reporting.aspx

http://www.telerik.com/community/forums/reporting/telerik-reporting/how-to-set-datasource-of-a-sub-report.aspx

http://www.telerik.com/community/forums/reporting/telerik-reporting/set-subreport-datasource-programmatically.aspx#421286

http://www.telerik.com/ClientsFiles/product.videos/28/

Asyou can see by the screenshot attached (Screenshot.png in root of zip file), we are close. We have used the following code 

Public Sub New()

InitializeComponent()

'bind the master's datasource

Dim cmdMaster As New SqlCommand("SELECT * FROM Solutions WHERE CompanyID=@CompanyID", cn)

cmdMaster.Parameters.AddWithValue("@CompanyID", 10)

Dim daMaster As New SqlDataAdapter(cmdMaster)

Dim dt As New DataTable("Solutions")

daMaster.Fill(dt)

Me.DataSource = dt

Me.DataMember = "Solutions"

End Sub

Private Sub SolutionDetails_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles SolutionDetails.NeedDataSource

Dim item As Telerik.Reporting.Processing.ReportItemBase = TryCast(sender, Telerik.Reporting.Processing.ReportItemBase)

Dim dataRow As DataRowView = DirectCast(item.DataItem, DataRowView)

Dim adapter As New SqlDataAdapter("SELECT * FROM Solutions WHERE ID=@SolutionID", cn)

adapter.SelectCommand.Parameters.AddWithValue("@SolutionID", dataRow("ID"))

SolutionDetails.ReportSource.DataSource = adapter

Test_SolutionDetail1.Debug = dataRow("ID")

'Me.DataSource = adapter

End Sub

 

Again, we need to have the sub report on each SolutionID, and we need to be able toquery data based off that SolutionID in the sub report.

We sincerely appreciate any help in advance, and cannot stress the tight deadline we are working with enough.  If you can help, we are more than happy to compensate you for your time!

Cheers!

when designing in my  own report class library,  sample.dll  so it can be used in my webapp,

the Integer Parameter  needs to be (Int64) or else I would get cast error.


When the setting is Int64, i can click Preview and report comes up via the class library.  If it's set to int,

	An error has occured while processing Chart 'chart1': Specified cast is not valid.

But when I add this reference to my webapp to use the ReportViewer,
it doesn't like Int64 and gives the cast error, I debug in VS and see it's this line, so  I change it to  int, it works.




I don't think this is what supposed to happen?
They are both .Net 3.5, the class and webapp are even in the same solution.
I'm using  Telerik Reporting Q3 2009  v. 3.2.9.1211  Trial

I have datacolumn(LeadDate)  that is returned from SQL,
if the format is DateTime,  i get the following error:

An error has occured while processing Report '':
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

When applying the column to the xaxis of a chart.

Example of data with type of datetime from SQL:

When the column is CONVERT(VARCHAR(8),LeadDate,1) as LeadDate , like below, there's no error.
But the Column is no longer DateFormat  and I'm not able to format the LeadDate column on the chart.


I want to return the column as DateTime format so I can format the data on the xaxis using
using this technique: http://www.telerik.com/community/forums/reporting/telerik-reporting/how-to-format-x-axis-value-on-chart.aspx

Telerik team,
I programmatically generate a report page, in which there is 3 charts and 2 tables.
When browser render this page, the first page only display the header section, the detail and footer section always go to the second page.  I would like  the the detail section to be displayed inside the first page too.
I searched the forum and found the problem may be solved by the article:
http://www.telerik.com/support/kb/reporting/general/problem-telerik-reporting-renders-blank-pages.aspx

I try all the solutions inside the article, except the one that remove the header section, none can solve my problem.

My problem is :
    can I split the report page in multiple page programmatically so that each page will have charts or spreadsheets be displayed

or does telerik report provide multiple detail sections to solve my page render problem.

if so, can you provide some example ?

Thanks in advance!

Qixiong

Hi there,

I am currently learning to use Telerik reporting, and am stuck on something that should be simple, but I just can't figure it out !!

I have added a table to the designer view of my report.

In the "MyReport_NeedDataSource" method I simply want to add data to this table.

I don't want to bind the table to an SQL data source, I simply want to add the values programatically, row by row.

The table is already five columns wide, so I would like something like:

        table1.rows.add(new tablerow("value1", "value2", "value3", "value4", "value5");

        or even something like:

        table1.rows[0].cells[0] = "value1";
        table1.rows[0].cells[1] = "value2";
        table1.rows[0].cells[2] = "value3";
        table1.rows[0].cells[3] = "value4";
        table1.rows[0].cells[4] = "value5";

I'm sure there must be a way to do something like this. Please advise when able.

Kind regards, Ben.

Hi all. We're developing a WPF project with Telerik Rad Controls for WPF and Telerik Open Access for our ORM. Now, we're moving to the reporting phase, and we want to use Telerik Reporting as well, but there are a couple of questions that I need to ask before we can decide to use it over Reporting Services:

1. Does your ReportViewer support both local and remote processing modes? We need to be able to handle reports both locally and from a reporting server.
2. Do you have an auto refresh feature for the report, like th one ein Reporting Services?

Thanks a lot.