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: *

  • Users: Belky
  • Order by date
  1. Belky

    Cross Tabs inserting formula's

    Hi, I need some info on the possible formulas I can use in the summary fields. When I try and addformulua's they don't show up in my selection and I can't add it as a summarised field. This is what my forumula looks like; WhilePrintingRecords; NumberVar CarryOver; if...
  2. Belky

    Stored Procedures and date range QUESTION

    Rooble, I am acutally passing through two date paramaters but calcualting them on the report as a date range. However I still can not get the Date's to pass through. Any examples would be greatly appreciated. Thanxs. bel.
  3. Belky

    Stored Procedures and date range QUESTION

    Hi, I am using an oracle database and writing my stores procedures to report off in PL/SQL. I have a report requireing Date Range paramaters. When I create this and test it in PL/SQL it runs fine. However when I try and open it as a new report in Crystal I get oracle errors. My thoughts are...
  4. Belky

    What's the best way to count?

    Thank you Naith, I tried your way and it seems to have worked however another question. As I'm having some issues brining back data for the one date at the moment in my stored procedure, if I have for instance; NAME DATE COMPLETE INCOMPLETE Belinda 31-OCT...
  5. Belky

    What's the best way to count?

    So where am I do put these Select count(tasks) from table where status == 'Complete' for user. Select count(tasks) from table where status == 'Tentative' for user. Do I create these in formula's? If so could you help me out a little with the crystal syntax please. thanx
  6. Belky

    What's the best way to count?

    Hi, I have a field which has many status's in it. For the one person they may have 6 status's (tasks with status's) of Complete and 5 status's of Tentative etc. I need to display ; CT NAME No. Tasks complete No. Tasks Tentative Belinda 3 5...
  7. Belky

    What is the best way? - Duplicate Data

    Wow thanks for the speady reply. However I don't know if I mentioned that in my database for instance there are many entries for the skills, ie a person may be entered 12 times int he database. I don't want to see his name 12 times but the skills. So what will putting the skills ina formula...
  8. Belky

    What is the best way? - Duplicate Data

    Hi, My problem is I have columns accross the page with details underneath these also. Then accross the page some of my columsn; skill 1 - 3 can have many entries but the rest of my data can not be duplicate. So it loks like this. Name Phone Skill 1 Skill 2 skill 3 Address...
  9. Belky

    Blob Field - Work around to calculate on.

    Hi All, I have two fields, Comments and Contractor Comments. Now The first field is a blob field and hence does not show up in the equation editor. The second is simply a text field (length 80). No I wish to have a calculation or something as to which is one of these is null (or blank) then...
  10. Belky

    Reporting from an XML data source and database source

    Hi All, I understand Crystal Reports can report from XML data source given that they are in the format of XML Data Island files, XML ADO compatible files or raw XML files. However, my question is, can I report off a XML data source as well as a database source on the same report. My guess is...
  11. Belky

    Reporting from an XML data source

    Hi All, I understand Crystal Reports can report from XML data source given that they are in the format of XML Data Island files, XML ADO compatible files or raw XML files. However, my question is, can I report off a XML data source as well as a database source on the same report. My guess is...
  12. Belky

    Broadcasting licence question

    No I believe with Crystal Enterprise 8.5 there is scheduling capability for exporting to specified locations whether it be c drive or somewhere on the lan. This can all be automated. This is what I was advised by crystal. I was also advised it would be / could be cheaper to get licences for...
  13. Belky

    Broadcasting licence question

    Thanks all. But I want to 'schedule' this html page, but to send it to only one destination. Which just happens to be viewed by the whole company if they wish to do so. What do you all think?
  14. Belky

    Broadcasting licence question

    Hi, If I have a scheduled report produced in Crystal Reports, I then export this in html and paste this on a company web site, where may people around the company can view this, do I need a broadcasting licence? So I am not exporting this to lots of people physically although many people can...
  15. Belky

    Scheduling sections of Reports to distribute in xls format

    Hi All, Say I have a very large report and I want this scheduled so I can export it in xls format to end users who don't have access to crystal or the web. However I do not want to export the 'entire' report as it may be 10000 pages long. Can I schedule a report with parameter, so for example...

Part and Inventory Search

Back
Top