Questions on Reporting Forum

4 answers

117 views

Hi
I need to build a report comprising several diferent pages but all based on the same underlying data. For example the first page would be a summary of all data, the next few pages would be detailed information thqt was used to create the summary, then some text pages displaying written text ect.

I was going down the route of creating a separate report for each and using the ReportBook to bring them all together.

I'm thinking I could also do this with sub reports for each of the sections, which would be the prefered approach.

Andy

General Discussions

answered on 25 May 2010

3 answers

213 views

Cannot figure out data sources....

what is the best way to troubleshoot when your datasource isn't working?

The Fields in the datasource just don't show up when trying to access them.   I need to pull data from an Entity Framework data source.
In the code below, I put everything into a simple class, like your Cars example.

I have created an ObjectDataSource which uses the call to Submissions.GetSubmissions().   I have assigned this datasource to the Report and an embedded list   Everything compiles without errors, but when I try to set a textbox to a field value, I don't see any fields, I just see, "No datasource".

I am using the newly released 2010 version of Telerik Reporting in Visual Studio 2008.

Suggestions?
Is there a walk through that I should be using?

Thanks,
   - Daniel

    
            using System;  
        
            using System.Collections;  
        
            using System.Collections.Generic;  
        
            using System.Configuration;  
        
            using System.Linq;  
        
            using System.Text;  
        
            using DatabaseLayer;  
        
            using log4net;  
        
            namespace PCIIReports  
        
            {  
        
                public class RSubmission  
        
                {  
        
                    private Guid _submissionID;  
        
                    private string _cikrName;  
        
                    private string _cikrCountry;  
        
                    private string _cikrState;  
        
                    public RSubmission() { }  
        
                    public RSubmission(Guid submissionId, String cikrName, string cikrCountry, string cikrState)  
        
                    {  
        
                        _submissionID = submissionId;  
        
                        _cikrName = cikrName;  
        
                        _cikrCountry = cikrCountry;  
        
                        _cikrState = cikrState;  
        
                    }  
        
                    public Guid SubmissionId  
        
                    {  
        
                        get { return _submissionID; }  
        
                        set { _submissionID = value; }  
        
                    }  
        
                    public String CIKRName  
        
                    {  
        
                        get { return _cikrName; }  
        
                        set { _cikrName = value; }  
        
                    }  
        
                    public String CIKRCountry  
        
                    {  
        
                        get { return _cikrCountry; }  
        
                        set { _cikrCountry = value; }  
        
                    }  
        
                    public String CIKRState  
        
                    {  
        
                        get { return _cikrState; }  
        
                        set { _cikrState = value; }  
        
                    }  
        
                }  
        
                public class Submissions  
        
                {  
        
                    private static readonly ILog Log =  
        
                        LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);  
        
                    static string GetConnectionStringByName(string name)  
        
                    {  
        
                        // Assume failure.  
        
                        string returnValue = null;  
        
                        // Look for the name in the connectionStrings section.  
        
                        ConnectionStringSettings settings =  
        
                            ConfigurationManager.ConnectionStrings[name];  
        
                        // If found, return the connection string.  
        
                        if (settings != null)  
        
                            returnValue = settings.ConnectionString;  
        
                        return returnValue;  
        
                    }  
        
                    public Submissions()  
        
                    {  
        
                    }  
        
                    public List<RSubmission> GetSubmissions()  
        
                    {  
        
                        var connectionString = GetConnectionStringByName("pciidbContext");  
        
                        var context = new pciidbContext(connectionString);  
        
                        var query =  
        
                            from submission in 
        
                                context.Submissions.Include("Submitter").Include("OnBehalfOf").Include("Documents").ToList()  
        
                            select new RSubmission  
        
                                       {  
        
                                           SubmissionId = submission.SubmissionId,  
        
                                           CIKRName = submission.CriticalInfrastructureKey == null ? "Unknown" : submission.CriticalInfrastructureKey.Name,  
        
                                           CIKRCountry = submission.CIKRCountry,  
        
                                           CIKRState = submission.CIKRStateAbbr  
        
                                       };  
        
                        return query.ToList();  
        
                    }  
        
                }  
        
            }

General Discussions

answered on 24 May 2010

1 answer

111 views

Problem with refreshing report

I have a report with 2 parameters.

I am using a RepotViewer object on my page.

I set the DataSource in the NeedDataSource Event, when I refresh the report in IE8 or Opera 10.53 the report does not refresh properly.

I have to click two time to see the data in the page.

best wishes

General Discussions

answered on 24 May 2010

2 answers

120 views

XamlParseException when click on the export icon

Hello:

In a new application using Telerik reporting Q1 2010 v4.0.10.423, when I click on the export icon, the system shows a message box with the error “(XamlParseException) [Line: 0 Position: 0]”, followed by several “HRESULT E_FAIL” exceptions. In the same way, if I click on the print button, nothing happens.

I try it with an empty report (only with a static textbox), and the result is the same.

It happens on different computers.

I have another working project, that is using the same reporting version, and it works!

I run the Telerik upgrade wizard several times, and in different computers, but didn’t work.

