Showing posts with label format. Show all posts
Showing posts with label format. Show all posts

Monday, March 19, 2012

Cant able to exprot data to excel formate

Hi,...

I ma using reproting service tools fpr my reports.

And when I export large data to excel format what i get isSERVER NOT AVALIBLE eroor.

and the same export works fine when the size of data is less.

i want to export 13-17k of rows to excel format...

and i am using 2 GB of Ram.

pls help ...

waiting for ur rply

On the client, in Internet Explorer options, try increasing the size of your Temporary Internet File setting to over 100MB and see if you continue to get the error. If not, then it is related to the size of the temp file that reporting services creates in the temporary internet files in the windows folder.

Cant "SELECT" using CREATED_DATE column...help

Ok,
What format is this to where I can't find records (that I know are
there) using this date "2005-09-29 23:58:00".
Here is the SELECT that I use that doesn't work:

SELECT * FROM RMA_HEADER
WHERE CREATED_DATE LIKE '2005-09-29%'

Any help is appreciated.
Thanks,
Trintcreate table MY_RMA_HEADER (CREATED_DATE datetime)

insert into MY_RMA_HEADER values(getdate())
insert into MY_RMA_HEADER values(dateadd(hh, -1, getdate()))
insert into MY_RMA_HEADER values(dateadd(hh, -2, getdate()))
insert into MY_RMA_HEADER values(dateadd(hh, -3, getdate()))
insert into MY_RMA_HEADER values(dateadd(hh, 1, getdate()))
insert into MY_RMA_HEADER values(dateadd(dd, 1, getdate()))

-- it will fetch data for 30th Sept. 2005
-- I have used 103 for formatting, u can use other as well, the idea is
to truncate time part
SELECT convert(datetime, convert(varchar, CREATED_DATE, 103)) FROM
MY_RMA_HEADER
WHERE convert(datetime, convert(varchar, CREATED_DATE, 103)) =
convert(datetime, '20050930' )|||On 30 Sep 2005 04:12:28 -0700, trint wrote:

>Ok,
>What format is this to where I can't find records (that I know are
>there) using this date "2005-09-29 23:58:00".
>Here is the SELECT that I use that doesn't work:
>SELECT * FROM RMA_HEADER
>WHERE CREATED_DATE LIKE '2005-09-29%'
>Any help is appreciated.
>Thanks,
>Trint

Hi Trint,

If the Created_Date is of datetime format, then use

SELECT Col1, Col2, ...-- Don't use SELECT * !!!
FROM RMA_Header
WHERE Created_Date >= '20050929'
AND Created_Date < '20050930'

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)|||>> created_date LIKE '2005-09-29%' <<

Temporal data types are not strings, so you cannot use string functions
on them.

Thursday, February 16, 2012

Cannot select CSV XML format in Export Format.

Hi,
in my report viewer export format, i only can select 2 type format. one is
pdf another one is excel.
i already check the rsreportserver.config.
the csv xml type no have set to visible false.
but i still can't see the csv and xml
could someone give me some idea to solve the problem,
thank youAre you running Express? or Workgroup ? One or both of these limits the
export types.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ng" <Ng@.discussions.microsoft.com> wrote in message
news:87BDC13A-1521-4EE2-8579-77B3361D2120@.microsoft.com...
> Hi,
> in my report viewer export format, i only can select 2 type format. one is
> pdf another one is excel.
> i already check the rsreportserver.config.
> the csv xml type no have set to visible false.
> but i still can't see the csv and xml
> could someone give me some idea to solve the problem,
> thank you
>

Tuesday, February 14, 2012

Cannot save English dates!

Hi All,

I have this dumb problem with dates in my mobile application. The problem is when saving a short date in English format ex 20/08/2006 the sql server 200 windows CE Edition display an error stating

THERE IS AN ERROR IN THE DATEPART FORMAT. [,,,Expression,,]

When changing the date in American format the problem is solved ex 08/20/2006

The problem is that I require the dates in English Format only!

Is there anyway of solving my problem ?

Thanks

Matt

Please use parameters to avoid formatting issues. If you don’t know how, please look up SqlCeParameter class on MSDN and/or search this forum.

Note: SQL CE 2.0 only supports unnamed parameters, SQL Mobile supports both named and unnamed parameters.

Sunday, February 12, 2012

Cannot retrieve data in utf-8 from php

Hi.

I have a IIS server with php3 installed. I have SQL server database
and data stored in unicode format (nvarchar fields). In header of my
php I have the meta: <meta HTTP-EQUIV="content-type"
CONTENT="text/html; charset=UTF-8">.

I have the following problem:

- I trie to do a query using ODBC (version 3.525.1022.0) and SQL
Server odbc driver (version 200.85.1022.00). The query doesn't
retrieve information in utf format and accents and extra characters
aren't showed correctly.

- I trie to di the query usin native OLE DB. I use mssql funtions and
the problem is the same.

If I install php4 and I use "new
COM("ADODB.Connection",NULL,CP_UTF8);", then it works correctly.

Anybody knows if its posible to retrieve data from sql-server in utf-8
format using php3?

I see in other postings that odbc driver only accept utf-8 in version
3.7 or higher? Is it true? If is true, where I can download odbc
driver 3.7?

Thank's in advance.
Miki.Miki (miquelpl2@.hotmail.com) writes:
> I see in other postings that odbc driver only accept utf-8 in version
> 3.7 or higher? Is it true? If is true, where I can download odbc
> driver 3.7?

First, as far as I know, the ODBC driver for SQL Server does not handle
UTF-8 at all, since SQL Server does not support UTF-8, but stores
all Unicode data as UCS-2. See http://support.microsoft.com/?id=232580.

ODBC is part of the MDAC, and with any recently new Windows machine,
you have an MDAC version which includes ODBC 3.7 or later. If you have
some old NT4 platform, you may have to look for something news.

Go to http://www.microsoft.com/downloads/...?displaylang=en,
and pick MDAC. You will have to check the versions that they support
your OS.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp