Telerik Forums
Reporting Forum
1 answer
124 views
I am pretty new to Telerik reporting. So I will try to explain the issues I am facing.

I have a report that binds to the following stored procedure
CREATE PROCEDURE GetSalesValue
 
AS
SELECT  DATENAME(mm, Sales.SaleOrderDate) AS MonthOfSale ,
        SUM(Quotes.NETPrice) AS SalesValue ,
        Source.Source
FROM    Quotes
        INNER JOIN Sales ON Quotes.QuoteId = Sales.QuoteId
        INNER JOIN Enquiry ON Quotes.EnquiryId = Enquiry.EnquiryId
        INNER JOIN Source ON Enquiry.SourceId = Source.SourceId
GROUP BY Sales.SaleOrderDate, Year(Sales.SaleOrderDate),
        Source.Source

this works as expected as in displaying the correct results in month order.  When this sproc gets bound to the report the months are in alphabetical order and not in month order. As you can see attached

I also tried to write the sproc differently and this works both with ASC and DESC

SELECT  DATENAME(mm, Sales.SaleOrderDate) AS MonthOfSale ,
        SUM(Quotes.NETPrice) AS SalesValue ,
        Source.Source
FROM    Quotes
        INNER JOIN Sales ON Quotes.QuoteId = Sales.QuoteId
        INNER JOIN Enquiry ON Quotes.EnquiryId = Enquiry.EnquiryId
        INNER JOIN Source ON Enquiry.SourceId = Source.SourceId
GROUP BY Sales.SaleOrderDate,
        Source.Source
ORDER BY MONTH(Sales.SaleOrderDate) ASC     


Is there a way around this?

Many thanks
Simon
Top achievements
Rank 1
 answered on 25 Jan 2012
19 answers
1.5K+ views
I am currently trying to use export to pdf. It takes forever. Can seem to comprehend why it takes longer. Any hints on what i can look at to identify bottle necks. Secondly i want to know a little bit more about how u are generating pdf files specially the large files which could 10 to 12 mb. In the past i was using aspose to convert to pdf and it brought our server down cuz of high memory usage. Please explain.
You guys have a nice suite of products. I am so glad i finally convinced my company to move from infragistics.(nightmare!)
Prasad
Top achievements
Rank 1
 answered on 25 Jan 2012
2 answers
433 views
hi telerik,

          I am working on invoice for bundle items , need to group the last three column as shown in the attachment. "AGG" column shows the no.of bundles (i.e. 1 here) and in the next two columns need to show the sum ( appx. 1000).  can you suggest how to achieve the design as shown in the attachment.   
sunil
Top achievements
Rank 1
 answered on 25 Jan 2012
3 answers
321 views
I have a class called clsInvoice.  I have a report called InvoiceReport. When InvoiceReport is created, the DataSource is assigned to be a clsInvoice.  Then I assign a few images on the report manually.  Then I preview the report.  All is well.

Now I want to print multiple invoices.  I created a new report MultInvoiceReports.  I added a detail band only.  I added a SubReport to this band, and set it to be an InvoiceReport.  My InvoiceReports data source is an ObservableCollection<clsInvoice>.

I tried for a long time to get bindings to work.  I never could.  Eventually I used the NeedDataSource method and manually assigned it.  The images I was creating and assigning did not print, but the report worked otherwise.

Next, I removed the subreport from the designer, and tried everything manually:
foreach (clsInvoice c in InvoiceList)
{
  // Create a new InvoiceReport
  // set the data source to c
  // Assign my images
  // Create a subreport
  // Set the ReportSource to the InvoiceReport
  // Find the DetailSection in MultInvoiceReports and add the subreport to DetailSections.Items.
}

This makes the reports all show, however there are 4 to 7 blank pages between sub reports, and again my images do not work.

Is there a better way to do this?
Paul
Top achievements
Rank 1
 answered on 24 Jan 2012
