Search results for query: *

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...

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...

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'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...

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...

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...

I need help with the following : 1) I've a calculation field Average gift. No matter what I do in the format, I'm not able to get to print the decimals for the Average gift. For example Average gift on the line items needs to contain decimals (i.e $12.50 is the avg. gift for 2 gifts totaling...

Hi All, Is there a way using the report servers default Reports website is there anyway to pass the variable in the url string? If so can someone please let me know what the url would look like. All inputs are highly appreciated. Thanks,

Hi all, I'm using visual sourcegear for version control for VS2005 to create reports. I've a problem with save as a .rdl file in visual sourcegear. I tried to do save as, all it does is replace the file to a new one and I can't locate the old .rdl. Is there a way that I can have save as so...