Search results for query: *

I'm using Crystal Reports XI with SQL Server 2000. I have the following scenario. If a patient has a discharge date of 03/15/2009, I only want to choose records for the patient for only the 1st service date AFTER the discharge date. For instance a patient has the following records: DISCHARGE...

Hello All. I have a report that contains 1 subreport. The main report is grouped by timezone with all details showing. The timezone group footer contains information for the specific time zone such as: number of customers, number of accounts, amount owed, and amount collected. The subreport...

Good morning, I’m trying to create a cross tab report that will have a column heading related to a date field in database. The rows of the crosstab will be a grouping of agency names. For each agency name, for each month/year combination, there is a paid value. My problem is I do not know...

Good Afternoon, I'm trying to create a selection formula that will select records for the previous week. However, the week should start on a Friday and end on a Thursday. In addition, there is a small twist. The records dated the last 2 days of a month should be included in the next months...

Please bear with me on an explanation of what I’m trying to accomplish. My is very strict on the number of licenses being using for a particular application. Therefore they need reports with call statistics. This particular report is supposed to determine the maximum number of licenses used...

I’m trying to create a portion of a report that will be grouped by the name of a server. (There is no set amount of servers. It can increase decrease depending on a date range in a selection statement). Each server has 3 categories for a summation. The summary I’m utilizing is the MAX...

Local Numbervar Ras; Local Numbervar ras1; If {TABLE1.field1} = "E" then Ras := Count({TABLE1.field1}) else If {Table1.field1} = "C" then ras1 := Count({Table1.field1}) How can I display both RAS and RAS 1 from the same formula in Crystal 11?

I’m trying to write a formula that will count the number of records in a file in descending order. For instance if there are 10 records, I will have a field that looks like the following 10 9 8 7 6 5 4 3 2 1 Any ideas?

Using Crystal Reports 10. I’m trying to create a report that will group by time for each half hour. For instance, I want to show a report that has the following intervals and groups 1:00 1:30 2:00 2:30 3:00 3:30 …… This should progress for a full 24 hour period. I went into the grouping...

I’m trying to create a report that will calculate a percentage for a particular product for a particular month within a particular year. The percentage equates to the total amount paid for a month for a particular product/total balance of a particular product. I attempted this by trying a...

I have a CROSSTAB report that is comprised of Client Names for the columns (horizontal) and the month and year as rows. The only thing I’m trying to accomplish is creating a page break after each client. For instance, Client 1 should be together and when the information for Client 2 begins, it...

crystal Reports 10 SQL Server 2000 I have a report that is 3 pages for 1 record set. I only want the page header to show for the 1st page of each record. For example, I want a page headers for the following pages 1, 4, 7, 10, ....etc until the last record. How can I accomplish this. It...

I'm having another ranking issue, expect this time, I'm trying to rank on a formula field instead of a table field. Here are the facts: Database = SQL Server 2000 Crystal Reports version 10 The report uses one parameter, which is the numeric representation of the year. The report is grouped...

Good Day All, I'm using the following software programs: Crystal Reports 10 SQL Server 2000 ASP Pages that display reports with the Crystal Report Viewer Currently, we are writing ASP pages to view the crystal reports via the intranet. My question is, how do you create a drill down tree...

SQL Server 2000 Crystal Entrprise ASP Web Pages. I’m trying to accomplish the following: 1.Accept 2 string dates from input from an ASP page 2.Convert the 2 string date parameters to a date type in Crystal 3.use the 2 converted dates to evaluate records between the 2 dates. Currently, I’m...

Agency Liq Rank CREDITORS INTERCHANGE INC 1ST UNION MASTERCARD 1.34% 0 1ST UNION VISA 0.00% 0 ARBOR 1.17% 0 ARBOR MASTERCARD 1.84% 0 ARBOR VISA 0.56% 0 BANK OF AMERICA...

I am trying to create a crosstab that will have a dyamic number of column names (Bank) and a dynamic number of rows (Client). These rows and columns will be generated depending on a parameter. For example, if a specific parameter is chosen, then the crosstab should look like the following...

I have the following sample database table Client string Placeddate date Placedbalance currency I have a report have set up a report that is supposed to look like the following: Client January February Totals BOA 1000 2000 3000 Citibank 500...

I’m using SQL Server 2000 and Crystal Reports 10 PORTFOLIO CLIENTNAMEBalancePlaced 4619611.11 TotalPaid 270287.93 LiqRate X I’m trying to develop a crosstab query...

I’ve created a report that is grouped by product and date. For each product, I had to calculate the number of accounts generated on the very FIRST DATE the account was opened. I calculated this my creating a formula that used the minimum function to give me the 1st date of the account. The...