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 derfloh 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: pomster
  • Content: Threads
  • Order by date
  1. pomster

    Crosstab calculated member issue

    Why did this happen to my crosstab?? I created the report last week with the two calculated members to the right. I would have expected March figures to be after February. The formula for 6 months Avg is: average([ GridValueAt(currentrowindex, currentcolumnindex-1, currentsummaryindex)...
  2. pomster

    Date Selection

    I have a report looking at @customers (Group 1) and @Contract (Group 2) I need to select Customers based on a Contract Start Month. A Customer with multiple Contracts may have Contracts starting in different months. If one of a Customers Contracts starts in a given month, I want to return all...
  3. pomster

    Pass SQL parameter to subreport

    I have a report with a SQL parameter (Customer). on the report is a subreport also with a SQL parameter (Customer). Can I pass the parameter from the main report SQl to the subreport SQL? regards, David CRXIR2 with CRXIR2 server and SQL 2005 CR2008 with CR2008V1 Server and SQL 2005
  4. pomster

    Charting a percentage of 2 counts

    CR2008.. I have a report looking at a call centre stats. It has 2 groups, date - weekly (G1) and Vendor (G2) In the report footer I have a bar chart with 2 series measuring calls taken {@calls} by agent and fix by agent {@fix}. I now need to chart on {@fix}%{@calls} by agent to measure...
  5. pomster

    Date format error

    I have been working on a report in designer and using some text fields to create a date field and choose a day to display. whileprintingrecords; global stringvar GVAR1:= if {Command.User ID} = "Date" then left( WeekdayName (DayOfWeek (Date(totext({Command.1}) + "/" +...
  6. pomster

    Passing dates from subreport

    I am developing a response time report where I need to make allowances for public holidays. Simple you may say, use Ken Hamady's business days formula. In Australia, and probably elsewhere too, we have holidays that are state based so this formula wont work. In my ERP I have table of public...
  7. pomster

    Charting help required.

    I have a report with 5 columns calculating business days between milestone business dates. I am trying to chart these values in a 3D bar chart using count of values. ie, column 3 in data below would show a count of 3 for 1 and a count of 1 for 5. C1 C2 C3 C4 C5 35_14__1__1_12 _1_12__5_34__1...
  8. pomster

    previous or next record = 0

    Hi there, I have a table of printer meter readings that show monthly reads. GH1 is the printer serial no and detail contains the reads. GH ABCD1234 D 35409 01/07/2010 D 36251 05/08/2010 D 0 21/09/2010 D 0 11/10/2010 What I am trying to do is show the pages printed in the 4...
  9. pomster

    sql & dynamic parameters

    Is it possible to use a sql parameter to first limit the data and then follow up with a dynamic parameter? regards, David CRXIR2 with CRXIR2 server and SQL 2005 CR2008 with CR2008V1 Server and SQL 2005
  10. pomster

    Passing Dynamic Datasource to Subreport

    I have a report that uses a Dynamic Data Connection. The same DC is used for the subreport but a different BV. Can I pass this DC to the subreport so I do not have 2 parameters to fill. regards, David CRXIR2 with CRXIR2 server and SQL 2005 CR2008 with CR2008V1 Server and SQL 2005
  11. pomster

    Alerts

    Is it possible to see report alerts in Crystal Server 2008? regards, David CRXIR2 with CRXIR2 server and SQL 2005
  12. pomster

    Mileage calculations

    I need to report similar to a vehicle log book where you fill in the odometer reading daily, not distance travelled. At the end of the month I total the km travelled using maxread - min read. Quite simple really.. I also have a second and third vehicle that I do the same for. How do I get a...
  13. pomster

    Hide section via parameter

    I have a report that has multiple subreports, each contained in a separate report header. I can suppress each of these reports seperately with an individual parameter ie. parameter to hide RHa, RHb and so on. This looks very messy when the report is run and because the list is so long, a fair...
  14. pomster

    Quick copy Db

    I am looking for a quick way to copy a database on a regular basis from one server to another. I have Server1.db1 that I wish to copy and replace to Server2.db1 Any help appreciated. cheers, David
  15. pomster

    Opening a form from 2 locations

    I am trying to open a form from 2 other forms a different times but am getting "type mismatch error" with this:- Public Function GetMemNo() As Long If IsLoaded(Forms!f_membership) = True Then GetMemNo = Forms!f_membership.lngMembershipNo Else GetMemNo =...
  16. pomster

    Group Sort Order

    I have created a group (G2) called {@Contract Group} that basically says if isnull (Contract) then "Non Serialised" else (Contract). Contract numbers can start with anything from A to Z or a number. I always want "Non Serialised" entries as the last group. How do i do this?? regards, David...
  17. pomster

    Modify the number of "Work Days" between any two dates

    I have been using Ken's "Number of "Work Days" between any two dates formula for a number of years now, but a recent change of database gives me a table of "Holiday Dates" Is it possible to convert the table dates to an array to fit in with Ken's formula? Ken's code //Main formula...
  18. pomster

    Email send error

    I am trying to send an email to multiple recipients from an access form. My code was working fine until I tried to move the recipients to the bcc field. It all works fine but gives me an error at the end. "An expression you entered is the wrong data type for one of the arguments" Private Sub...
  19. pomster

    Stop scheduled report from running

    Is there a way in Crystal Server XI R2 to stop a scheduled report from running if there is no data in the report? regards, David CRXI with CRXI server and SQL 2005
  20. pomster

    Link to Subreport

    Hi All, I have a table with field headings of CustNo, Tag1, Tag2, Tag3. CustNo Tag1 Tag2 Tag3 ABESTK C01232 C03453 C05432 MLOATR CO1267 CO2222 etc etc The only grouping in the report is by CustNo. I currently have a subreport in GF1 with the link as Tag1. I need to call the...

Part and Inventory Search

Back
Top