Search results for query: *

I have created a blank db table in Microsoft SQL Management Studio 2005 and I have all the data in an excel file (Excel 2007). Is there a simple way to import the data from excel into my newly created table? Can I do an insert into?

Is there a way to something like this in a join? case when a.refno is null then b.refno > tmp.refno else a.refno > b.refno I need this to be in the join. Can this be done? Thanks in advance

I have an excel workbook that has multiple worksheets. When I open the workbook I always want a range to be cleared for example: Range("A6:E300").Select Selection.Clear Also once I click on Refresh All to refresh each worksheet (each worksheet runs a query) I want each column in each worksheet...

I have the following Union in SQL Server 2005: SELECT c_num, bA_id AS b_id FROM tblA UNION SELECT c_num, bB_id AS b_id FROM tblB WHERE (b_id = '999') I keep getting the following error: Invalid column name 'b_id'. Any ideas what I have done wrong?

I am using crystal XI. I have two fields {tblA.year} and {tblA.period}. They are both strings. I want to concatenate these strings like so: {tblA.year} & '/' & {tblA.period} and say call this field {@Period} Then I need to have something like so in the rpt selection formula: {@Period} >=...

I am using crystal XI. In the report I am only displaying data in the group footer. However this section can be suppressed depending on the results. I have a formula for this section in the suppress tab in the section expert. When I run the report it may bring back 100 records but all may be...

I am using crystal XI. I have a parameter field that prompts the user to enter a date. Using this date I want to display the month and year that they have chosen in the following format:- e.g. they chose 12/12/07 I would want to display December 2007. How do I create a formula that achieves...

I am using crystal xi. I have a date parameter and say i enter 02/08/07 then I want to display all sales for that week(Mon 30/07/05 - Sun 05/08/07)and not just the day (02/08/07). How can I get the report to display the full weeks data?

I am using crystal XI. I have the details section suppressed if the following occurrs: ( {tblA.Name}<>next({tblA.Name}) and {tblA.Name}<>previous({tblA.Name}) ) or ( {tblA.number}=next({tblA.number}) or {tblA.number}=previous({tblA.number}) ) My problem is I need to also suppress the first...

I have the following date formula: minimum({tblA.date}) & ' - ' & maximum({tblA.date}) This is currently displaying data like so: 01/01/2007 - 30/06/2007 How can I make the field display like so: 01/01/07 - 30/06/07 By making year yy instead of yyyy?

I am using crystal 8.5. I have created a simple report that looks at Microsoft SQL Server (a sql 2000 database). This report works ok on my pc (developer) but when I try to preview the report on a client's pc using our in house app I get the following error: 20599 Cannot open sql server Does...

I am using crystal 8.5. I simply want to remove the thousand separator from a group name field that appears in a formula. Here’s what I currently have: If X=Y then ‘***’ + (ToText(GroupName ({tblA.ID}),0,"")) + ‘***’ else (ToText(GroupName ({tblA.ID}),0,"")) I keep getting the following...

Here's what I currently have: ServerA, dbA, spTestA ServerB, dbB, spTestB The spTestA looks at a table called tblA and the spTestB looks at a table called tblB. In spTestA I want to set the field tblA.Notes as an output variable and send this to spTestB on the linked server (ServerB). Once in...

Using TSQL I have a simple select statement(see below). SELECT tblA.EmpID, tblA.Address FROM tblA The address field has data that is all in uppercase like so: 10 NEW ROAD However, I want the data to appear like so: 10 New Road How is this possible to always capitalize the 1st letter...

Here’s what I currently have in the msi file: Atl.dll Craxdrt.dll Crqe.dll Crviewer.dll Msvcp60.dll Msvcrt.dll Riched20.dll Ufmanager.dll CrystalReports_RDC_DesignTime.msm CrystalReports_RDC_License.msm CrystalReports_RDC_Reportengine.msm CrystalReports_RDC_Runtime.msm When I try to deploy...

Does anyone know what dll’s and merge modules I need to include in windows installer to deploy Crystal XI on a user’s pc? I have the full version of Crystal XI developer edition installed on my pc and I have a created a simple report that I want to run on another users pc in our building. What...

I have two tables tblA and tblB. tblA contains the following fields: Period, StartDate, EndDate tblB contains the following fields: ID, Amount, ReceivedDate As you can see there is no way of linking these two tables but what I need is to prompt the user to enter a Startdate and Enddate...

I am using crystal 8.5. I have copied the enclosed DLL file to your \WINDOWS\CRYSTAL directory as I am using it on my local (developer) machine. As i need to distributing this file for use with a compiled report or application, I have also copied the file to your client's \WINDOWS\SYSTEM...

I am using crystal version 8.5. The readme file that comes with uflcaps says: Copy the enclosed DLL file to your \WINDOWS\CRYSTAL directory if you are using it on your local (developer) machine. If you are distributing this file for use with a compiled report or application, the DLL file...

I currently have a @StartDate and @EndDate parameters that prompt the user to enter dates like so 01/01/07. Here is the code below: ( @StartDate varchar(10), @EndDate varchar(10) ) SELECT tblA.ID, tblA.Date FROM tblA WHERE (CONVERT(DATETIME, CONVERT(VARCHAR(10), tblA.Date, 103))...