Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Display Only The Date Part Of A Datetime Parameter


I have a datetime user inputted parameter on a report. I want to display it on the report without the time part.
 
ie. it displays
 
4/8/2007 12:00:00 AM  
 
I want just to display the date part
 4/8/2007
 
 
Is this possible?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
How To Get The Date Part Of Datetime
Is there any other way which is more simpler(shorter) to get the datepart (I don't want the time part ) of Datetime than this ?Convert(nvarchar, DATEPART(dd,[Date]) ) + '/' + Convert(nvarchar,DATEPART(mm,[Date])) + '/' + Convert(nvarchar, DATEPART(yy,[Date])) As[Date]

View Replies !   View Related
Looking To Collect Distinct Date Part Out Of Datetime Field
from this, circdate being a datetime field:SQLQuery = "select distinct circdate from circdata order by circdate"I need the distinct date portion excluding the time part.this has come about when I discoveredI am inserting and updating some datetime values with the same value,but for some reason, the values are always off by a few seconds. I seta variable called SetNow assigned to NOW and then set the datetimefields to this SetNow variable. Then when I collect the distinct datetime I am assuming they will have the same values recorded incircdate, but no, they are off by several seconds. Makes no sense to meat all. I tried renaming the variable several times but it makes nodifference at all.any help appreciated, thanks.

View Replies !   View Related
DateTime Datatype, How To Display Just Date, Not Time
I have a column with DateTime Datatype. But I want to display just Date , not time.
Like 4/26/2006  not 4/26/2006 9:25:55AM
pls help

View Replies !   View Related
Convert Datetime Field To Display Date
I have a field that I would like to only display the date as mm/dd/yyyy.  Current field shows mm/dd/yyyy hh:mm:ss AM.

View Replies !   View Related
Display Just The Month Of The Date Parameter
 

Hello,
 
My report has a parameter called ToDate.  Say the user enters 01/29/2008.   How do I display this in the header:
 
Year to Date Jan 2008.   ????
 
Is there a month and year function that I could use to extract the three letter month and the 4 number date?
 
Thanks!

View Replies !   View Related
Display Date Hierarchy Parameter List
 

I have a parameter consisting of a Year-Month hierarchy.  The drop down parameter list appears as:
 
2007
  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
2008
  1
 
I have two questions:

Can I get the month names to appear instead of number?
 
When the parameter is selected the Parameters!DateShippedYearMonth.Label displays the month ONLY.  How can I see the Year AND Month that was selected?
 
 
Thanks.

View Replies !   View Related
Text Field To Display Date Parameter Chosen
Hi,

I'm attempting to use the following code to display either 'All' or the date value selected by the user from a Report parameter;

=iif(Parameters!FromCheckOutDateDate.Value.ToString = "[Check Out Date].[Date].[All]", "All", "From Date: " + Parameters!FromCheckOutDateDate.Value.ToString.Substring(26,10))

This is throwing an error ('#Error').

I can use the following code with no error, though its not as useful;

=iif(Parameters!FromCheckOutDateDate.Value.ToString = "[Check Out Date].[Date].[All]", "All", "Not all")

I can even use this to display the selected value (i.e. 2007-01-01);

Parameters!FromCheckOutDateDate.Value.ToString.Substring(26,10)

Why can't I use them both in my iif statement?

Can someone please help?

View Replies !   View Related
Default Parameter Value Is No Longer Part Of Cascading Parameter In SSRS 2005?
Hi,

I need "conditional" cascading parameters: In Report Manager when one changes parameter 1, parameter 2 get changed based on parameter 1.  Optionally, one can also enter values to parameter 2 directly.

I was able to achieve this in SSRS 2000 (SP2) with the following setups.  SSRS 2005 and SP1 no longer works - Parameter 2 always shows its default value regardless whether one select a value in Parameter 1 or not.

Parameter 1
  available values: from query
  default values: non query (specify a value "<None>")
Parameter 2
  available values: Non query (no value specified)
  default values: from query (based on Parameter 1)

It seems to me that the default value in SSRS 2000 is considered as cascading parameter.  But it is no longer the case in SSRS 2005.

Is this a SSRS 2005 bug?  is there any other work arounds or suggestions?

Thanks.

Kong

View Replies !   View Related
Display First Part Of Data In Database
I have a tabe in my sql server 2005 database which contains a long description and I want to display the first 100 charactors  on my web page but not sure how to do this I can only display the whole description. I'm not sure if I need to write the query to the database so it only brings the first 100 charactors back or query the whole description and then take the first 100 charactors in asp.net and display that can any one help

View Replies !   View Related
How To Test The Time Part Of A DateTime Field
 

Dear all,
 
I have an application where I need to implement a Team Shift management.
 
The team shift table need to be defined as follow :
 
Shift table
=========
 
Id             DateTime       IsCurrent
1              08:00:00              True
2              16:00:00              False
3              00:00:00              False

 
From the table above the current running shift is Id = 1
 
Based on that I have following question:
 
1 - Is there a way to specified for a DateTime field that it will recieved only Time part ?
 
2 -  When a shift change occurs, I need to compare the Current time with the time shift in the table. Then according to that I set the IsCurrent flag to proper new Shift ID.. how to perform this ?
 
Thnaks for your help
regards
serge

View Replies !   View Related
Compare Only Month And Year Part In Datetime Type
hai friends,
iam doing a project in .net and using sql server.
i need to compare only month and year part in datetime type to retrive data.
1)retrive unique year and its months available in the database.
like may 2008
apr 2008
mar 2007

