Telerik Forums
Reporting Forum
1 answer
138 views
Hi,

A client has problems with his reportviewer, when clicking the print button in the wpf report viewer nothing gets printed. It worked until recently.

I have not changed anything in the project and it prints from my pc.
I would like to know if Telerik depends on other components than .net 4 framework ?. Because something has been changed in the clients computer, for it to stop working.

Best regards

Ole.
Steve
Telerik team
 answered on 07 Feb 2012
1 answer
79 views
Hello,
I have a problem with reporting in Lightswitch. I have created an empty report, a new control in client and WCF service with reporting service. So now I am able to view empty report in Lightswitch application.
The report is in ServerGenerated project.
The problem is that I am not able to view some data in report. I cannot use the direct SQL access. I need to use existing RIA domain service with existing queries.
The solution should be deployed in Azure and in 3 tier scenario.
How to achieve that?
Thank you
Steve
Telerik team
 answered on 07 Feb 2012
3 answers
564 views
Hi All,

I have try to create a bar chart from database,but I have no clue to make dynamic chart legend data from database.

Can anyone give example for me..?


=========  This is my Code ======================
 private void chart1_NeedDataSource(object sender, System.EventArgs e)
        {
            this.chart1.Series.Clear();
            String pPeriodeStart = Convert.ToString(this.ReportParameters["PeriodeStart"].Value);
            String pPeriodeUntil = Convert.ToString(this.ReportParameters["PeriodeUntil"].Value);




            if (pPeriodeStart == "") pPeriodeStart = "null"; else pPeriodeStart = "'" + pPeriodeStart + "'";
            if (pPeriodeUntil == "") pPeriodeUntil = "null"; else pPeriodeUntil = "'" + pPeriodeUntil + "'";


            string sql = @"exec dbo.procedureName @PeriodeStart = " + pPeriodeStart+ ", @PeriodeUntil = " + pPeriodeUntil;
           
            string connectionString =
             "Data Source=xxx-pc\\SQLEXPRESS;Initial Catalog=dbname;Persist Security Info=True;User ID=sa;Password=password";


            SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString);
            DataSet dataSet = new DataSet();
            adapter.Fill(dataSet);


            ChartSeries series = new Telerik.Reporting.Charting.ChartSeries();
            series.DataYColumn = "AuctionDealValue";


            series.Appearance.LabelAppearance.Visible = true;
            //series.Appearance.ShowLabelConnectors = true;
            series.Appearance.ShowLabels = true;


            series.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels;
            
            //this.chart1.DataGroupColumn = "StakeholderId";


            this.chart1.ChartTitle.TextBlock.Text = "Test";


            this.chart1.PlotArea.XAxis.AutoScale = false;
            this.chart1.PlotArea.XAxis.AddRange(1, 10, 1);
            this.chart1.PlotArea.XAxis.DataLabelsColumn = "CommodityName";


            this.chart1.Series.Add(series);
            (sender as Telerik.Reporting.Processing.Chart).DataSource = dataSet.Tables[0].DefaultView;
        }

============= end of code ===============

+++++++++ this is my data from store procedure ++++++++++++++++
AuctionDealValue StakeholderName CommodityName CommodityId  StakeHolderId
36.475000000 fedde1                       Jagung 1 bures1
271.723100000 fedde2 Kayu Jati 2 bures1
47.050000000 fedde3 Kakao 3 bures2
+++++++++ this is my data from store procedure ++++++++++++++++


Regards,


Diki

Elian
Telerik team
 answered on 07 Feb 2012
1 answer
70 views
I am hosting a Silverlight ReportViewer in a XAML file that programmatically sends parameters to the ReportViewer like this:
void TheReportViewer_RenderBegin(object sender, Telerik.ReportViewer.Silverlight.RenderBeginEventArgs args)
{
    args.ParameterValues["SubjectId"] = subjectId;
    runOnce = true;
}

I also have a DrillThrough action setup on the DetailsSecion of my initial report, which I created through the Design view, so that each details ReportItem has an action that operates like this (taken from the Designer.cs):
navigateToReportAction1.Parameters.Add(new Telerik.Reporting.Parameter("SubjectId", "=Fields.SubjectId"));
navigateToReportAction1.ReportDocumentType = "Application.Reports.ReportType.DetailReport, Application.Reports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null";

