Telerik Forums
Reporting Forum
1 answer
136 views
Hi, 

 I purchased the telerik report and rad controls, and now I try make a report with oracle database with procedures.

Well I tried make a business class to access oracle and this is ok, but how to make the methods to bind in reporting and return the correct dataset format?

Someone can help me, send an business class that return an dataset to the report?

Thanks,
Jose
Milen | Product Manager @DX
Telerik team
 answered on 30 Jun 2008
2 answers
237 views
I've been looking for a good way to standardize reports across our several applications, and the use of the external style sheets seems to be a good way to go - I've set up each report to reference the style sheet. However there's a fairly large problem I'm not sure how to get around.

First, the solution structure:

1. Data Library
2. Reporting Library
3. Main application / Small seperate Reporting application /  Windows service

3 references 2 which references 1.

The problem is two fold.

A) I have a laptop and a desktop, and their folder structures differ. So one has H:\Documents\Projects\ReportingLibrary\ and the other has C:\Projects\ReportingLibrary. This causes me issues every time I switch back and forth, because the reports store the absolute path to the external style sheet - each time I switch I get path not found errors and I can't even view the report without first going in and manually changing the path.

B) I tried solving the above problem by entering a relative path manually - ie, "\\Stylesheet.xml". This .. sort of works. Unfortunately (and I would consider this a bug) the designer seems to think that it needs to look in the SOLUTION folder for the relative path! So as soon as I add the ReportingLibrary project to another solution it errors out again (and remember, I've got 3 different solution files, one for each type of application).

End result is I'm chucking copies of this xml file all over my projects just to get the designer to behave - I've got it working to extract the xml from the resource manifest in the dll and use that at run time, but during design time it is kind of important to have your styles properly applied.

I would request 2 options here:

1. Have an option for specifying a relative path in the collection editor for external styles.
2. When resolving relative paths at design time, start at the project level, not the solution.


Pawz
Top achievements
Rank 1
 answered on 29 Jun 2008
1 answer
121 views
Hello,

I am using Telerik reporting 2.5/VS2005/VB.net.

In a group footer, I want to conditionally suppress lines that have zero values.
Example:

Totals for conference 232322
800 callers        9
Local callers      5
Dialout callers    2
Total callers        16

If there are no Local callers, I want the following ....
Totals for conference 232322
800 callers        9
Dialout callers    2
Total callers        11

With no blanks for the rows, a total suppression of the lable and counter field.

Thanks, Ken

Milen | Product Manager @DX
Telerik team
 answered on 25 Jun 2008
2 answers
742 views
if i use substr to simply show the first 20 chars of an address, =substr(Address,20) its fine as long as the address is longer than 20 chars and isnt null, but delivers errors if the address is either short or null
Scott
Top achievements
Rank 1
 answered on 25 Jun 2008
3 answers
157 views
i have a user function public static and it works fine in preview mode but in web viewer i get 
#ERROR# The expression contains undefined function call ShortAddress().
kmv
Top achievements
Rank 1
 answered on 25 Jun 2008
4 answers
258 views
When publishing my web application to the production site, I get this applicaiton error on start up:

Parser Error Message: Could not load file or assembly 'Telerik.Reporting.Interfaces, Version=2.0.1.0, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The system cannot find the file specified.

Line 51: <add assembly="Telerik.Reporting, Version=2.0.1.0, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
Line 52: <add assembly="Telerik.Reporting.Processing, Version=2.0.1.0, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
Line 53: <add assembly="Telerik.Reporting.Interfaces, Version=2.0.1.0, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
Line 54: <add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
Line 55: <add assembly="Telerik.Charting, Version=1.7.2.0, Culture=neutral, PublicKeyToken=D14F3DCC8E3E8763"/>

Here is a screen shot of the files in my /bin folder on the production server:

http://screencast.com/t/9bObhKoKMB

I don't need to install the Telerik Reporting components on the production web server, do I?

Thanks,

Jason


Steve
Telerik team
 answered on 25 Jun 2008
5 answers
311 views
I have a section on my report that display the company name, street address, city, state and zip all stacked on top of one another. My problem is that when someone enters a two line street address, the second  line bleeds over on top of the city. Is there a way to dynamically increase the size of the textbox to accommodate the second line and then push all of the textboxes underneath it down.

Thanks
Jeff
Jeff
Top achievements
Rank 1
 answered on 24 Jun 2008
1 answer
195 views
hi,
    Iam new to Telerik.I want to do bind the telerik Report dynamically.
i don't want to use dataadapter.

I used dataadapter for reports.it is working fine in my mechine.but when deployed it in server it may show error ie(connection string).
to avoid this problem iam trying to use dataset only.and one more is iam useing reports in dotnetnuke .and iam useing storedprocedures.

i have a method it returns Dataset. Iam passing parameters dynamically to the method.so i want to assign dataset to report.

I used CrystalReports previously ,in that i used xml file.i loaded the xml file useing dataset.than i assign it to CrystalReport. here i was strucked when working with TelerikReport.

pls help me .pls send me any code for binding the report dynamically.

ThankYou..
Steve
Telerik team
 answered on 24 Jun 2008
1 answer
104 views
Hello

Is that Telerik reporting webinar from 6/18 available for purchase? I was not able to attend it live, but would love to see it now.

Thanks
Harold
Ivo
Telerik team
 answered on 24 Jun 2008
5 answers
510 views

i have read numerous posts and it appears as if i am doing this correctly, but i cannot get it to work. i am trying to pass 3 parameters to a stored proc used within my report. i use a class library for my report. i can run it in the designer fine, but when trying to execute from my application i get:

"procedure or function 'rpt_unpaidregistrations' expects parameter @OrganizationKey, which was not supplied.

if i put in a breakpoint on report1, i can see my parameters, and, after this code executes, their values. what am i missing?

as another question, in the class library when you are setting up the report, there seem to be 2 places where you can specify parameters. in the report itself AND within the SQLDataAdapter. running within the class library, i don't seem to need to ones at the report level. when are these needed, if at all?

thanks...

Me.ReportViewer1.Report = New rptUnpaidRegistrations

Dim report1 As Telerik.Reporting.Report = Me.ReportViewer1.Report

report1.ReportParameters(0).Value =

CInt(currentUser.OrganizationKey)

report1.ReportParameters(1).Value =

CInt(seasonKey)

report1.ReportParameters(2).Value =

CInt(leagueKey)

Me.ReportViewer1.Report = report1

Susan
Top achievements
Rank 1
 answered on 24 Jun 2008
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?