View Replies !   View Related
Weird Millisecond Part Of Datetime Data In SQL Server 2000
Execute following T-SQL within Queary Analyzer of SQL Server 2000:=======================================DECLARE @dTest DATETIMESET @dTest='2001-1-1 1:1:1:991'SELECT @dTestSET @dTest='2001-1-1 1:1:1:997'SELECT @dTestSET @dTest='2001-1-1 1:1:1:999'SELECT @dTest=======================================You get what?This is my result which is weird:2001-01-01 01:01:01.9902001-01-01 01:01:01.9972001-01-01 01:01:02.000Then what's the reason of this weird problem?

View Replies !   View Related
How To Take Off The Time Part Of The Parameter
Hello,

How can I display data that only compare the date part (ignoring the time part) between the value of the date parameter and the database?.  It displays data only if I pass the whole date (date and time)

I tried with the following query in the report services 2000, but it even didn't pass the query parse

SELECT     *  FROM table

WHERE     (CONVERT(CHAR(8), table.PRODUCTION_DATE, 112)
                      = CONVERT(CHAR(8), @parameterDate, 112))

 

Any ideas will be appreciated.

Thanks,

Marco


 

View Replies !   View Related
Date Part Of Date Time
SELECT ltrim(str(datepart(yyyy,getdate()))) +'-'+
replicate('0',2-len(ltrim(str(datepart(mm,getdate())))))+ltrim(str (datepart(mm,getdate())))+'-' +replicate('0',2-len(ltrim(str(datepart(dd,getdate())))))
+ltrim(str(datepart(dd,getdate())))

This is how i am getting datepart of datetime.Is there any other way to get the date and also time seperately..

Thanks.

View Replies !   View Related
How To Select The Date Part Of A Date
I use smalldatetime for a datetime and i just display the date part
i'd like to compare the date part of the smalldatetime and the date i have
how can i do that ?
I know we can select the day,month or year ...
If you know a link where i could find different kinds of example about sql command it would be great to

thanks

View Replies !   View Related
All Datetime Values Display As 12/30/99
Every date that I retrieve from my sql7 database displays as 12/30/99 in my .asp pages. This is currently how I'm retrieving the date.

<%=FormatDateTime(cdate(MyDate), 2)%>

When I tried to simply display the date value itself, that didn't work either, though I know all records have a valid date value in this field. Any suggestions?

Thanks.

View Replies !   View Related
Dynamic Query: Using Parameter As A Part Of Table Name (possible?)
 
I have 2 tables (table1KKK, table2KKK), and want to run the same query on them by using parameter with the value "1" or "2".
Is it possible to use that parameter as a part of the queried table name?
Something like (only for demonstration €“ doesn€™t work):
Select *
From table +myParameter + kkk
Thanks in advance!

View Replies !   View Related
Date Part
Hi,

i am trying to write a query the pulls out a table which has date information stored as dd/mm/yyy but all i want is the month and the year.

