Questions on Reporting Forum

1 answer

227 views

I have looked through the forums and demos but have not seen a demonstration of this.

I created a a class library and report (w/ parameter). I then added a reference to the project in a ASP website and added a viewer and my report to a control on a page. The report works great when I select the parameter from my list of values.

What I would like to do, and haven't seen an example of, is navgate to the page my report is on and pass the parameter in the url.

An example of the url would be;
http://localhost:50536/Pages/Voucher.aspx?TrackID = 1000

1.) Can you provide me with a rundown on how this is accomplished?
2.) What changes would I need to make to my class library/report to change from manually setting the parameter?

The website is ASP with VB.net code behind.
TelerikReporting Q1, 2011

Thanks for the help,

General Discussions

answered on 13 Jun 2011

3 answers

484 views

is it possible to lock the width of the report in designer

hi!

i would like to know if i can prevent the designer to expand the width of the report when i move a control. If for example and i want to move a textbox to the right and that the control cross the end of the report width, the report will auto-extand and i need to change the report width to the good value again.

so is it possible to lock values in the designer?

alex

General Discussions

answered on 13 Jun 2011

1 answer

100 views

Calendar-style report repeats calendar for each day

Hi,

I'm trying to create a report that represents a calendar with appointments listed for each day. I am following the example provided here: http://blogs.telerik.com/blogs/posts/11-05-03/creating_a_calendar_report_with_telerik_reporting.aspx

PROBLEM 1:
The problem is that when I preview the report at both design and runtime the report generates a calendar for each day in my date range. So for example if the date range is 1 June 2011 through 30 June 2011 I get 30 pages with the June calendar on each page. I can't for the life of me figure out why. Again, I followed the code example above and cannot determine the difference between the sample solution and mine.

PROBLEM 2:
This is not as important but the subreport in the body of the crosstab is positioned to the 0, 0 position of the crosstab itself, not the crosstab of the body. The problem exists in the sample above.

PROBLEM 3:
How can I allow the crosstab body to grow? If the contents of any one day in the calendar is greater than the available space I want the day bounding areas to expand.

Thanks,
Dave

General Discussions

answered on 13 Jun 2011

1 answer

94 views

Better control over CSV Export

Is there a way for me to handle the "export to CSV" server side? I have a requirements that states that the export from a report delivers a row/col result that contains data not bound to the report. Far as I can tell, there is not an "OnExport" event available in the report viewer.

General Discussions

answered on 13 Jun 2011

1 answer

519 views

Panel Visibility Based On Report Data

Hi,

How can I change the visibility of a panel (or for that matter, any UI element) based on the value of a piece of data returned in the report's Select statement?

Can I access the report data in the 'code behind' of the report without going through user functions?

Can I execute code that accepts data fields at a higher level than the individual report field level e.g. to hide or show a panel based on a data value?

Apologies for the 3-in-1 question!

Regards,
Steve

General Discussions

answered on 13 Jun 2011

3 answers

180 views

text boxes do not render if they have no data

