Search results for query: *

...= 1 date = 20/5/2002 CountofThoseInContract = 3 ... based on the above date. The SQL query for this will be: select count(*) from contractTable c where date between c.startDate and c.endDate I just cant seem to find how I can generate the same measure within olap. Any help really...

Hi, Yep, but when I enter the query: UPDATE mytableview SET field2 = 1234 WHERE field1 = 5 ... in Query Analyzer, and get the error ... Server: Msg 8115, Level 16, State 2, Procedure mytrigger, Line 14 Arithmetic overflow error converting expression to data type smalldatetime. The...

...14 contains the 'UPDATE mytable SET' statement. Does the above error mean that the error is occurring directly at line 14, or somewhere within my *whole* UPDATE / SET statement? How can I interrogate the error? It doesn't look simple from the outset. I understand that smalldatetime must...

Hi, I have created a report within CR 10 that I would like to have exp[orted to a pdf document each morning via an automated process. I dont want to, each morning, manually start up CR and do a refresh, then go to file > export > pdf... Id like to have some streamline way of just creating a pdf...

Hi, I was hoping someone could help me. I have two databases that are duplicates of one another: one being the production database, and the other being the test database (the only difference is in the data they contain). When I create my reports, I build the 'Links' (via Database Expert) using...

Hi, I currently have few databases showing in Database Expert > History. Is it possible to remove certain databases from showing here? When i right-click on a database there are no 'delete/remove' options available. Any help appreciated. Cheers, Voirin

Hi, I was wondering if anyone could help me. When i go into select expert, and select a Field, then select 'is not one of' and hit the dropdown box tab, not all column variables are showing. Sometimes 1 variable is missing, other times 2 are missing. is there any way around this? Im using CR...

That did it, thanks! I needed to share variables. Thanks lbass & Madawc! cheers voirin

Hi again, I seem to have a lot of questions, and this is another! I would like to obtain a count of the number of patients in my main report. Below I have a report showing 3 distinct patients. How do I place generate this value? My 'patient' column is set to 'suppress if duplicated'. I also...

Hi, I was wondering whether it was possible to place a subreport summary in the footer of the main report? I cant quite see how to do it. Thanks! cheers, voirin

Hi, I have a main report and a subreport. They both have the same column names, and are displayed in a table. I have used the line drawing object to separate the columns with a line. How do you line up the vertical lines in the subreport to the vertical lines in the main report? Is this just a...

I managed to get around this by creating a formula field with the following: time({TIMESLOT.STARTTIME}) Then I insert this formula field in the report, group by this formula field, and suppress it. cheers, v

Thanks for the info! On a further note, I found that: File menu -> Report Options -> Convert database NULL values to default .. seem to work, however File menu -> options -> Reporting tab -> Convert database NULL values to default .. does not seem to work. Since I want this report...

...1899 9:55AM Sunday, 1 January 1899 10:30AM Sunday, 1 January 1899 10:30AM Sunday, 1 January 1899 11:10AM The system actually stores the real *date* in another column in the database. Hence the "Sunday, 1 January 1899" is bogus. Obviously this is not the best design (I'd change it if I...

Hi everyone, I managed to fix the problem (solution given by Madawc - thanks!), but I don't quite understand why it's fixed (as opposed to other solutions (e.g. MisterMo - thanks!)). The solution that works is: if not isnull({PRIMARYCODE_1.DISPLAYVALUE}) and "revoked" in...

Thanks for that! However my problem still continues... i get the following output as an example: ------------+------------ Status ProductID ------------+------------ 45 73 23 Revoked 18 Withdrawn 46...

Thanks for the reply but that's not it. The reason I have "revoked" in {PRIMARYCODE_1.DISPLAYVALUE} is that I want to determine if the string "revoked" is contained in a larger string of words, for example the string "This application is revoked". This function works fine! All I want to...

Hi, I was hoping someone could help me. I have created a formula field '@mystatus' with the following (crystal syntax): if "revoked" in {PRIMARYCODE_1.DISPLAYVALUE} then "Revoked" else if "withdrawn" in {PRIMARYCODE_1.DISPLAYVALUE} then "Withdrawn" else "OK" I have applied...

Hi I have a report that is generated in tabular form. I want to get of repeating row elements. Take for example a weekly diet plan. Each row of the report represents a row of data based on data contained between linked tables. In the examples below i am using three columns: Day of week, time...

Hi, I was hoping someone could help me... I know this has an easy solution, but it isnt obvious to me... I need to create a report that requires a table being displayed with a fixed number of columns but varying number of rows (based on the output of the report). Essentially the output of my...