1 answer
95 views
We have a Web applicaton that is getting the following error when trying to run a report.  The database and web server are on the same machine and the application functions correctly.  Can anyone give me a idea where I could look on fixing this issue,
Stephen
Top achievements
Rank 1
 answered on 24 Jan 2012
0 answers
73 views
Hello,

We are trying to give users a context menu when they right-click over the report (rather than showing 'Silverlight').
We can capture the event and detect it is over the reportviewer.

The issue for us is that we want to give them copy/paste functiionality if there is text highlighted in the textboxes that hold the parameters, but not otherwise.  The biggest issue is that we can't find a way of 'getting at' the textboxes that hold the parameters.

Any suggestions - is this possible at all?

Thanks,
 Ed
Ed
Top achievements
Rank 1
 asked on 24 Jan 2012
2 answers
153 views
Hi!

Is it possible to use multivalue parameters together with an openaccessdatasource?
I have problems when using them in filter expressions.

/Joakim
Joakim Winkler
Top achievements
Rank 1
 answered on 24 Jan 2012
1 answer
205 views
Hi we have our application in visual basic 6 with crystal reports. but we want to change telerik reporting.

telerik reporting is possible to use in applications in vb6 ?
Steve
Telerik team
 answered on 24 Jan 2012
1 answer
129 views
Hi telerik team,
I'm developing a reporting char, and I needed your support:
My chart have many duplicate xaxis (with the hours of the records.) and i just want remove it.
I put a chart image in attachment and i leave the source...

private void PositionTempChartNeedDataSource(object sender, EventArgs e)
{
PositionTempChart.DataSource = this.DataSource;
 
var procChart = (Telerik.Reporting.Processing.Chart)sender;
var defChart = (Telerik.Reporting.Chart)procChart.ItemDefinition;
 
defChart.IntelligentLabelsEnabled = false;
defChart.PlotArea.Appearance.Dimensions.Margins.Top = Unit.Pixel(25);
defChart.PlotArea.Appearance.Dimensions.Margins.Bottom = Unit.Pixel(25);
defChart.PlotArea.Appearance.Dimensions.Margins.Left = Unit.Pixel(25);
defChart.PlotArea.Appearance.Dimensions.Margins.Right = Unit.Pixel(0);
             
var temperature1 = new ChartSeries { Type = ChartSeriesType.Line };
temperature1.Clear();
temperature1.DataYColumn = "Temp1";
temperature1.DataXColumn = "DoubleDateTime";
temperature1.Appearance.ShowLabels = false;
temperature1.Appearance.LineSeriesAppearance.Color = System.Drawing.ColorTranslator.FromHtml("#86D8A0");
temperature1.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.Nothing;
defChart.Series.Add(temperature1);
 
var temperature2 = new ChartSeries { Type = ChartSeriesType.Line };
temperature2.Clear();
temperature2.DataYColumn = "Temp2";
temperature2.DataXColumn = "DoubleDateTime";
temperature2.Appearance.ShowLabels = false;
temperature2.Appearance.LineSeriesAppearance.Color = System.Drawing.ColorTranslator.FromHtml("#F09081");
temperature2.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.Nothing;
defChart.Series.Add(temperature2);
 
defChart.PlotArea.XAxis.DataLabelsColumn = "DoubleDateTime";
defChart.PlotArea.XAxis.IsZeroBased = false;
defChart.PlotArea.XAxis.AutoScale = false;
defChart.PlotArea.XAxis.Appearance.ValueFormat = ChartValueFormat.ShortTime;
defChart.PlotArea.XAxis.Appearance.CustomFormat = "HH";
}


Can you help us? 
Thanks
Giuliano Caetano
Giuliano Caetano
Top achievements
Rank 1
 answered on 24 Jan 2012
1 answer
138 views
Hi.

I would like to know how to display SmartLabels for values that less than 11. Please take a look at the attached screen-shot. The smart labels is displayed only if value is 11 or bigger. How can I change this behaviour?
Many thanks in advance.

Dmitry
Evgenia
Telerik team
 answered on 24 Jan 2012
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?