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

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

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

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

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, 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, I am trying to create a crosstab relating to A&E attendances. The crosstab should contain a count of all A&E attendances, a count of A&E attendances where the outcome was "Admitted", and this is summarised by month of attendance. No A&E Att's No of Admissions July...

Hi,I'm using Crystal 10, and a SQL server database. I have a data field (type Varchar) containing a date and time (24H) value (attendance date and time). I would like to extract that time and create time brackets, i.e. 8am to 2pm, 2pm to 10pm and 10pm to 9am. I have created a field...

Hi, I'm using Crystal 10, and a SQL server database. I need to format the text in my report to lowercase (text currently displaying in uppercase). Is there a function to do this in crystal? I know in BusinessObjects, there was an "Uppercase" and "Lowercase" function. Many thanks in advance, Fiona

Hi, I've got two columns in my Business Objects report, both containing time fields. One is 'Planned Start Time' and the other is 'Actual Start Time'. The 'Actual Start Time' field is taken from a template, so there is no actual date (just the default 30/12/1899). I want to calculate, in a...