Search results for query: *

Usually when I design a report I like to alternate the color of the rows so that it is easier to read. If my data is in the details I use: if remainder(recordnumber,2) <> 0 then color(235,235,235) else white If my data is in the group footer, I use: if remainder(groupnumber,2) <> 0 then...

I have a report that is very simple but when it runs, it seems to be filtering through more records than what it should. I have 4 tables, a users table, a points_history table, a location table, and a region table. They are linked as follows: SELECT users.uid, users.name, points.award_date...

Guys, I will do my best to explain my problem. I am using Crystal 11.5 and MS SQL Database. I have a report that I am wanting to use three different parameters to filter the data. I have all three set up correctly, but I have one issue with one parameter for a field called Tenant. What I want...

Guys, I have a report that is looking for a specific string pattern and I am trying to filter to pull in only records that meet that pattern. The problem is, the data is stored using the asterisk, which is also the wildcard character for Crystal Reports. For example. They are storing VIP...

I am using the formula below to convert a unix time stamp into central standard time, and account for DST. However, when I use the formula in my select criteria, like @closed_date in lastfullmonth, it takes forever to run. Is there any way to speed this up? @closed_date local datetimevar...

Hello, I need help with a string formula. What I have is a string that is a combo of First Name, Last Name Initial, a dash, and then the company name. What I need is the dash, to the end removed. Example of Data: Kraft, D - Other Fabrie J-Intel 3 Lindberg H-Unix-2-Tech Solutions Results...

Hello, I am trying to add a date range into my select criteria to pull the last 5 full weeks. I know how to pull the last five weeks in general, but I need the last 5 full weeks. So if you were to run it today it would pull in the weeks of: Jan3-Jan9 Jan10-Jan16 Jan17-Jan23 Jan24-Jan30...

I have a report that looks at the last 14 days worth of data. I have to use running totals to get my totals for each day but I am having some issues doing so. I have data from a ticketing system and I have to count how many tickets have been opened for 1 Week, 2 Weeks, 3 Weeks, 4 Weeks, 30-60...

I have a report that has two subreports inside it. Inside each subreport is a crosstab that looks at the the last 14 days of data. The crosstabs runs fine within each subreport, but when you try to run the whole report together I get "Error formatting Cross-Tab Object." Can anyone help me...

I have a string field that looks like the following values: Otbf.Srvr.Emalf.- Otbf.Srvr.Swcb.- Otbf.Srvr.Swcb.Abus1ss Otbf.Srvr.Swcb.C Acq.Tel.Tel.- What I need is from the third period, over, taken off. So the above examples would be: Otbf.Srvr.Emalf Otbf.Srvr.Swcb Otbf.Srvr.Swcb...

First, I am using Access 2003. I have two tables: Customer and Order, linked on Customer_ID. I have 2 forms: Customer Form (Parent) that is linked to the Order Form (Child). I used the wizard to link the two forms since I dont know the VBA code too well. The wizard gives me the button which...

I am using Crystal Reports 11. I have my main report that has most of my information inside it. At the bottom of my main report, I have a subreport that shows some separate data. I need to insert a second subreport at the top, and I want that subreport to show on the first page, by itself, and...

Guys, I have a group in my report called division_id that I am grouping on. I am customizing the name of the group by concatinating the leader's last name of that division and the division_id. What I want to do is have the group sort based on that customized name. I can't group on the leader's...

I am using SQL Server 2005 and have very basic SQL skills. I am creating a simple view that shows leaders of a company and then I join on a leader view to cout the number of associates that are under that leader. Each associate that reports to a particular leader has a location country. What I...

I am using Crystal Reports XI I have a parameter within my report that allows you to select multiple values. I want to be able to list those values, in a comma delimited list, somewhere in the report (probably the report header or footer). If the parameter prompts you with a list of colors to...

Is there any way to present data in an Organizational Chart (Hierarchy) in Crystal Reports XI? I know its not one of the types to choose from, but there's gotta be a way. I've created a report before where I used numerous sub reports, and hard coded some of the specific areas, but was wondering...

I have built a report that has a parameter for a date range. You enter the date range and it displays the data on the report based on that date range. But I also have a subreport that displays the same data for the last 7 days based on the currentdate. What I want to do is be able to run the...

I have created a report to replicate the W2 form that you get every year for your taxes and I have a quick question. Because the IRS requires you to submit 2 copies, plus another copy for your own records, I have to create the template 3 times, each one with the same fields etc. Is there any way...

I have a report where I want to Group based on a Count. For example, I have the report Grouped on leader and in the Details Section it shows the people under that leader. Then I get a count of people for each leader and put it in the Leader Group Header. What I would like to do is have my first...

I have a simple report where I first group on System and then I group on Environment. I use a distinct count to get a distinct count of all the accounts within each Environment. Then at the end of the report, I am trying to get a grand (distinct) count, but my numbers dont match up because I...