So i tried

select datepart(mm, dtinsertdate)
from incident

which only gives me month and also used

select datepart(year,dtinsertdate) [year], datepart(month, dtinsertdate)[month],

Which works but i want both in the same column.

But when trying to get both mm, yyyy it looks like it only supports one datepart. Is there any way aroung this?

Many Thanks

John

View Replies !   View Related
Part Date In Sql
Hi,

I think this is a simple question but I am just not sure how to do it right, as a newbie.

All I want to do is generate a report of company employees grouped by their date of hire.

SELECT DateOfHire, FirstName, LastName from Empls
ORDER BY DateOfHire

The only problem is that the DateOfHire displays as, e.g., '01/03/2004 12:00:00' which is not what I want.  I SIMPLY WANT TO OMIT THE TIME PART but don't know quite how to say this.  I tried several variations along this line but it causes scoping errors...

SELECT     CONVERT(Varchar(10), DateOfHire, 101) AS DOHDateOnly, FirstName, LastName, State
FROM         EMPL
GROUP BY DOHDateOnly

but this gives error

"The value expressions for the textbox ‘DateOfHire’ refers to the field ‘DOHDateOnly’.  Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope."

Which makes sense, but I don't know HOW to say the right thing to get what I want.

Any help will be greatly appreciated.  

View Replies !   View Related
How To Use Convert Date Statement In CmdInsert.Parameters.Add(&"Date&",SqlDbType.DateTime).Value = Date
HiI am using SQL 2005, VB 2005I am trying to insert a record using parameters using the following code as per MotLey suggestion and it works finestring insertSQL; insertSQL = "INSERT INTO Issue(ProjectID, TypeofEntryID, PriorityID ,Title, Area) VALUES (@ProjectID, @TypeofEntryID, @PriorityID ,@Title, @Area)"; cmdInsert SqlCommand; cmdInsert=new SqlCommand(insertSQL,conn); cmdInsert.Parameters.Add("@ProjectID",SqlDbType.Varchar).Value=ProjectID.Text; My query is how to detail with dates my previous code wasinsertSQL += "convert(datetime,'" + DateTime.Now.ToString("dd/MM/yy") + "',3), '";I tried the code below but the record doesn't save?string date = DateTime.Now.ToString("dd/MM/yy"); insertSQL = "INSERT INTO WorkFlow(IssueID, TaskID, TaskDone, Date ,StaffID) VALUES (@IDIssue, @IDTask, @TaskDone, convert(DateTime,@Date,3),@IDStaff)"; cmdInsert.Parameters.Add("IDIssue", SqlDbType.Int).Value = IDIssue.ToString();cmdInsert.Parameters.Add("IDTask",SqlDbType.Int).Value = IDTask.Text;cmdInsert.Parameters.Add("TaskDone",SqlDbType.VarChar).Value = TaskDoneTxtbox.Text;cmdInsert.Parameters.Add("Date",SqlDbType.DateTime).Value = date;cmdInsert.Parameters.Add("IDStaff",SqlDbType.Int).Value = IDStaff.Text;Could someone point to me in the right direction?Thanks in advance

View Replies !   View Related
Date Part Of Getdate
i want to use the date part of the function getdate in my sql query.
the getdate function return the current date and time. i want only the date part.
how can i do it.

View Replies !   View Related
Date As Part Of Primary Key?
I have three items which make up the primary key:
ProjectNumber, Hardware, Date

Problem: The Date is formatted with date and time, how can I add a record and use just the date?

Currently I use GetDate() in my stored proc.

Mike B

View Replies !   View Related
Searching For Only Part Of A Date
Ok, so I have a Select statement that looks like this:

Select * from FilteredOpportunity
where (OpportunityID LIKE @opportunityid)
and (Name LIKE @name)
and (CustomerIDName LIKE @customeridname)
and isNull(EstimatedCloseDate, '1900-01-01') LIKE @estimatedclosedate
and isNull(Description, '') LIKE @description
and isNull(AccountIdName, '') LIKE @AccountIDName
and isNull(ACCU_OppTypeName, '') LIKE @ACCU_OppTypeName
and isNull(SalesStageCodeName, '') LIKE @SalesStageCodeName
and isNull(ACCU_CustomerTypeName, '') LIKE @ACCU_CustomerTypeName
and (CreatedByName LIKE @CreatedByName)
and (CreatedOn LIKE @CreatedOn)
and isNull(ACCU_OppSourceName, '') LIKE @ACCU_OppSourceName
and (StateCodeName LIKE @StateCodeName)
and (StatusCodeName LIKE @StatusCodeName)

