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 Shaun E 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: DianaStewart
  • Content: Threads
  • Order by date
  1. DianaStewart

    Blob field or Memo field workaround?

    I am viewing my reports by typing in the url in the browser like this: http://server/folder1/Report.rpt It was taking a long time to display, the performance was very slow. So the suggestion was made to convert the connection to my Access database from Direct to ODBC. I changed the connection...
  2. DianaStewart

    Taking too long for parameter fields to appear

    I am using an Access 2000 database and running the report through a web browser simply by typing in the url of the report in the browser. I changed the connectivty from direct to odbc this improved the speed overall of the report but the only problem I have is that as soon as you type in the url...
  3. DianaStewart

    Running Reports Online - WAY TOO SLOW

    I am running a report by typing in the url in the browser. I am using Access 2000 as a backend. The database contains 30000 records. A majority of the fields are indexed. My report contains 3 parameter fields, Name, Date1 and Date2... Here is what I have in my Record Selection forumla editor...
  4. DianaStewart

    Chart Expert - Ok button disabled

    I want to create a chart with ver 8.0... When i goto select any type of chart lets say for example Bar Graph, the ok button is disabled, why is that? Am i missing a service pack or a patch?
  5. DianaStewart

    Where do I reset shared variable

    I have a main report and a subreport. The problem is if a Name field has no value in the backend then the value of the previous name is carried over to that field... If the names contain data in the backend then the Name fields contain or display the correct values.. Should I reset the...
  6. DianaStewart

    Problem Linking three databases

    I have three databases. Database 1 contains the LastName field Datebase 2 contains the LastName field Database 3 contains the LastName field I am using Database 1 as my primary database. I link the LastName field from Database1 to Database2 and I link Database1 LastName field to Database3...
  7. DianaStewart

    I run a query between two dates. Ja

    I run a query between two dates. Jan to Aug, but for some reason my Variable for Sept, Oct, Nov and Dec contain a value. Is there a way to indicate: if the variable is Null then assign it value 0 else variable
  8. DianaStewart

    ODBC error: Invalid parameter number.

    Has anyone ever come across this error message when trying to run a report: Crystal Reports: Database Error ODBC error: Invalid parameter number. When I click the OK button I get Error Detected by database dll.
  9. DianaStewart

    Help Help and Help

    Can anyone please help me out? Please see thread: thread149-387220
  10. DianaStewart

    I am trying to pass a shared number

    I am trying to pass a shared number variable from my Subreport to my main report. In my subreport I have three groups. Group1 is the Table1.Group, the second group is Table1.EmployeeName, and the third group is Table1.Date. The Table1.Date is grouped by Month. This is where I have my formula...
  11. DianaStewart

    Urgent - Passing Shared Values

    I am using Crystal reports 7.0. The shared variable values from the subreport are being passed to the main report only problem is it is giving me the value for the last name rather than for each name... Sub report contains: Group Header 1 (Table1.Group) Group Header 2 (Table1.EmployeeName)...
  12. DianaStewart

    Value from subreport to main report..

    I am using Crystal reports 7.0. The shared variable values from the subreport are being passed to the main report only problem is it is giving me the value for the last name rather than for each name... Sub report contains: Group Header 1 (Table1.Group) Group Header 2 (Table1.EmployeeName)...
  13. DianaStewart

    How and where to reset shared variable

    Subreport: Group Header1 is grouped by LastName Group Header2 is grouped by Date (Month) I have placed my formula is Group Footer2: whileprintingrecords; shared numbervar Variable1 := sum({PunchCard}, "monthly") In my Main Report I have this formula placed in the Group Footer 2...
  14. DianaStewart

    Hide a subreport

    I have a Main report and a subreport. I am passing a shared variable from the subreport to the main report only problem is that subreport is visible on mainreport. The subreport will grow making the report larger. I know that if you supress the subreport or hide it, the value of the variable...
  15. DianaStewart

    How to use the crviewer in Visual InterDev

    I am trying to use the CRVIEWER in Visual InterDev for the first time. I drop the crviewer onto my page. How can I indicate which report to place in the viewer? What is the syntax to get a report to show in the crviewer on my web page? Help is greatly appreciated...
  16. DianaStewart

    Display records since 26 hrs ago

    I am using CR 7.0 My report contains data for the school library. When I open my report I want to be able to display all the books that are taken out since 26 hrs ago. Example: I open my report on Wednesday at 7h30 am all the books since Tuesday at 5h30 am will be displayed... How can I do...
  17. DianaStewart

    Display all records within 24 hrs or a specified time

    I have a date and time field. I want to be able to display all the records where the date time field is before a specified time for example 3h00 am in the morning. It would be nice also if I could take the weekends into consideration as well. Example, if the day is monday then display all the...
  18. DianaStewart

    DateDiff function

    I am presently using CR ver 7.0. Is Datediff available in this version of Crystal reports? If not, is there a fucntion equivalent to Datediff?
  19. DianaStewart

    Subtract 1 "Date and Time" field from another "Date and Time&quot

    Is this possible? On my report I have a field named Date1 and a second field which is Date2. Both these fields are of Date and Time data types. Is there a way to subtract the one from the other? Date1 - Date2 =
  20. DianaStewart

    Error when trying to export to RTF

    I am calling the report from the web by typing in the URL. The report displays perfectly, but when I click on the Export button and I choose rtf I get the following err msg: the export format 'u2frtf:0' is not supported. It worked before but not now , why?

Part and Inventory Search

Back
Top