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 strongm 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: kruby
  • Order by date
  1. kruby

    Crystal 8.5 Professional Report Automation

    Actually, you can install them on the same machine. According to Crystal Decisions, in tech article "General Questions and Answers Regarding Crystal Enterprise 8" the question was asked if was possible to install Crystal Enterprise and Seagate Info 7.5.2.0 on the same machine. The...
  2. kruby

    Crystal 8.5 Professional Report Automation

    Yes, you would think CE would have the same functionality as Info, but apparently not. You are able to code a solution in CSP for automatic email notification, but I found this thread that someone else asked about email scheduling in Info: thread782-100322 and apparently, there is a 3rd party...
  3. kruby

    Crystal 8.5 Professional Report Automation

    MattMcCoy I'm using CE8.0 and CR8.5 and another group wanted to use them too, but they have Seagate Info 7.0 which has the automatic report scheduling and email notification features. I couldn't find this function with CE and CR, so they decided not to buy in with us. My understanding is that...
  4. kruby

    SQL, db design or Crystal problem? - wrong data on reports

    Ido, you're right, you can reference running totals in formulas. I've been reading all day on runnnig totals and trying to get this to work and I'm all confused on this end :-) My two running total fields are #DealersCount - placed on group footer and #TotalCount - placed on report footer. They...
  5. kruby

    SQL, db design or Crystal problem? - wrong data on reports

    Thanks Ido, that worked, but now I have another issue with the same data concerning running totals. I'm able to get the true deal count for each dealer (using a running total) and I'm able to get the true count of deals for ALL dealers (using another running total). I need to be able to divide...
  6. kruby

    SQL, db design or Crystal problem? - wrong data on reports

    Hi, I'm having a problem with correct transaction amounts appearing on my reports. I'm not sure whether it's due to the database design or if I'm not creating the report correctly with Crystal. I have 3 tables: 1. Deal Deal_ID (primary key) Deal_Date Deal_Amount 2. Attribute_List...
  7. kruby

    Limit on default parameter list?

    Thanks, I found it your FAQ. faq149-811
  8. kruby

    Limit on default parameter list?

    Hi, Has anyone come across this problem before? Or know the solution? I'm using a parameter on the client database field on a report so that user can select a particular client. When I select the table (Client) and field name (ClientName) for the defaults for the parameter, it will only list...
  9. kruby

    Anyone made use of this yet? I would like to know.

    The site is still there, the link isn't formatted properly as it has a period and a space at the end. The link should be: www.techprofiles.com I just finished checking out the site. This is something I've never come across before. Has anybody else? IMO, it seems to be a complete waste of...
  10. kruby

    Excel object -open within browser?

    Thanks very much the links and the tips! I think's the functionality is really neat and so useful. The same day that I saw this done with Excel, I went to another site and Word opened within the browser, too. Just wondering if this was something new as I've never seen this done before? Thanks!
  11. kruby

    Excel object -open within browser?

    Hi, I'm wondering if anyone can tell me how the following was done, as we would like to incorporate it in one of our web pages. I went to a website today and the page showed data in rows and columns (formatted in tables). They had a link called "Excel" and if you clicked on the link...
  12. kruby

    Parameter - Allow Multiple values

    Yes, see thread thread767-99969
  13. kruby

    Multiple parameters (nested IFs)

    AJ, Malcom's method in his first response would have worked, if I didn't want multiple discrete values. When I changed my parameters to only accept discrete values, his method worked. I really liked that you could see the SQL statement in this method. But, I couldn't get past the error...
  14. kruby

    Multiple parameters (nested IFs)

    Thanks Ken and Malcolm for your assistance. The parameters are now working. Karen
  15. kruby

    Multiple parameters (nested IFs)

    I'm so confused on this end :-) It seems to me that it would be a very common report request--to have several parameters and a date range on a report. I have 30 reports, all with a minimum 2 parameters, some with 4 parameters. In Access, these kinds of parameter reports would take me minutes...
  16. kruby

    Multiple parameters (nested IFs)

    Thanks for the idea, Ken, but when I implement the change, I'm still getting the subscript error message. The error is highlighting the 'in' word in the formula: //record selection formula {industry_list.ind_name} in IIF ({?pIndustry} = 'All Industries', {industry_list.ind_name}>= ''...
  17. kruby

    Multiple parameters (nested IFs)

    Hi, I spoke too soon, the quotes didn't work. It simply replaced the condition as a string in the SQL statement. Any solution to the error message... "This array must be subscripted. For example: Array [i]." is appreciated. Karen
  18. kruby

    Multiple parameters (nested IFs)

    FYI, I found that if I enclose the conditions in quotes, the error message went away. The original formula of: IIF ({?pIndustry} = 'All Industries', Is >= '',{?pIndustry} to {?pIndustry} + 'ZZZZ') becomes... IIF ({?pIndustry} = 'All Industries', Is >= '',"{?pIndustry} to...

Part and Inventory Search

Back
Top