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

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?

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

Hello, is it a simple way to auto-size a report chart according to the amount of data source?

Hello i use latest telerikcontrols (515) and reporting (423) for SL3.
When i set printrowheaderoneverypage in report to true it show's the header only on first page.
please can you check this ... thank you ...

I'm trying to set a Report Parameter to the current date minus 7 days. I created a user function:

public static DateTime GetPreviousWeek()
{  return DateTime.Now.AddDays(-7);   }

In the ReportParameter Collection Editor, I created a new member, WeeklyDate. Its type is DateTime. The Value is =GetPreviousWeek()

When I try to Preview, I get "The expression contains undefined function call GetPreviousWeek()."  What am I missing?

ETA: I do build the project before I add the user function to the field. I'm selecting it out of the list when I get the error.

Hi,

How can i mark the data item value point with a cross or circle in the line chart.


Thanks in advance.

Dear Sir/Madam,

I Want to ask you about independent report maker ability in your future plan,is this feature in your next version or not?
Now by using Reporting component within the code are possible and can't change all in one file an independent report that we will change.
Please if possible among the plans is the approximate time the company offering it announced in future versions.

You are kindly appriciated to consider my request.
Sincerely yours,
Motallebi.

Hi,

is there a way to limit the export options to "PDF" olnly in code behind?
the reason why i dont want to do it in web.config is because I need different export options in different reports