Search results for query: *

Hi, Thank you for the reply but, I had already set the format of the date to be 1/1/14 00:00 before I exported the report . Can you please help me ? Thank you

Hi All: I’m having problem with date being shrunk in excel displaying out as (#########) when I export the report from crystal report to excel using Data Only format . The can grow option is disabled. How do I expand the field enough so that the user need not double click on the column header...

Thank you Ken I did the same as you had suggested , but I want it to show dateand time as 6:00 AM to 6:00 AM next day. It is showing currect date and time like 11/05/2013 12:38:35 PM and 11/04/2013 12:38:35 PM. Can you please let me know how to do ? Thank you for all the help.

Thank you for the reply Ken. But, it did not work fro me . Can you please explain me in detailed as this is urgent. Thank you,

Hi, I’ve a report that picks up orders between yesterday 6:00 AM to today 6:00 AM. The problem I‘m having is when I don’t have any orders between this time period in the crystal report it is not displaying the time ie ; the fromdate and todate. How do I make sure that though I have zero orders...

Dear All: We have a crystal report where I need to suppress the group header if there are no details records available. Can anybody let me know how do I do it ? Thank you for the help...

Hi all, I have a stored procedure written in sql server 2008 @Fromdate and @ToDate which are variables in the stored preocedure. The SP works fine. How do i display the @Fromdate and @ToDate in the crystal report ? Below is the stored procedure that I wrote. This is extremely urgent...Thank...

Hi all, I have a stored procedure written in sql server 2008 @Fromdate and @ToDate which are variables in the stored preocedure. The SP works fine. How do i display the @Fromdate and @ToDate in the crystal report ? Below is the stored procedure that I wrote. This is extremely urgent...Thank...

Hi, I've created a crystal report using the below stored procedure.I'm trying to schedule the report on the crystal report server as a weekly report. But, the report doesn't get fired off at the specified time. When I run the report manually it runs fine and I get the results. The report doesn't...

I need help with the CASE query please. My output can not have a null or blank value. It has to have a value like ‘NVD’ or ‘N/A’ anything except NULL. For example : (Select top 1 case when ISNULL (Neonate.Vacuum_Extraction ,'0' ) = 'true' then 'VC' when ISNULL...

I need a query that will check the expression and if true puts the expression in the alias. If the expression is not true put text ‘N/A’ in the alias. Last because of null and blank values I need the alias to have a text value of ‘N/N’ if the two above conditions are not met. This is in CASE...

Message Preview Hi, I have created a query that is returning three different outputs, expected,fixed and NULL. The problem that I’m facing is when I’m using Temp table #ANTYPE', this is where I am checking for condition A ('Anesthesia_Type!Anesthesia_Post_Note')if met pass A...

I have created a bunch of reports in MS Visual Studio 2005 and they run fine when I connect through VS. However when I deploy them (along with the same datasource) to my local Sql Server Reporting Server instances and try and run them I get the following error: * An error has occurred during...

How do you identify the Oracle instance?. Below is the TNSNames.Ora file. Is there anything else that needs to be added ? P485.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = 135.2.XXX.XXX)(Port = 1529)) ) (CONNECT_DATA = (SID = P485)...

I have created a bunch of reports in MS Visual Studio 2005 and they run fine when I connect through VS. However when I deploy them (along with the same datasource) to my local Sql Server Reporting Server instances and try and run them I get the following error: * An error has occurred during...

I tried even removing the quotes. Nothing seems to work. Any clue ...............to resolve it ?

I've created a package in SSIS 2005 using SSIS Import Export Wizard. The source is Sql Server 2005, destination is Microsoft Provider for Oracle(MSDAORA.1). The package is created successfully but,when ever I execute I keep getting the error mentioned below. SSIS package "Package7.dtsx"...

I created a linked server using Microsoft OLE DB Provider for Oracle. I created an inner join query in Sql Server Management Studio. The inner join query works without the date selection parameter but, when I use the date selection parameter it throws an error Msg 102, Level 15, State 1, Line...

This is regarding new redesigning project of custom critical reporting application. The new proposed new design will be using MS SQL Server 2005 as database and web reporting tool. In turn SQL Server will be getting data from Oracle 10G server. Overall Project Scope: Develop new reporting...

I'm facing a strange exporting issue to MS-Excel 2003 using MS-Access 2000.I've a report developed using MS-Access.For some strange reason when ever I export the report which does have account numbers 0000E49921,0000E10563,0000E94230 it is not displaying these numbers to excel 2003 instead it...