Telerik Forums
Reporting Forum
1 answer
108 views
Hi,

I put static list items in htmlTextBox. It is showing more gap between two lines in design view. But it is showing less space in edit expression. And same code I copied to notepad and saved as html, it is showing exactly same as edit expression view. 

How can get list like html or edit expression view. Please find attached screen shots with this mail.


Regards,

B.Sridhar

  
Steve
Telerik team
 answered on 12 Oct 2009
1 answer
117 views
Hi there.

I am new to Telerik Reporting and I have read some KB articles about using a stored procedure as my data source. I think I have it setup correctly because my _NeedDataSource method is getting called, but none of my data elements are getting populated. I am just hard-coding the parameters for now and when I run the sproc manually, I get data, so I am confused as to why I am not getting any data in my report. Here is my class:

 

public partial class My_Report : Telerik.Reporting.Report

 

{

  public My_Report()

  {

    InitializeComponent();

    this.DataSource = null;

 

    this.NeedDataSource += new System.EventHandler(this.My_Report_NeedDataSource);

  }

 

 

 

  private void My_Report_NeedDataSource(object sender, System.EventArgs e)

  {

    //Transfer the ReportParameter value to the parameter of the select command

 

    this.sqlDataAdapter1.SelectCommand.Parameters["@PersonID"].Value = 8;

 

    this.sqlDataAdapter1.SelectCommand.Parameters["@OperatorID"].Value = 11; 

 

    //Take the Telerik.Reporting.Processing.Report instance and set the adapter as it's DataSource

 

    Telerik.Reporting.Processing.

Report report = (Telerik.Reporting.Processing.Report)sender;

 

    report.DataSource =

this.sqlDataAdapter1;

 

  }

}

 

 

I have each of my fields in a table referencing in this manner:
    =Fields.TaskNumber

I do no receive any errors or anything, so I am looking for some guidance.

Thanks, Mike

 

More info:
When I added this to my NeedDataSource method:

 

 

this.sqlConnection1.Open();

 

 

int rows = this.sqlSelectCommand1.ExecuteNonQuery();

rows returns -1, so I am somehow not getting any data back. I removed the parameters from the sproc and just hardcoded them and I still get a return value of -1 in rows. Any ideas?

 

Michael Love
Top achievements
Rank 1
 answered on 09 Oct 2009
2 answers
108 views
Everyone,

I am trying to add a report generation system to my web site.  I am trying to use the trial version of Telerik Reporting to see if it can do what I need it to do.  I am using Visual Studio 2008 and Framewrok 3,.5.  I have a report class created and a report viewer on my web page.  I get my data table from WCF and assign it to the report.  The report displays with headings but no data rows.  I have used '=FieldName" and "=Table.FieldName" in the text boxes to no avail.  My code is simple:

 

Dim objMainReport As Telerik.Reporting.Report = New RequestsByDate()

 

objMainReport.DataSource = dsTemp.Tables(0)  '-- table is available here

ReportViewer1.Report = objMainReport

ReportViewer1.DataBind()

I know that it is probably something to do with my RequestsByDate class, but I really have no clue.  Any help would be appreciated.

Thanks in advance,

Mark

Michael Love
Top achievements
Rank 1
 answered on 09 Oct 2009
4 answers
334 views
Hello!

I have a question concerning the positioning of items on the report page. First, my scenario:

- One report wich has the Page Header section, 2 groups, Detail Section with a subreport inside it, Page Footer section;
- The sub report has only a crosstab in the report header section, with page header, report footer, page footer, detail sections invisible.

My problem is how to make the crosstab appear always centered in the report pages... Is there a way to do this?

Thanks and regards!
Stargazer
Top achievements
Rank 2
 answered on 09 Oct 2009
3 answers
163 views
Hello,

We have a need to inherit our reports from an abstract base class, and when we do we can not access the designer.  An error comes up saying "The designer must create an instance of type 'reportbasename' but it cannot because the type is declared as abstract. "  I changed the base type to a normal class and recieved the following error: "The designer could not be shown for this file because none of the classes within it can be designed. The designer inspected the following classes in the file: reportname --- The base class 'reportbasename' could not be loaded. Ensure the assembly has been referenced and that all projects have been built. "

Any help or guidelines to follow for this issue would be greatly appreciated, Thanks in advance.

-Lars Solberg
Steve
Telerik team
 answered on 09 Oct 2009
0 answers
65 views
Please, i need to  Display Report with a crosstab with alternating style rows, How can I do????
Silvia
SIlvia
Top achievements
Rank 1
 asked on 09 Oct 2009
2 answers
93 views
Hi
 
I have a report with the databinding at runtime.
 
This code displays a blank report even on hitting the report refresh icon.
 
Public Sub New()
InitializeComponent()
Dim fs As New CPSMDAL.JobPlan
Dim fsDT As DataTable = fs.JobPlanReport(JobPlan_ID)
Me.DataSource = fsDT
End Sub
 
However this still displays a blank report, but on hitting the refresh icon it does display the full report.

 

Public Sub New()
InitializeComponent()
End Sub

 

 


Private
Sub JobPlan_Frontsheet_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.NeedDataSource
Dim fs As New CPSMDAL.JobPlan
Dim fsDT As DataTable = fs.JobPlanReport(JobPlan_ID)
Me.DataSource = fsDT
End Sub

 

If I debug the code, the recordset has 15 members, why isn't it binding.
Andy Green
Top achievements
Rank 1
 answered on 09 Oct 2009
0 answers
46 views
The same thing with Cancel button when you decided cancel printing.  Is this a bug or feature?
Sergei Rassk
Top achievements
Rank 1
 asked on 09 Oct 2009
3 answers
302 views
Hey all,

I've managed to get this far, and could just use a nudge in the right direction if possible:

I wanted to select values from my database, have my business object return them in a collection (generic) and then create parameters in a dropdownlist at the top of the report, so a user can select an item at the top. Subsequently, this item would go out to a stored procedure, that would get different results on the page (i'm actually using a graph on the chart/report)

List

 

<string> campaignTypes = ReportGenerator.GetCampaignTypes(parameters/metadata goes here..);

 

 

 int i = 0;

 

 

foreach (string campaignType in campaignTypes)

 

{

 

  ReportParameter rp = new ReportParameter(campaignType, ReportParameterType.String, campaignType);

 

 

  this.ReportParameters.Add(rp);

 

 

  this.Report.ReportParameters[i].UI.Text = campaignType;

 

 

  this.Report.ReportParameters[i].UI.Visible = true;

 

   i = i + 1;

}

So the area in green..this goes ahead and adds 3 parameters (i had 3 items in the list), but the problem is they are all new parameters in textboxes! I wanted to have 3 in one report parameter collection, as a dropdownlist.

I understand there is a reportparametercollection, but I did not see a way to add it to the report. Only to create it and add report items to it. This code is in the constructor of my report, by the way. Any suggestions on how to get the dropdownlist to appear, and have it's datasource as the generic?

Thanks so much!

Steve
Telerik team
 answered on 08 Oct 2009
1 answer
371 views
Hello,

I am putting together report using the table control. I have been trying to find a way to merge cells but it seems impossible at this point.
Please confirm.

Since I was not able to find a way top merge cells in order to put together the correct columns titles that span across multiple cells I've placed text boxes above the table and aligned the boxes to the exact lines of the cells.
However, when rendered in HTML the text boxes are no longer aligned.

Can you please advise how I can address such an issue. Screen shots attached.

Thank you,
G
Steve
Telerik team
 answered on 08 Oct 2009
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?