Telerik Forums
Reporting Forum
0 answers
90 views
Hello,
I have been trying to make chart like illustrated in ProductLineSales example. But, I cant figure out how and what data is been captured into it as sql command is very complicated (nor I am interested) to understand. I have some tables like, Messages, DeviceMessages and BranchMessages....You can have look at it in attached snapshot.
I just want to show chart (horizontal bars) showing me COUNT(Messages.MessageId) per day, that is COUNT(Messages.MessageId) on x-axis sorted in descending Messages.DateAndTime order on y-axis.....Can anyone please help me making this report?
I`ll be very thankful.....
Saad
Top achievements
Rank 1
 asked on 09 Jan 2010
1 answer
84 views
I am having s tough time tweaking textboxes which touch one another or the section border (I have borders around each section.  Is there a Snap-to-Grid tool or something which would allow me to visually align the boxes?  Or is there a grid view in Design mode?

Thanks.
Bob Bruce
Top achievements
Rank 1
 answered on 08 Jan 2010
1 answer
62 views
Hi,
during the report generation, I need to write in DB the page number associated of every record: i means the page number where the record appears in my report.

It's possbile?
My DB has a columns to store the page number that I need to get from report...

Thanks
Paolo
Steve
Telerik team
 answered on 07 Jan 2010
1 answer
182 views
Hi,

When I try to export my report to PDF some of the text is wrapping to the next page of the report. This is different than how it looks in the reportviewer. In the reportviewer it shows the text on the same page with the rest of the information.
Steve
Telerik team
 answered on 07 Jan 2010
0 answers
75 views
I want to generate report from XML data coming from database, along with the filtering option each column in report!
I have noticed that whatever changes I make in any report sample given on telerik blog for reporting....It stops working.
What is wrong with it? I did download the following sample too
http://blogs.telerik.com/kevinbabcock/posts/09-02-06/bind_your_telerik_reports_to_xml_data.aspx
And again did nothing but added some code and again deleted it back, then report stopped working!!!!!!
I am trying for 5 days for make a single report and cant even see any wrong results though!

Please can anyone give me sample of report generated from database xml column having data like:

<Markers>
<Line>
<Point Latitude="123.432" Longitude="213.423432" Location="abc" Speed="50" />
<Point Latitude="123.432" Longitude="13.7868" Location="some place" Speed="50" />
<Point Latitude="53.432" Longitude="3.432" Location="xyz" Speed="50" />
</Line>
</Markers>
Saad
Top achievements
Rank 1
 asked on 07 Jan 2010
0 answers
92 views
I have XML stored my my database. I searched over internet and found this:
http://blogs.telerik.com/kevinbabcock/posts/09-02-06/bind_your_telerik_reports_to_xml_data.aspx
In this article, XML file is been used and report has been made in a classlibrary. I want to make my report to generate from XML data coming from database at runtime. For example, being on one .aspx page I select VehicleNumber, StartDateTime and EndDateTime from some control (already been done) and pass that information to next .aspx page having report viewer in it showing results based on that filtering parameters!
In the article mentioned above, I learned how to using LINQ for showing XML data in report but how can I pass parameters to that the query as SomeReport_NeedDataSource event would be in class library?

Please can anyone provide me a little example? I am now exhausted trying everything....
Saad
Top achievements
Rank 1
 asked on 06 Jan 2010
5 answers
392 views

I stepped through the report event and noted that the NeedDataSource fires whenever I press preview from the Report viewer.  I do notice however, that the NeedDataSource event fires again when I do an export from the report viewer.    This event is where I set the report.DataSource, this also means that this is where I run the database queries.

I would have thought that since the report.DataSource has already been set/cached during the "preview" action (through the NeedDataSource), the "export to excel" action will not cause the NeedDataSource event to fire again.  This is a winforms application by the way so asp.net statelessness is not an issue.

You see, I have a fairly large monthly data set and it takes twice the time to preview the report and export the report because of this NeedDataSource event.

How is the NeedDataSource event triggered?  What sets the report.Datasource to nothing? 

An example of the NeedDataSource event:

 

 

 

Private Sub MonthlyAccepted_AS_MasterReport_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.NeedDataSource

 

 

 

Dim subGroupName As ISOSettlementProvisionSubGroupName = EnumUtility(Of ISOSettlementProvisionSubGroupName).Parse(Me.ReportParameters(SETTLEMENT_TYPE).Value)

 

 

 

Dim dayofMonth As Date = Date.Parse(Me.ReportParameters(MONTH).Value & " 1, " & Me.ReportParameters(YEAR).Value)

 

me.DataSource = BusinessObjects.MonthlyAcceptedASInfo.GetData(dayofMonth, subGroupName)

 

 

End Sub

Thanks.

 

 

Daniel
Top achievements
Rank 1
 answered on 06 Jan 2010
2 answers
76 views
Hi
I would like the default datetime format to mm/dd/yyyy using a format function.
for eg.
How can i change the format of  = Now()
from 1/5/2010 4:48:00PM to 1/5/2010

Regards
SUNU
sunu
Top achievements
Rank 1
 answered on 06 Jan 2010
1 answer
113 views
Is there a simple way to copy a report to use as a basis for a new report.  Right now I am creating a new report and then copying individual items from the original to the new report.  This works, but is time consuming.
Schlurk
Top achievements
Rank 2
 answered on 05 Jan 2010
3 answers
238 views
When we generate large reports (150 + pages) and then try to export those reports as PDFs, we get the following errror: Report is unavailable or session has expired.

We have increased the seession timeout to 60 in the web.config

<

 

sessionState timeout="60" />

Any ideas?

 

Steve
Telerik team
 answered on 05 Jan 2010
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?