Regards

Juan Segura

General Discussions

answered on 24 May 2010

1 answer

445 views

How to convert Amount to word

Hi ,

Do you know , How to convert Amount to in words in telerik reporting tool ,

eg: 1000 => One Thousand.

Thanks & Regards
Praveen

General Discussions

answered on 24 May 2010

1 answer

209 views

Amout to words

Hi ,

        How to convert Amount to Words in telerik reporting tool

       eg: 1000 => one thousand

Regards
    Praveen

General Discussions

answered on 24 May 2010

0 answers

92 views

grouping

hi,
i have created report without using report wizard... here my coding is

private void ShiftReport_NeedDataSource(object sender, EventArgs e)

{

this.DataSource = null;

this.shifttab.DataSource = null;

DateTime StartDate = Convert.ToDateTime(this.ReportParameters["StartDate"].Value);

DateTime EndDate = Convert.ToDateTime(this.ReportParameters["EndDate"].Value);

string UserName = Convert.ToString(this.ReportParameters["UserName"].Value);

OleDbConnection con = new OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings["FMS_1_0_0"].ToString());

OleDbCommand sqlCmd = new OleDbCommand("Shift_Report");

DataSet dsGetSearchResults = new DataSet();

sqlCmd.Connection = con;

sqlCmd.CommandType =

CommandType.StoredProcedure;

sqlCmd.Parameters.Add(

"Start_date", OleDbType.Date).Value = StartDate;

sqlCmd.Parameters.Add(

"End_date", OleDbType.Date).Value = EndDate;

sqlCmd.Parameters.Add(

"UserName", OleDbType.VarChar).Value = UserName;

con.Open();

OleDbDataAdapter Sqlda = new OleDbDataAdapter(sqlCmd);

try

{

Sqlda.Fill(dsGetSearchResults);

this.shifttab.DataSource = dsGetSearchResults;

this.DataMember = "";

}

catch (Exception ex)

{

}

}
and
/*the stored procedure is*/

create or replace PROCEDURE Shift_Report
(
       Start_date IN DATE default null,
       End_date IN DATE default null,
       UserName IN Varchar default null,
       cv_1 IN OUT SYS_REFCURSOR
)
as
tmp_userid number(10,0);
BEGIN
tmp_userid:=0;

BEGIN
select user_id into tmp_userid from ztuiusers where legacy_user_name = UserName ;
EXCEPTION
WHEN OTHERS THEN
         NULL;

END;
OPEN cv_1 FOR
select distinct
   CASE
      WHEN to_char(dol.datecreated,'HH24:MI:SS') BETWEEN '08:00:01' AND '16:45:00' THEN '08:00 - 04:45'
      WHEN to_char(dol.datecreated,'HH24:MI:SS') BETWEEN '16:45:01' AND '23:59:59' THEN '04:45 - 12:00'
      WHEN to_char(dol.datecreated,'HH24:MI:SS') BETWEEN '00:00:00' AND '08:00:00' THEN '12:00 - 08:00'
      END AS ShiftTime,
     -- to_char(dol.datecreated,'HH24:MI:SS') datecreated,
       f.fax_id,
       dol.title,
       Users.legacy_user_name
   from fax f
JOIN data_object_log dol
          ON dol.entity_id = f.fax_id
JOIN ztuiusers Users
         ON Users.user_id = f.user_id
JOIN data_object_log_types dolt
        ON dolt.data_object_id = dol.data_object_id
JOIN data_objects do
        ON do.data_object_id = dol.data_object_id
WHERE
(( UserName is null) or( Users.user_id = tmp_userid))and (f.received_date_time between Start_date and End_date)
order by ShiftTime ;
END;

i want to group the time column (i.e giving in case condition)
plz help me.. and post the results as soon as possible...
thank u,
ramya

General Discussions

asked on 24 May 2010

1 answer

206 views

MVVM Report binding

I'm trying to put report in report viewer from MMV pattern but doesn't work.

in xaml

    <Wpf:ReportViewer Name="ReportViewer1" Report="{Binding Reporting}" Grid.Row="0" Grid.Column="0" Grid.ColumnSpan="2" Grid.RowSpan="2" Background="Transparent"></Wpf:ReportViewer>

and in view model:

AttendanceSheetReport Reporting
        {
            get { return _reporting; }
            set
            {
                if(value!= _reporting)
                {
                    _reporting = value;
                    InvokePropertyChanged("Reporting");
                }
            }
        }

If I create report from code behind like that:

AttendanceSheetReport rep = new AttendanceSheetReport();
....
this.ReportViewer1.Report = rep;

I've no problema, but if I try to bind the response is No Report. can You help me?

General Discussions

answered on 24 May 2010

3 answers

791 views

Exception has been thrown by the target of an invocation

I'm trying to add a Report using the Properties popup dialogue of a ReportViewer. After I have drilled down to my selected report, and try to select it, I get a Visual Studio error alert

"Exception has been thrown by the target of an invocation"

Funny thing is that it was all working fine yesterday night :S

Can anyone shed any light as to the possible reasons why this might be happening?

Thanks

David

General Discussions