Search results for query: *

Hi all, I am trying to schedule a Desktop Intelligence report in InfoView through scheduler XI 2.0, which, once it’s refreshed will print the output to a printer. I have set up a printer to be the default printer to the server, but when I select the default printer or even when I put in the...

I'm going with the last suggestion until we get get the datafield cleaned. Thanks very much for your help. Fiona

Hi, I have a varchar field (DischargeDate) that I am using in a where clause. I firstly want to convert this to a DateTime datatype and then use the IsNull function on it. The syntax I'm using is: - SELECT * FROM EpisodeE WHERE Convert(DateTime,(IsNull(EpisodeE.DischargeDate,'')),101) Between...

Hi, Yes, the queries do work separately, but together I get the error mentioned above. Thanks for your reply - I really don't know where to go with this! Fiona

Hi all, I'm trying to run the following union query, and I'm getting the error "Error: Dynamic SQL Error. SQL error code = -104. Invalid command. Data type unknown. (State:HY000, Native Code: FFFFFF98)". The queries work individually, but can't see what the problem is with the union. Would...

Frederico, Thanks so much. I totally overlooked the fact that there was no relation between the outer SQL and the exists one. When I relate them, it works perfectly. Thank you also for re-working the syntax. Thanks for all other help also. Fiona

Have removed the DISTINCT - doesn't make any difference

When I run the sub-query, I get 24 records. Thanks for the tip re extracting too much from the sub-query. And thank you for your tip re joins. Unfortunately, I am relatively new at this, so the old-style joins are easier for me to follow. And I have double checked them, and that's not the...

Hi all, I have a group of tables containing containing relating to a maternity episode. Each episode (INCIDENT table) has a number of questions and answers associated with it (MAT_QUESTIONS and MAT_ANSWERS), which are identified using ID fields for each. I want to extract all those patients...

Hi, I have a group of tables that include fact tables, question and answer tables around the delivery of babies. Both the question and the answer lookup tables are relating back to the INCIDENT table via the INCIDENTID field, creating a loop. As I need to gather information on the questions and...

Hi all, I'm not sure I'm in the right forum to ask this question, so apologies in advance. We have been given access to the data behind one of our systems using COM connectivity. I have been able to access the data through Crystal (Create New Connection > COM Connectivity), but can't see a...

Thanks Nuffsaid!

Hi all, I'm not sure I'm in the right forum to ask this question, so apologies in advance. We have been given access to the data behind one of our systems using COM connectivity. I have been able to access the data through Crystal (Create New Connection > COM Connectivity), but can't see a...

Hi, I'm a beginner, so thanks in advance for helping me! I'm using SQL server database and Busobj XI R2. I have a number of date fields of type varchar, that output values in the YYYY-MM-DD HH:MM format. I want to create a report where the user prompts for a start date and an end date, and...

Had the "and" in the code...stupid me. Thanks again for your help!

Hi, I'm trying to set a tick box on a form so that, if ticked, one text box (SourceOfRequest) will be visible and a number of others invisible, and if not ticked, vice versa. The code works fine if I'm referring to just one text box (as below) :- Private Sub StatisticalRequest_AfterUpdate() If...

Hi, I'm quite a novice, so excuse what is probably a silly question! I have set up an access database, and in the "Startup" options, I have unticked all the menu options (allow full menus, allow default shortcut menus etc). I have 2 questions: (i) is it possible to have a 'Save As' or 'Export...

Hi, That worked...thanks very much. I have done a further breakdown on the example given. Select Specialty_Code1, Consultant_Code, AdmissionDate AdmDate, 'Admission' as datetype, EpisodeNum, lower(Description) Specialty, Daycase,PatientStatus_Code, Discharge_Code from EpisodeI, Specialty where...

Hi, I am using Crystal Reporter V10 and a SQL Server database. I am trying to create a report in Crystal which runs off two queries. I have previously done this in Business objects. I want to show a table with a column of number of hospital admissions by specialty and consultant. This figure is...

Hi, thanks for replying to this query. The syntax I am using does not recognose the 10pm to 8am time bracket however. All attendances falling between 10pm and 8am are going into the "Other" category. Does anyone have any ideas? if {@AttendanceTime}>=time("8.00am") and...