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?

pwise thanks for your response. that's not what i'm after as: case when a.refno is null then b.refno > tmp.refno else a.refno > b.refno If a.refno is null then I want b.refno to be greater than tmp.refno. If a.refno is not null then I want a.refno to be greater than b.refno whereas the code...

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

PHV, Thanks for your reply. Bear with me I'm new to VBA. As I mentioned I've got multiple worksheets. In the 1st sheet (the sheet that is displayed when opened in excel) should I use the workbook_open_event procedure? Private Sub Workbook_Open() Sheets.Select...

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

gmmastros Yes that makes perfect sense now. Thanks a lot.

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

dgillz that seems to work perfectly. If i wanted to expand on the selection formula and say whatever day they entered (eg 02/08/07) the report would then display this weeks sales and the previous 12 weeks also. How do I modify the below is it like this...

Madawc Using your DatePart ("ww", {tblA.salesdate}) gives me 31 for the 02/08/07. How do i then sum the {tblA.salestotal} field for the week 31?

dgillz thanks for your reply. It has to be one date i'm afraid. Is there a way to do this?

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 seem to have resolved the firstrecord issue but not the lastrecord. Here's what I have done: ( Onfirstrecord or ({tblA.Name}<>next({tblA.Name}) and {tblA.Name}<>previous({tblA.Name})) ) or ( Onfirstrecord or ({tblA.number}=next({tblA.number}) or {tblA.number}=previous({tblA.number})) ) Any...

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

Madawc Worked perfectly. Many thanks!

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