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!

  • Congratulations Mike Lewis 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: *

  1. FloridaHawk

    Looking to automate an export to PDF

    We would like create a job that would do that following Create over a 1000 pdf files from a report. So for one company a pdf file would print. It will take 1 to 4 seconds to generate a report. I would have to name the pdf file based on which company and company id its print for. The stored...
  2. FloridaHawk

    How do I NOT get a number to round

    Using Crystal 8 I would simply like to display 1.27 as 1.2 In Crystal, the decimal is dependent on the round. So if I set the decimal to 1.0 the round goes to this. I tried set the number to text (totext(1.277,1) but it shows the $ sign - anyways to remove the dollar sign when doing a totext...
  3. FloridaHawk

    Export button not working on viewer

    Issue - using Crystal viewer 9 in an application. The reports are created with Crystal 8.0. The export button was working fine until Crystal 8.0 was loaded on the system. Cyrstal 9 view comes up but and the report displays fine but when you click on the export - nothing happenes. Is there an...
  4. FloridaHawk

    Question on organizing/labeling for charts/cross tabs

    That works great..but the only thing is the headers dont export to excel when I export a tabular report.
  5. FloridaHawk

    Question on organizing/labeling for charts/cross tabs

    I have a formula which is used for grouping, charts and also cross tabs. numberVar BusSec := {@DateDiff1}; IF BusSec < 3600 THEN '1- < 1 Hour' ELSE IF BusSec >= 3600 and BusSec <=28800 THEN '2- 1 To 8 Hrs' ELSE IF BusSec > 28800 and BusSec < 259200 THEN...
  6. FloridaHawk

    Active X Viewer only exports rpt file

    I have Crystal 8.0 and am using its Web Component manager to create reports that run off the web. I just downloaded the latest Active X viewer and am having the same issue. The viewer only exports to a .rpt file. #1 I dont want it to export to a .rpt file in the first place but do want it to...
  7. FloridaHawk

    Average line on bar chart?? Crystal 8.0

    I have a bar chart which displays the average for each individual- now I want to display an average line for the group. It's simply a straight line. I can do this for line charts but cant seem to do it for bar charts (as requested by user) Anyone know if there is such a chart within crystal...
  8. FloridaHawk

    Best way to connect to SQL from ASP??

    I have had problems with my logon scripts in the example aps pages provided by Crystal Decisions. Getting error on the server in attempting to access the data source. Heres the string I use: userid = &quot;YOUR_DATABASE_USERID&quot; password = &quot;YOUR_DATABASE_PASSWORD&quot...
  9. FloridaHawk

    Does Crystal Report 8.0 have the 5 concurrent user policy

    I noticed 8.5 and up has a rule that only 5 concurrent users can view the report. To have more you have to purchase a license.
  10. FloridaHawk

    Need advise on getting started with ASP reports

    We have been given the green light to start producing web reports. We have Visual Studio 2003 and Crystal Reports 8.0. These reports will be running off a SQL server. The reports will be used for in house intranet as well as limited internet. My questions are: * Does anyone know of a good...
  11. FloridaHawk

    Need advise on getting started on ASP Reports

    We have been given the green light to start producing web reports. We have Visual Studio 2003 and Crystal Reports 8.0. These reports will be running off a SQL server. The reports will be used for in house intranet as well as limited internet. My questions are: * Does anyone know of a good...
  12. FloridaHawk

    Working Days Between Two Dates

    This is what I made last week for the exact same problem works great. Have it set up so you can test in any report: // use this to text forumla- later remove TestDate (and currentdatetime if apply)and enter the field name(s) datetimevar TestDate := datetime(2002,12,01); numberVar BusSec :=...
  13. FloridaHawk

    Can you pass a NT Login name into a report

    Thanks Rosemaryl but unfortunately they connect via citrux and then the report is ran. The dabase user is a universal login. Thanks though!! Will keep plugging away.
  14. FloridaHawk

    Can you pass a NT Login name into a report

    Is there a way I can pass a NT login name into a report. I want the report to run for each specific user so they wont have to enter their loging name into a parameter (this would allow each person to view other people's data) Any ideas would be helpfull
  15. FloridaHawk

    Chart and one Running Total

    Actually this is how I am summing up the open calls in the report. The problem is in chart it is summing the totals per week and not adding the previous totals: Example Week 1 - 24 Week 2 - 10 Week 3 - 5 What I Want the chart to do is Week 1 - 24 Week 2 - 34 Week 3 - 39 I have a running...
  16. FloridaHawk

    Chart and one Running Total

    I want to display a running total in a chart for each week but the only way I can place a week in is &quot;On Change of&quot; which means the running total is reset each week. The running total us simply showing sums of open calls by week and needs to grow each week (as more calls are opened...
  17. FloridaHawk

    Running Total of Group summaries of one field

    Hey all ...need some help in what I thought would a pretty simple running total. Need to do a running total of open calls (which would be considered a backlog). Group1: Week Week 1 Group2: Team CC Group3: Emps Smith 20 cases 10 open 3 closed Jones 21 cases...
  18. FloridaHawk

    Summarizing a back log total in current week groups

    Sorry! Knew I should have been more descriptive. The owner will pass in a begin and end date parm. The sproc returns the open/closed dt, then 1 or 0 for new call, closed call,and still open call and tech name. The group is by date time and returns weekly values, and by tech. I placed the...
  19. FloridaHawk

    Summarizing a back log total in current week groups

    Group1: Weekly Group2: Tech Fields: New calls that week, closed calls that week and backlog. Backlog are any open calls from previous weeks. I am importing the data from a stored proc which has dates and 1's for New calls 0 if no, 1's for closed calls 0 for if no. Summarizing is simply...

Part and Inventory Search

Back
Top