Questions on Reporting Forum

4 answers

337 views

I would like to dump the raw data that is used to create a report to Excel.
My intent is to be able to dump the raw data that feeds a report, be it a top level report, or a drill - through report (a report called by another report). How can I retrieve the raw data that feeds the currently viewed report?

Telerik Reporting 2011 Q1 5.0.11.603
VS 2008 using WebForms
All reports datasources are SQLDatasource Stored Procedures with the report parameters fed from the application to the report object

The following is the method I am currently using for the top level report only.

Protected Sub btnDumpToExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDumpToExcel.Click

Dim RunRpt As String = Me.ReportViewer1.Report.Reports(0).Name

Dim tb As New DataTable(RunRpt)

Dim dataConn As New SqlConnection

Select Case RunRpt

Case "evRptBehaviorChange"

Dim report1 As

Snap_EvalReports.evRptBehaviorChange = ReportViewer1.Report.Reports(0)

With report1

Dim xSQLDatasource As Telerik.Reporting.SqlDataSource = .DataSource

Dim SQLConnectionString As String = System.Configuration.ConfigurationManager.ConnectionStrings(xSQLDatasource.ConnectionString).ToString

Dim xSelectCommand As String = xSQLDatasource.SelectCommand

dataConn.ConnectionString = SQLConnectionString

dataConn.Open()

Dim sdc As SqlCommand = New SqlCommand(xSelectCommand, dataConn)

sdc.CommandTimeout = LengthOfTimeOut

sdc.CommandType = CommandType.StoredProcedure 'xSQLDatasource.SelectCommandType

For Each p As Telerik.Reporting.SqlDataSourceParameter In xSQLDatasource.Parameters

Dim xParam As SqlParameter = New SqlParameter(p.Name, p.GetType)

sdc.Parameters.Add(xParam)

Next

' ALTER PROCEDURE [dbo].[StoredProcedure1]

'(@FiscalYearID int=3)

sdc.Parameters.Item("@FiscalYearID").Value = CType(Session("spaFiscalYear"), Integer)

Dim sda As SqlDataAdapter

sda = New SqlDataAdapter(sdc)

sda.Fill(tb)

dataConn.Close()

dataConn = Nothing

XLSExport(tb, RunRpt)

End With

End Select

End Sub

Thank you in advance.

Patti

General Discussions

answered on 08 Jul 2011

1 answer

115 views

Telerik reporting parameters selection

Hi:

i have designed the telerik report using telerik reporting, i am passing 4 parameters to the report.
when i click on preview it is asking for parameters, when i entered first parameter and moved to next parameter, the information i entered in the first parameter is erasing.
The report is getting refreshed.

Any help is appreciated.

Thanks
Venu

General Discussions

answered on 08 Jul 2011

2 answers

110 views

Report Viewer

I want to hidden the same under picture, but I don't know current version supported. Can you help me ?

General Discussions

answered on 08 Jul 2011

4 answers

146 views

Export to PDf Issue:- there is no empty series

Hi,

I am using telerik Silevrlight Reportviewer. I am able to see pie chart with values in Report Viewer but when i try to Export to PDF , instead of pie chart I am getting "There is no empty series". Any help is highly appreciated.

Regards,
Shweta

General Discussions

answered on 08 Jul 2011

3 answers

462 views

Export only data instead of report while exporting to excel in report viewer

Hi

I am using ReportViewer to display the reports and also to export the reports in the required format. Here i want a change in the existing system such that when user tries to export to excel, instead of displaying the report in the excel, we want to display the underlying data in the excel sheet. Please let me know whether the existing system support this functionality?

Thanks in advance
Ravindra

General Discussions

answered on 07 Jul 2011

1 answer

52 views

Silverlight view fails on {word} in text

I have 2 different reports that fail on the Silverlight viewer when I have '{myword}' in the text I'm displaying from a field. The asp.net version shows the correct text.

I get an error:
"The type 'SUNRISE' was not found. [Line: 1 Position: 7039]"

SUNRISE is the text in {SUNRISE} it's at the start of the text if that makes a difference. I'm using version 5.0.11.316

General Discussions

answered on 07 Jul 2011

4 answers

196 views

Incorrect information displayed on chart (X-Axis which contains dates)

Hi
I'm having this issue where the information I have in my SQL database is not being reflected on the chart.