I have recently upgraded one of my reporting projects to the latest version of Telerik (5.0.11.510) and I have noticed that if a text box has no underlying data (Null or blank values) then it is not rendered on the report. The problem that I have is I use the text boxes to draw lines on the report (make a grid) using the textbox borders, if they are not rendered then I get gaps in my grid (see screen shot attached.
Is there an option to force the report to render all of the text boxes like it used to do in previous versions?

General Discussions

answered on 13 Jun 2011

0 answers

98 views

Can't add a report to ReportBook after building Report Library

Hi,
here the problem:
I create a Report and i test it by a winfrom it work fine. If i modify this report adding some code getting data form my DataLayer and i compile it all still run fine, but the design of my win form (in design time) show me an error

1- I create 2 class in report library

public class mCubeDistrXday

{

public int cont { get; set; }

public string cardType{ get; set; }

public string Country{ get; set; }

public string na { get; set; }

public DateTime ? date { get; set; }

}

public class lstCubeDistrXday : List<mCubeDistrXday>

{

}

2- I create a Table Report (with WIzard)
the datasource is lstCubeDistrXday collection.

3-I create a report by wizard
-As datasource type i set the ObjectDataSource one.
-I bind it to my DataLayer Library and i set a method as datamemeber (let say...getMyItemsFromDB) My DL library is referncede in Reprto Library
-The wizard let me choice the fields to put in table report.
-Finally i have A table report with all my filed

4- I write some code to populate the collection (i want tesst it wit a hardcoded collection first, so i dont yet get data from DL):

private List<Model.mCubeDistrXday> myItemList = new List<mCubeDistrXday>();

public Report8() {

InitializeComponent();

mCubeDistrXday i = new mCubeDistrXday();

i.cont=10;

i.data=new DateTime(2011,02,02);

i.na="";

i.cardType="OPE";

i.country= "ITA";

myItemList.Add(i);

i = new mCubeDistrXday();

i.cont = 10;

i.data = new DateTime(2011, 02, 02);

i.na = "";

i.cardType= "OPE";

i.country= "EXT";

myItemList.Add(i);

var selectqry =

from t in myItemList 

        where t.nazione != null && t.tipoTessera != null && t.data != null

select new { nazione = t.nazione, tipoTessera = t.tipoTessera, cont = t.cont, data = t.data, na = t.nazione == "ITA" ? "ITA" : "EXT" };

this.objectDataSource1.DataSource = selectqry;

}

4-I add a winForm project to my solution to debug the report the report
on the form i add a reportViewer then a ReportBook i ad my report to Rport book and finally i set hte property report to report81 (it is my report)
ALL WORK FINE and i See my data in my report

Now i try to binf me DataLayer, just a little change:

public partial class Report8 : Telerik.Reporting.Report

{

private DataObjectsSE.IDbStat.IDbStatDao daoDbStat = DataObjectsSE.DataAccess.dbStatDao;

public Report7() {

//

// Required for telerik Reporting designer support

//

InitializeComponent();

var selectqry =

from t in daoDbStat.getCubeTipoTesseraDataNazione("MyParam")

where t.nazione != null && t.tipoTessera != null && t.data != null

select new { nazione = t.nazione, tipoTessera = t.tipoTessera, cont = t.cont, data = t.data, na = t.nazione == "ITA" ? "ITA" : "EXT" };

this.objectDataSource1.DataSource = selectqry;

}

I compile the report Library and i launch the winForm project to see the report.

ALL WORK FINE. i can see my Data.
But i have a problem: at design time the WINFORM can't display and shows me the following message:

The variable 'report71' is either undeclared or was never assigned.

Instances of this error (2)

1.

Show Call Stack

2.

Show Call Stack

Help with this error

MSDN Help

Forum posts about this error

Search the MSDN Forums for posts related to this error

PLease, any Idea?

General Discussions

asked on 11 Jun 2011

1 answer

108 views

Cannot instantiate ReportViewer

Please remove, solved....

General Discussions

answered on 10 Jun 2011

3 answers

398 views

Passing a Field value to an ObjectDataSource parameter

Is It possible to set a Field value as objectdatasource parameter value?

General Discussions

answered on 10 Jun 2011

2 answers

108 views

Drillthrough to the target which need data bound.

I was shocked that telerik reporting can't go with drill through without compiled 'dll'' at web site project.
It was ok when telerik reporting is under web application project. Design view works fine and when I set navigation to another report, the dll information was set automatically to reportdocumenttype at desgin view.

But in web site project desgin view doesn't work so if drill through was gonna be made, telerik reporting had to be compiled to dll seperately and add into project. But this is problem. Database connection can be changed and depends on specific environment which mean whenever program containing telerik reporting moves to other environment the telerik reporting must be compiled again for that.

I think drill through of telerik reporting is horribly limited even excepting this.

So somebody can help me.
I need drill through function in web site project and all of chart in report should be bound dramatically.
Main problem is target report to be navigated when clicking an item can't be set dramatically. It should be set in advance before drill through. I wanna fill the objectdatasource in target report with data on the fly.

Is there any solution for this? . .

General Discussions

answered on 10 Jun 2011