Search results for query: *

This is a difficult issue to show in words. (Crystal 8.5) A report has three groups with the 'page n of m' on the page footer. Group #1 Footer is set to Free Form Placement, Suppress, New Page After, Reset Page Number After and Keep Together. We are underlaying Group Header #2 to Group...

Is there a way to test each line in a detail section to see if one field is suppressed and then count the name. In the below example, I selected the field setting of 'suppress if duplicated' for the name. Can I test if the name text suppression is 1 or 0 for true or false? I can then sum the...

I wish to create a unique column in a sybase table that currently contains 7 million rows. I also want future row inserts to have similar uniqueness when inserted using a cursor in a stored proc. The table will need to have a column added to it. It was suggested that the problem could be...

I am looking at the possibility of purchasing a copy of Crystal reports. My home is about an hour from work and I hate working weekends or late into the night as I am sure many do. An alternative would be to purchase a copy of Crystal and port work back and forth to my home. Living in the...

I have a line chart where I have counts for each month. I am pulling records from an Access database. I am figuring the time service from submit to issue date. I get the months as follows: IF Month (Issued Date}) = 2 Then "Feb" and so forth. I break the chart on @Month which I also group...

I have a business contact who posed the following question. Once the report has drilled down to the last section, which contains the detail, can the records be sorted by clicking the column title? I believe he would like a feature similar to a grid sort option available in Visual Basic, Excel...

I have the following code: ls *.bat | wc -l What this does is to count the number of files in the home directory that have the 'bat' extension. I want to run an IF statement off the result. I want to place the results (in this case 5) into the variable but can't quite accomplish it. I can...

I have a table which may have multiple records for each person. Roughly speaking the table has: name code start_date end_date class Bob 1234 20000101 20001231 P Bob 1234 20010101 20011231 M Bob 1234 20020101 20020604 C Bob 1234 20020604...

I have a table which may have multiple records for each person. Roughly speaking the table has: name code start_date end_date class Bob 1234 20000101 20001231 P Bob 1234 20010101 20011231 M Bob 1234 20020101 20020604 C Bob 1234 20020604...

I have a multi-page report where the data is grouped. I also force 'keep groups together', repeat group header on each page', 'new page after group' and 'reset page number after'. When the report is printed, it prints on both sides of the paper. These reports can contain hundreds to thousands...

Here is the layout.... I have hundreds of tables that have hundreds of stored procs attached to them. I will be entering records into the various tables which are deemed sensitive. In other words, I do not want any existing procs or users to be able to access the data. I am not permitted to...

I am concatenating the following files: copy a_test.txt + b_test.dat = done_testing.txt a_test has simple notepad text characters b_test has @pRECTYPE="LEOF" as its only text The resulting file looks like this: adata stuff @pRECTYPE="LEOF"  Note the paragraph mark at...

I am concatenating the following files: copy a_test.txt + b_test.dat = done_testing.txt a_test has simple notepad text characters b_test has @pRECTYPE="LEOF" as its only text The resulting file looks like this: adata stuff @pRECTYPE="LEOF"  Note the paragraph mark at...

The last place I worked the DBA said that using the Begin and Commit transactions when selecting into #temp tables helped speed execution of the proc. Therefore it became a standard to do so. I presently work for a company that says it does nothing since, which is rightly noted, #temp tables...

I have a stored proc that resides at a location named business_istestxc.dbo.A1 of a particular server. The proc in question pulls data from tables on A1 (mostly) but must also go out to business_test and pull data from tables B2 and C3. Since the proc resides on A1, the path to tables B2 and...

Is there a way to find a timestamp on each row of a table if the DBA did NOT create a timestamp column. Specifically, I want to know if a row was updated since my last read. Thanks in advance