The DrillThrough is intended to load a DetailReport, passing the SubjectId of the particular item clicked in as a parameter. The navigateToReportAction behaves as expected, but my DetailReport loads with the following error.
One or more parameters are not set or have invalid values.

I believe the RenderBegin event might be blowing out my parameters, but even if I try some trickery like this:
private bool runOnce = false;
void TheReportViewer_RenderBegin(object sender, Telerik.ReportViewer.Silverlight.RenderBeginEventArgs args)
        {
            if (!runOnce)
            {
                args.ParameterValues["SubjectId"] = subjectId;
                runOnce = true;
            }
        }

my DetailReport still reaches the ItemDataBound event of the DetailSection with ReportParameters["SubjectId"].Value equaling null.

What am I to do? Has anyone run across a scenario where parameters passed from a DrillThrough don't load in the report navigated to?

Many thanks for your time,
-Jonathan
Elian
Telerik team
 answered on 07 Feb 2012
4 answers
137 views
Hi:

I'm trying to make a really simple report to print in a 4-different-parts per page document.

So my report has only a Detail, you can see it in "reportdetail.png".

This detail HAS TO BE 7,6cm because every page will be cutted in 4 different parts and all of them must be written the same way (I mean, every field should be in the same place (the first one at 2cm X 2cm Y etc...).

The result is really confusing because it doesn't leaves those 7,6cm for each detail and you can see the result in reportprint.png

As you can see, every detail is different from each other, this is especially seen in the last part of the report (see at that LARGE margin when it should be almost at the bottom of the report.

Am I doing anything wrong? How should I do this?? Thanks in advance!!

IvanY
Telerik team
 answered on 07 Feb 2012
1 answer
88 views
Hello,

I`m trying to make a X-Axis variable scale chart. I have attached one image with a similar chart style. From this chart I'm only interested on variable scale. (It's the best example I have found).

The image shows how X-Asis values grows exponentially from 0 to 10000.

I don`t know how to make a non lineal X-Asis with Reporting Charts.

How Can I develop a Reporting Chart like this?

Thank you very much.
Evgenia
Telerik team
 answered on 07 Feb 2012
1 answer
50 views
Hi,
I have a report which need me to print out the user and their number. I want to have the following format:

UserName Phone   UserName   Phone
User1        999        User5         999
User2        999        User6         999
User3        999        User7         999
User4        999        User8         999


The above report is all in 1 page. What happen here is that the report record continue to next column3 and column4.
Is it possible?

Thanks
Regards
Steve
Telerik team
 answered on 07 Feb 2012
6 answers
246 views
Hello

I am investigating the Telerik Reporting component and am trying to replicate a Crystal report using it.

So I've done most of the report (table and chart) via the report designers. 

My issue is that the report designer can reset some previously set properties which is very frustrating.

For example, i have the report set to show a Count value on the Y axis and a date on the X axis.  I have nearly everything as I want it in terms of fields to show, labels, etc and go into the Chart properties (the one that shows in a different dialog with the different tabs), select a different skin and a bunch of my previously set properties are gone.  So ok, mental note to set the Skin before anything else.

So I get it back to how it was, and then go into the Series Collection... dialog to check a property but I CANCEL out of the dialog and then I've lost the x and y axis value formats (at the least) so my report doesn't work anymore and I have to go in and figure out what has changed.

I've also noticed that the rotate property for the labels does not always work (I had it working but it was reset at some point as per above) and have resorted to setting this particular setting via code.

We're running Q3 2011.
Joan
Top achievements
Rank 1
 answered on 06 Feb 2012
1 answer
93 views
I have a simple report that is simply pulling the data from a SQL db and displaying it on the report. 

the qry is something like 

select name,title,number,address from table1 where name in (@values)

I then created a new parameter, that pulls the potential options from the database, the qry is something like 
select distinct (name) from table1


When i preview the report, the values are in the drop down list, but when i select any and hit preview, I get 0 results. 


if i change the query to be 
select name,title,number,address from table1 where name = @values
(and only select one value) it does return results. 


Suggestions on what would cause this behavior?
Steve
Telerik team
 answered on 06 Feb 2012
3 answers
157 views
Hi.

Is it possible to access a div element with jQuery? I need to write a costum jQuery function
for a "onClick" event in my Report. Within the div I have a picture and when the user clicks
on it, I want to pop-up a window to display the photo.

Screenshot: http://i44.tinypic.com/ok9y5e.jpg

Thanks!
Steve
Telerik team
 answered on 06 Feb 2012
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?