This chunk of code is used in an XML file which, once this XML is imported (using sharepoint by the way if you haven't noticed), I can then search through tables with different filters. Well, my date filter isn't working the same way as my other ones. I have a couple different date filters, but none of them work.

Before I ask my question, I only pass in one variable at a time through my code.... the rest of the variables get a default value passed to them if the user doesn't pass it. That value is simply '%'. Anyways, so the different ways a user can type in a date is by typing in the whole date, part of the date starting with the beginning of it, typing in the end of the date, or typing something within the date. For a string it's like 'Example', 'Exam%', '%ple', and '%amp% respectively. How do I accomplish this with a date?

View Replies !   View Related
Hwo Do We -- The Date Part Of --- Getdate() '+' '16:00:01'
Need some help in getting the following.. (Looking for a Expression)
 
The date part of --- getdate() '+'  '16:00:01'

 
Basically i am looking to get the records based on a DATETIME Column UPTO 4 PM Server that paricular day.

View Replies !   View Related
Formating Display Of Datetime Data Type
I simply want to exclude the time from the datetime datatype in my queries and display the date only.

Do I have to piece it together with datepart() or is there a better way?

Thanks in advance for your help.

View Replies !   View Related
Display Data In Report Grouped By Datetime
Hello,

 

I have the following situation :

I have a reportmodel where i have the a datetime value (dd/mm/yyyy hh:mms), a salespersonid , a salespersondescription, and an amountsold.

i would like to display a report where i can see per hour (start worktime is 8 am and end is 8 pm) which salesperson sells the most. the objectif of this report is to see in what period of the day the sales are highest.

 

Can anybody provide me some tips how to accomplish this.

 

Vinnie

View Replies !   View Related
Display Duration Between Two Datetime Fields In 00:00 Format
I have a requirement to display the elapsed time between two datetime fields.  What i have been able to do is datediff the dates and get the elapsed time in minutes and then i am trying to format it as HH:MM.
 
For example, an activity started on Nov 1 2007 08:00 and finished Nov 1 23:59, the elapsed time should be displayed as 15:59.
 
The other example is if the activity spans over a couple of days, it should be say 49:03.

 
I put the following code in the format of the textbox, but it only seems to work when the length of the minutes is greater than 1.
 

=IIF(Len(CStr(Fix(ReportItems!textbox11.Value/60)))= 1,

"0" + CStr(Fix(ReportItems!textbox11.Value/60)),

CStr(Fix(ReportItems!textbox11.Value/60)))

+ ":"

+ IIF(Len(CStr(Fix(ReportItems!textbox11.Value Mod 60)))= 1,

"0" + CStr(Fix(ReportItems!textbox11.Value Mod 60)),

CStr(Fix(ReportItems!textbox11.Value Mod 60)))

 
Have i missed something really simple or what?  Any help would be much appreciated.
 
Alternatively, if you have a better way of doing the whole thing would like to hear from you.
 
Thanks in advance.

View Replies !   View Related
How Do I Return Results Using An Entire Column As Part Of The Search Parameter
Hi, Could you tell me if this is possible? How do I return results using an entire column as part of the search parameter? I need to do this in the sql rather than selecting the contents and iterating through it as it would take too long.

eg.
CREATE TABLE [dbo].[tPopupKeywords](
[id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[title] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[description] [nvarchar](2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]


INSERT INTO dbo.tPopupKeywords(title, description)
SELECT 'check', 'desc' UNION ALL
SELECT 'for', 'desc' UNION ALL
SELECT 'keywords', 'desc'


select dbo.tpopupkeywords.title
where 'This is an example of a passed in string to check if any keywords are returned.'
LIKE '% ' + dbo.tpopupkeywords.title + ' %' --Does this bit need to do a select??

expected results.....:

check
keywords

View Replies !   View Related
Date Ranges Using Only Month And Day Part
We have some seasonal products that we would like to turn on and off automatically on our website.  To accomplish this, we've added StartDate and EndDate fields to the product table.  See simplified table:
--------------Simple Table:--------------ID int identity (PK)Value varchar(50)StartDate datetimeEndDate datetime
Normally I could just do something like SELECT ID, Value FROM PRODUCTS WHERE StartDate <= @MyDate AND EndDate >= @MyDate
The catch is that we want to ignore the year part of the dates so that we don't have to go back through and update all the records every year.  I'm pretty sure I've done this in the past, but I'm having a brain fart right now and can't remember how.  One of the issues is that the start month could be > the end month (e.g. - October 15 - January 1).  Using code in the application I could work around this (see below), but I would like to handle this in SQL if possible so I don't have to return more records than are needed and weed out the bad records.
'dtStart and dtEnd are Date Objects, StartDate and EndDate are strings containing the MM/DD partIf dtStart.CompareTo(dtEnd) > 0 And dtStart.CompareTo(myDate) < 0 Then    dtEnd = Date.Parse(EndDate & "/" & (myDate.Year + 1))ElseIf dtStart.CompareTo(dtEnd) > 0 And dtStart.CompareTo(objDate) > 0 Then    dtStart = Date.Parse(StartDate & "/" & (myDate.Year - 1))End If
I appreciate any help you can provide.
Thanks,Sam

View Replies !   View Related
Best Way To Get Just Dd/mm/yyyy Part From Date Field?
I would like to know the best way of returning just the Date part (dd/mm/yyyy) of a DateTime field using T-SQL. I know that some methods mean that you lose the indexing if the field is indexed. Which is the best way to do this in T-SQL whilst preserving the indexing? I'm using SQL Server 2005.

View Replies !   View Related
Inserting Just The Time Part Of The Date?
In the code below why does it not enter 10:00 AM but instead it enters: 1900-01-01 10:00:00.000 ?

Create Table MyDateTest
(
DateColumn datetime
)

insert into MyDateTest values ('10:00 AM')
select DateColumn from MyDateTest

--PhB

View Replies !   View Related
Year Part From A Date And Time
Hi,
I have a table with field Msg_Time. In this field some records are there with date and time.

For eg:-
11/7/2006 2:35:00 AM,
11/1/2006 2:35:00 AM,
10/15/2006 2:35:00 AM,
11/7/2005 2:35:00 AM,
11/7/2005 2:35:00 AM,
8/26/2005 2:35:00 AM,
3/2/2005 2:35:00 AM etc

I wrote the query like this
"select datepart(year, Msg_Time) from C20_Messages"
This query result is:-
2006
2006
2006
2005
2005
2005
2005
Here I want to get only the year part without repeating.
I mean
2005
2006

How to do pls help me
with regards
shaji

View Replies !   View Related
Date Part Returns Too May Week 53
There should be only 52 weeks in a year unless there is a leep week(these should not happen on back to back years).
What is going wrong?
 
SET DATEFIRST 7

select DatePart(Week, 'Dec 29, 1998'), 'Dec 29, 1998'

union

select DatePart(Week, 'Dec 27, 1999'), 'Dec 27, 1999'

union

select DatePart(Week, 'Dec 24, 2000'), 'Dec 24, 2000'

 






week of year
date

53
24-Dec-00

53
27-Dec-99

53
29-Dec-98

 
In my database the following dates have all been assigned to week 53








Year
Month
Day

1985
12
30

1985
12
31

1986
12
30

1986
12
31

1987
12
28

1987
12
29

1987
12
30

1987
12
31

1988
12
27

1988
12
28

1988
12
29

1988
12
30

1989
12
31

1990
12
31

1991
12
30

1991
12
31

1992
12
28

1992
12
29

1992
12
30

1993
12
27

1993
12
28

1993
12
29

1993
12
30

1994
12
27

1994
12
28

View Replies !   View Related
Matrix Grouped By Day Part And Date
I am wondering has anybody ever created a Matrix in a report grouped by Day Part (10-2 Morn, 2-6 Aft, 6-10 Eve etc) and Date?

I would like to see a report with an output such as

                       13/02/2006                                       14/02/2006                                 Total
                      Morn       Aft           Eve                     Morn          Aft         Eve           
Mr A                2            4              5                           2              6            2                  21  
Miss B              8            8              1                           1              4            5                  27

I have a DB table which records the datetime each time a viewer changes TV channel.  The report is a summary by user of each channel change By Day Part with Each Date
   
I can do this easily enough by just grouping on Date but now require another level of detail.

View Replies !   View Related
How To Generate A Report By Passin A Parameter Ias Part Of URL + Reporting Services 2000
Hi,
 
 I want to create a report using Reporting services 2000. I will be passing  the VendorID as a part of URL and the report should display only the info related to that Vendor. Pls give a detailed explanation.
Thanks in advance
Gaura.

View Replies !   View Related
How To Use Default Parameter Values With A Date Parameter From A Cube/Reducing Parameters
 

Hi,
 
I have parameters in my report. The user can choose the year, month and date (3 parameters).
Now I want to set default vaules for the parameters , so that the user sees the report for example for the current day without selecting the parameters. I tried to set the type of the parameters to DateTime and the default value for example for the year to "=Today().Year" . But when I execute the report an error occures . Something like : no validValue for this parameter.
 
My Attributes for the year month and date are from an Analyis Services Cube from a Server Time dimension .
Does somebody know how to make it possible to set default values for this parameters?

 
 
Other question :
 
Does somebody know how I can reduce the values for a parameter. For Example I have a parameter "year" from a server time dimension from a cube. The values which are available are "Year 2004", "Year 2005", "Year 2006", "Year 2007".
But I want that the user only can choose "Year 2006" or "Year 2007" ant not every Year or "All".
Or Other Example: The User should only choose a Date that is int the past or Today but not a Date in the future.
 
 
Thanks !
 
JF

View Replies !   View Related
How To Display Parameter On The Report
I am trying to display a report parameter value in the report body, but when I run the report it is displaying the actual dimensional value [Product].[Category]&1 instead of the value that user has selected "Bikes". The report is built on Analysis Service data mart.

 

Environment: SQL Server 2005 - Analysis Services & Reporting Services.

 

How would I fix this issue?
 
Thanks

View Replies !   View Related
Display Multi Value Parameter LABEL
Hello.
I have a multi value parameter in my report.
I want to know how can I display all of the selected values in this parameter in a text box.
Whan I try to use this parameter in a textBox it automaticly take the value:
Parameter.param.Value(0) Whice take only the first select value.

Is there a simple way of doing it?

Thanks.

View Replies !   View Related
Baffled Trying To Display A Parameter Label
 

I have two parameters: year and month.  The Month parameter includes All, 1, 2, ect..
 
I tried to display the parameter slected with the following expression:
 

=IIf(Parameters!DateShippedMonth.Label="All",Parameters!DateShippedMonth.Label,

MonthName(Parameters!DateShippedMonth.Label)) & ", " & Parameters!DateShippedYear.Label

 
 
I want it to either display the label (All) or the name of the month.  I get an error when All is the parameter selected but not when any month is selected.  If I removed the MonthName() function, I don't get an error but I also don't get the month name.
 
Any ideas?

View Replies !   View Related
How To Display Arabic Parameter Value In A Text Box
Dear sir

Could you please help me

I send a parameter using url


http://localhost/ReportServer?%2finves_report%2fget_plan&rc:Parameters=false&p_name=hanan

and in text box expression ,I write =parameters!p_name.value

when I send english parameter ,so it displayed very well , but when I send arabic parameter,so it display a null value

Thank you very much

best regards

View Replies !   View Related
Parameter Display Box In Report Server
When I open a report in Report Server it opens up with the parameter area open, showing available paramater lists.
 
However when I call the same report from another report the parameter area is closed.  I would like the default behavior to be the same - an open parameter display area.
 
Is this possible?
 
Thanks.

View Replies !   View Related
SSRS Date Parameter - Showing Date Format On Right Hand Side
I am having report parameter end date I am showing the default value "5/21/2007 11:59:59 PM" in the end date paramter. And also I want to show date time format "(MM/DD/YYYY HH:MMS)" in the right hand side of the parameter. How to do this?

 

Thank You

View Replies !   View Related
Deploy Parameter List Display Position
 

In SSRS while deploying how can we make the parameter list to be deployed at the top instead of the right side of the page.   In short can we have control where the parameter list is displayed. 
 
Thanks,
Reeturaj

View Replies !   View Related
Dynamically Display/hide The Parameter Input
I have a handful of reports that are currently used by sales reps, and I'm trying to make them available to their regional VP's, and coporate users (executives and administrative staff that support Sales nationwide).

 

Currently, the reports take the UserID and resolve it to show the information that is only appropriate for that specific rep.

 

What I would like to do is have the parameter section at the top of the report be displayed for higher level users, so they could select an individual sales rep from a drop-down. (Ideally, the RVP's would only be able to select from reps in their region, but the corporate users would be able to select any rep.) The problem is, I don't want any of the sales reps to be able to select a rep other than themselves, for obvious reasons.

 

Is there a way to have the parameter section hidden/displayed dynamically, based on the UserID, so that users other than reps would have the ability to enter the desired rep name, but reps would not?

View Replies !   View Related
Want To Display Report Without Header/parameter Section
Hi all,
 
I'm trying to embed a report into a CRM IFrame. So I have the report created in Business Intelligence Visual Studio 2005, but I need to display it with none of the header details SRS displays by default.
 
Using the following URL I included rc:toolbar=false and rcarameters=false but they don't seem to make any difference. I basically need to display the report content as if it were part of that page and not an SRS hosted page.
 
https://server/Reports/Pages/Report.aspx?ItemPath=%2fAllpress_MSCRM%2fCustomReportsForCRM%2fa&rs:Command=Render&rc:toolbar=false&&rcarameters=false&rs:ClearSession=true&type=1&typename=account&orgname=Allpress&userlcid=1033&orglcid=1033
 
Anyone have some pointers for me?

View Replies !   View Related
Want To Display Report Without Header/parameter Section
Hi all,
 
I'm trying to embed a report into a CRM IFrame. So I have the report created in Business Intelligence Visual Studio 2005, but I need to display it with none of the header details SRS displays by default.
 
Using the following URL I included rc:toolbar=false and rcarameters=false but they don't seem to make any difference. I basically need to display the report content as if it were part of that page and not an SRS hosted page.
 
https://server/Reports/Pages/Report.aspx?ItemPath=%2fAllpress_MSCRM%2fCustomReportsForCRM%2fa&rs:Command=Render&rc:toolbar=false&&rcarameters=false&rs:ClearSession=true&type=1&typename=account&orgname=Allpress&userlcid=1033&orglcid=1033
 
Anyone have some pointers for me?

 
Kia

View Replies !   View Related
Local Report - How To Display Parameter In ReportViewer
 

Hi All,
I have configured the ReportParameter as following, but it is not visible on RunTime ? Any idea why ?
 
 

LocalReport oLocalReport = ReportViewer.LocalReport;

List<ReportParameter> oParmList = new List<ReportParameter>();

String sResidentID = "";

sResidentID = "RES100";

ReportParameter oReportParameter = new ReportParameter("ResidentID",sResidentID, true);

oParmList.Add(oReportParameter);

oLocalReport.SetParameters(oParmList);
 
Appreciate any help,

View Replies !   View Related
Date Display
I have a table in SQL Server 2000 with have date/time columns anddisplays the dates as : 1900-01-01 00:00:00.000 which is fine, but whenI select the column through dreamweaver for an asp page to date isshortened to 1900-01-01 but I need to see the whole date / time fieldfor conversion purposes.Can anyone help ?Thanks in advance.

View Replies !   View Related
Display Date
How would I display just the date in the dataset if I have the data with date and time like this 2007-05-02 07:14:48.000
I want to truncate/or something to the time and just display the date. How would I change my query.

SELECT usr_end_date,date_exp,usr_last_name, usr_first_name, usr_login,employeeid, displayname
FROM [OIM_FIX].[dbo].[OIM_USR] a, CORP_EMP_IDs b
WHERE USR_login = CAST(b.employeeid AS varchar)and
usr_end_date <> date_exp

currently it is returning the full date and time like this
2007-05-02 07:14:48.000
I want just the date like this 2007-05-02

I am using sql server 2005

Thanks,
Maachie

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved