Hello,
I'm trying to format a numeric value (in seconds) to the format
h:mm:ss (hours:minutes:seconds).
Example: 89 seconds should formated as 0:01:29
The value is not a date/time value - so I'm not able to use time formatting.
Is there a solution available - any ideas?
best regards
-flyall-
Dear All,
I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2005 as a back End
i want to know how to create report using server 2005 reporting services and use in web application.
please give me some link or example .
Thanks
hi,
i am using ssrs 2005 and need to pass the multi selected parameter values to another report. how can i achieve this task? I use jump to report option.
Hi
I made some Reports with some report parameters for filteration. When I run this report, I can make all changes in look of Reports but can not change look of this parameters it looks like simple Text Boxes with lables
can we change look of this parameter text boxes ??
I have a matrix report with 2 column SaleAmount and ProfitAmounts by Month like
Sale Profit
Dealer 5/1/2007 6/1/2007 7/1/2007 5/1/2007 6/1/2007 7/1/2007
A 100 200 300 20 25 15
B 200 250 50 30 45 19
how can i do following 3 things
1)Add Total column for Sale and Average column for Profit
2)Sort report by lastMonth of Sale (here 7/1/2007) High to low
3)if last month of sale(here 7/1/2007) is less than second last month here (6/1/2007) whole row should be red
thanks
Hello! I have a query that join five tables and returns around 45000 rows that takes no more than a minute to execute, in management studio, on a SQL Server 2005, 2CPU 32 bit(dual core), 4GB and RAID5 disk system. The O/S is Windows 2003 sp2 Standard Edition.
When the same query is executed in SSRS2005, with some drilldown and summary of drilldown levels, it never stops to execute.
Looking at the hardware in the performance monitor reveals nothing strange except that % CPU-time is around 40 percent. Memory resources over 2 GB are available all the time.
Any suggestions is appreciated!
Any problems with SQL Server 2005 source database running on SQL Server 2000 compatibility level?
Thomas Ivarsson
Hello. After I have installed Sharepoint Services 3 on the same machine as SSRS2005, I have configured both SSRS2005 and Sharepoint 3. Still I do not know if I have done this correct but a SSRS webpart is available within Sharepoint.
First question. When I deploy a report project should I still deploy to http://localhost/reportserver? This is not working but I would like to confirm that this is the correct way to do it.
Last question. Anyone who can point me to a site with good information regarding this setup? SSRS2005 SP2 and Sharepoint 3?
Kind regards
Thomas Ivarsson
Hi, I'm a newbie to SSRS, and was wondering if anybody can shed light on a problem I have. I have a report which every client uses, but each client's data is held in its own database. Rather than create many reports, is it possible to create 1 report, which all can use, passing in the different datasource? I was thinking of a hidden parameter, passed by URL. Or maybe using the report viewer control in VS2005. Can anybody please help?
Thanks
Dan
I am trying to query a calendar table that has the [start] datetime of an event and then a [title] of the event. I am trying to display them as;* 8:00 AM Get to work* Independance daysome of the events have a start time and some only have a date. the ones that do not have a start time have a start time of 12:00:00 How do I query the two fields and only show the start time & title of the events that have a start time and just the title for the ones that do not have a start time.. I've tried this...select Event = (CONVERT(CHAR(8),start,8) +' ' + title) from Calendar where CONVERT(CHAR(8),start,8) <> '12:00:00'It does display the start and event title but only for the ones that have a start time. And how do I get the 8:00 AM format for the time? Thanks for any help.Mark
View 3 Replies View RelatedHi!
I have couple of questions. Anybody can help me.
1. How can I format the output in T-SQL coming like as one can do in SQL*PLUS (ORACLE)?
2. I decalerd a Cursor and using that It is generating the output. I jut want to dispaly only 100 rows, its mean that I want to control the output.
Please give your feedback
How do I get the following format using SQL server ( SQL QUERY ??)
yymmddhh.
In Oracle I can do simple...
Select to_char(datecolumn, 'YYMMDDHH') from tablename;
RESULT > 02080603
-- YEAR, MONTH, DATE, HOUR.
What is that I need to do to get the same result on sql server.?
tks
i have this:
\FILInternalBuisnessArea*.*
\FILInternalBuisnessArea
\FILInternalBuisnessArea*.qvw
\FILInternalBuisnessArea empfileDB.mdb
\FILInternalPublic Area*.*
\FILInternalPublic Area
\FILInternalPublic Area*.xls
\FILInternalPublic Areaacro*.doc
\FILInternalPublic Areaeconomi*.xls
\FILInternalPublic AreaeconomiGroup01FileToSave*.xls
\FILInternalPublic AreaeconomiGroup01Unit01FileToSave*.xls
And i want to strip away whatever is after the last '' so the output should look like this
\FILInternalBuisnessArea
\FILInternalBuisnessArea
\FILInternalBuisnessArea
\FILInternalBuisnessArea
\FILInternalPublic Area
\FILInternalPublic Area
\FILInternalPublic Area
\FILInternalPublic Area
\FILInternalPublic Areaeconomi
\FILInternalPublic AreaeconomiGroup01
\FILInternalPublic AreaeconomiGroup01unit01
datatype = varchar (500)
thx alot in advance
//Mr
Hi all,
i am using sql server 2005.
let me explain the scenario.
I have to built a report where I have to find out no of call made by an executive to a perticular customer during a year
my table record look like
empid custid product date and other field
em111 iimran aaaa 01-04-2008 ........
em111 iimran bbbb 01-04-2008 ........
em111 iimran cccc 01-04-2008 ........
em111 xxxxxx aaaa 01-04-2008 ........
em111 xxxxxx 2222 01-04-2008 ........
em111 iimran aaaa 02-04-2008 ........
em111 iimran bbbb 02-04-2008 ........
em111 iimran cccc 02-04-2008 ........
em111 xxxxxx aaaa 02-04-2008 ........
em111 xxxxxx 2222 02-04-2008 ........
.
problem is it has to implement in this manner
Srno custname jan feb mar apr may june july aug sep oct nov dec
1 iimran 0 4 0 5 6 7 0 3 5 7 3 1
please suggest some idea.
Please Help
Ok so here is an explanation of what i need. I have a table that has emails in it. I need to get those emails to show up as verticle line of names. these will then be sent out via email so i have the following line of code to put them into a string:
select @emails1 = isnull (@emails1 + '; ','' + char(13))+ char(13) + email from emaillist
I have tried putting Char(13) in multiple areas trying to get line break. but the email sends the list in a straight line.
can anyone help me. also if you need more info let me know i will give it to you.
example of desired output
xxxx@dgfasg.com
sfgasg@asgahi.com
saghna@asogh.com
hi all
can anybody tell me how to get double underline for the text box value in reporting services
am using sql server reporting services 2000
Hi all,
This expression gives me an error anyone know why?
=IIF(Fields!M.Value = 0,"Average",(MonthName(Fields!M.Value)))
Thanks
Does anyone know what code I'd use in an expression to conditionally format based on if the drill down is expanded or collapsed?
Thanks.
in an
in-an
inane
Inna
Ian
Edit...
Revert to "inan"conditionally
conditional
conditionals
conditionality
Edit...
Revert to "conditionaly"
I have a decimal time field that I would like to convert to "hh:mms"
If I try to use =cdate(Fields!Avg_Visit_Duration.Value) I get #Error in my result. The error message is:
Conversion from type 'Double' to type 'Date' is not valid.
0.0044612654 should be shown as 00:06:25. I can do this very easy in SSAS or Excel... SSRS is giving me fits.
edit: made question clearer. nlm
Hello all,
I am trying to import an excel spreadsheet that has a specific date column. The column is saved as military time. For example, one of the records is:
04-12-2007 09:30
But, when i import the data into sql 2005, the above date is displayed as:
2007-04-12 09:30
I need it to display like the same way that it's being displayed in the excel spreadsheet.
My field in sql is nvarchar(100) and it still doesn't work.
Any ideas?Thanks in advance.
Hello,
I'm using xp_sendmail in the sp and in @query I do select * from table1.
The result also page,s
The formate is not at all readable and even if @attach_results = 'TRUE'
In the text file its not formatted as it sends mail to my manager I want it to be formatted and looks good. Can anyone help me or Is there any way to get the results in readable format.
Thanks in Advance for the help
Rani
How do I format a date field to monthly and/or yearly only in order to summarize totals in another field.
View 6 Replies View RelatedHi ppl
Could someone please tell me how I could format my output to look something like this:
What I have:
Code:
customer street city telnum
---------- ---------- ---------- ----------
Ann 12 bpem there 34215
Ben 2 blim here 344365
Carl 512 crom there 34725
Dean 62 blon here 2132345
El 142 brom there 657345
Frank 71 clom here 6345215
What I would like:
NOTE: I edited this myself incase you are confused about how I got these results, not that Im calling anyone stupid, just to make clear up any possible misunderstandings
Code:
customer contact details
---------- -----------------
Ann 12 bpem
there
34215
Ben 2 blim
here
344365
Carl 512 crom
here
34725
...... etc
Thanks for taking the time with this.
Your help is always appreciated.
Justin
a number like 1,234,456.82 ?
View 13 Replies View RelatedHi
I wanted to knoe if it is possible to remove the leading and trailing spaces by using the RTrim and LTrim?
Currently I have the table Below is it possible to format all the data i.e. remove all leading and trailing spaces in the table from every record?
select *
from
(
select 'Rivet' as [Name], '01' as PartNo, '1999' as Year union all
select 'panel', '041', '1999' union all
select ' side panel', '021', '1999' union all
select 'thread ', '042', '1999'
) t
I tried looking for assistance but I cant get my formatting to work. I was pretty sure yyyy=2007 and yy=07 but its not working right.
What I am doing is using Business Intelligence to read the previous days IIS logs. The logs are labeled as ex070602.log (exyymmdd.log) The code I use to get the previous day is dateadd("d",-1,getdate())
now I want to format the yy/mm/dd but I am getting single digits for the month and day and 4 digits for the year. Can someone tell me the expression I would need to use for this. Thank you kindly guys.
Some things I tried and results I got:
datepart("yy",dateadd("dd",-1,getdate())) = 2007
year(dateadd("dd",-1,getdate())) = 2007
day(dateadd("dd",-1,getdate())) = 4
month(dateadd("dd",-1,getdate())) = 6
Thanks. I appreciate the assistance.
I am pulling several numbers from a SQL table, adding them and doingvarious calculaitons. The numbers do not display a comma to separatethousands. What is a way to format this?
View 5 Replies View RelatedHow do I change, or add to, the following code so as to be able to format the display:
this.txtAppointmentDate.DataBindings.Add(new Binding ("Text", dsData.Tables["Results"],"AppointmentDate")
The data is stored in SQL Server as datetime and I want only the date portion to show in the TextBox.
Thanks in advance
I have a Amount field which is declared as Decimal. the data for this will be somethin like this 0.152
output need it to be -
00000.1520
How can I do this?
Hi,
I have the following problem, i want the number format to appear depending on the language that the IE is on once you are using the reports on the web.
The thing is that my reports have language = default.
Format of the numbers are N0 or ###,###,###
The result is
123,234,456 with pt language ou en-us language, and i would like to be 123.234.456 in pt and 123,234,456 on en.
What am i doing wrong?
Thank you
Hi,
i have create a Report withe a table. In this Table i have History-data of a tabel from my database. When a value in a field was change between the actual row and the row before, i want to change the color of the chaged value.
For Example:
Server Customer Serial # Location
DC1 Company 123 123abc RZ9 / AB12
DC1 Company 123 456abc RZ9 / AB12
DC1 Company abc 456abc RZ9 / AB12
Who has an idea to resolve this problem?
Thanks and regards,
Eberhard Droege
Hello,
I have the following question.
I have a report where i do a lot of time calculation
in one colomn i have values in seconds.
for example i have a total of 246 seconds
how can i format this to view as 00:04:06 or even 4 mins 6 secs
Vincent
Does anyone know if this can be done? I've looked everywhere. This is how my info is appearing in an email...
These are the files I requested and this is how it's being displayed. Any suggestions? Requestor
Requested Shipped
Due
------------------------------------------------------------------------------
-----------------------------------------------------------------------
-----------------------------------------------------------------------
-----------------------------------
-----------------------------------------------------------------------
---- ------------------------------ ------------------------------
------------------------------
Approaching the Corporate Heart
klm@yahoo.com
02/07/2008 02/07/2008
02/06/2008
PASSION FOR CUSTOMERS 3 copies
Nina.Childress@ssa.gov
I have the information below
PRINT REPLACE(REPLACE(CONVERT(varchar(50), GetDate()), ' ', ''), ':', '')
What I would Like to do is run the query above and get date of this type '2003-05-08 12:35:29.998' returned as '20030508123529998'
I know GetDate does not even come up with date in the first format so I need to know which way to get it in the first format so that I can run the query and get the second format string returned to me. Thanks in Advance