Recent content by fionama

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!