Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: goduke
  • Content: Threads
  • Order by date
  1. goduke

    Formatting Group

    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...
  2. goduke

    Returning Too Many Records

    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...
  3. goduke

    Parameter with Null Values

    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...
  4. goduke

    Need Help Wild Card In String

    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...
  5. goduke

    Why Is This Running So Slow

    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...
  6. goduke

    Help With String Formula

    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...
  7. goduke

    **Need Help with Date Range**

    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...
  8. goduke

    --Help With Running Totals--

    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...
  9. goduke

    **Error Message for Cross Tab**

    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...
  10. goduke

    Help with string formula.

    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...
  11. goduke

    Help with Form

    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...
  12. goduke

    HELP with subreport

    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...
  13. goduke

    Sorting Order of My Group

    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...
  14. goduke

    Help With Query

    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...
  15. goduke

    How To Display Results From A Parameter?

    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...
  16. goduke

    Organizational Chart

    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...
  17. goduke

    Need Help with Parameter - AGAIN

    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...
  18. goduke

    Help With W2 Form

    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...
  19. goduke

    Help with Group

    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...
  20. goduke

    Help with Distinct Count

    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...

Part and Inventory Search

Back
Top