My SQL query returns this data below:

raisedBy counter createdon
Risha Wadhwani   13 2010.06.14
Risha Wadhwani   19 2010.06.15
Tufail Khan 4 2010.06.15
Risha Wadhwani   13 2010.06.16

Also see screenshot 'sql.png'

This is the code that I am using to generate the Chart :

private void chart1_NeedDataSource(object sender, EventArgs e)

{

var dataset = new DataSet();

var adapter = new SqlDataAdapter();

var conn =

new SqlConnection("Initial Catalog=****;Data Source=****;User Id=****;Password=****;");

var cmd = new SqlCommand

{

Connection = conn,

CommandType = CommandType.Text,

CommandText =

@"SELECT raisedBy,

COUNT(id) as counter,

createdon FROM

(

SELECT

da.name as raisedBy,

defects.id,

convert(VARCHAR, defects.created_on, 102)

AS

createdon

FROM

defects

LEFT JOIN

[user] da

ON

(defects.raised_by = da.id)

WHERE

defects.id IN(488,490,491,492,493,494,495,496,497,498,499,500,501,502,504,505,506,508,509,511,512,513,514,515,516,517,518,519,520,521,523,524,526,528,529,530,535,536,537,538,539,540,541,542,543,544,545,546,547)

)

table1

GROUP BY

raisedBy,

createdon

ORDER BY createdon ASC"

};

adapter.SelectCommand = cmd;

adapter.Fill(dataset);

DataView view = dataset.Tables[0].DefaultView;

//var chart = sender as Chart;

chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = -320;

chart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = Color.BlueViolet;

chart1.PlotArea.XAxis.DataLabelsColumn = "createdon";

chart1.DataGroupColumn = "raisedBy";

chart1.PlotArea.XAxis.IsZeroBased = false;

chart1.PlotArea.XAxis.Appearance.ValueFormat = Telerik.Reporting.Charting.Styles.ChartValueFormat.ShortDate;

chart1.PlotArea.XAxis.Appearance.CustomFormat = "MM/dd/yyyy";

chart1.PlotArea.XAxis.LayoutMode = Telerik.Reporting.Charting.Styles.ChartAxisLayoutMode.Between;

chart1.PlotArea.XAxis.LabelStep = 1;

chart1.PlotArea.XAxis.MaxItemsCount = view.Count;

foreach (DataRowView rowView in view)

{

var datedate = DateTime.Parse(rowView.Row.ItemArray[2].ToString());

rowView.Row.ItemArray[2] = datedate;

}

if (chart1 != null) chart1.DataSource = view;

}

And finally, attached is the screenshot to see the Chart that is being rendered.

The problem is that is 'Tufail Khan' column(on the chart) is being displayed under the date '2010.06.14', instead of '2010.06.15' where it should have been, if you look at the result from the SQL result..

Any help on this would be very much appreciated.
Cheers Telerik!

Navnit

General Discussions

answered on 07 Jul 2011

1 answer

81 views

Simple Chart with a "Date" and "Number"

Hello:

I am trying to visualize data froma database which comes in two colums, a "date" and a "number" column. I want to put the date on one of the chart axis and the number on the other. Is that not possible? I am getting design time errors telling that "Date" is not numeric.
Please help.

--t

General Discussions

answered on 07 Jul 2011

1 answer

240 views

SQL Connection String issue

I tried following this instructions

http://www.telerik.com/support/kb/reporting/designing-reports/using-connectionstrings-from-configuration-file.aspx

and it works perfectly on my development machine. The problem is that I get the error below when I deployed on our test server.

Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.

The configuration is the same. the only thing different is that it is being pointed to a different database.

Any ideas? Thank you for your feedback.

General Discussions

answered on 07 Jul 2011

1 answer

139 views

Croostab with vertical expansion

I have a simple crosstab report which is working great.
The issue I am encountering is how to keep report on a single printable page while number of rows is rather large.
have total of

6 row group selection ( the actual values of field may be upto 60 character )
2 column group
3 detail values

Typically when you create this report and expand a particulat row during the drilldown( toggle) it will expand horizontally.

Is to possible to expand it vertically, so that actual page size remains fixed and report can grow in height.

See the layout of report in the attached file.
Any suggstion how this can be accomplished.

General Discussions

answered on 07 Jul 2011