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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by wiplash

  1. wiplash

    Copying Historical Reports

    Thanks again Dell!
  2. wiplash

    Copying Historical Reports

    Need to copy a few hundred historical reports (instances) over to a PDF (or some other format which can be viewed by a user w/o Business Objects), and would appreciate if someone has an idea how this is possible without having to open each one individually in BO and then exporting it as a PDF...
  3. wiplash

    Graph showing all

    We have a CR that includes a chart (currently a 3D bar chart) showing type and total number of recs for each type. Example: There are 5 total type "A" records, 3 total type "B" records, no type "C" records, and 6 type "D" records. Although in this case, there are no type "C" records, we...
  4. wiplash

    Data Values appearing Across Report vs Tabular

    We've used Crystal Reports for years (spanning several versions) and now changing to SRSS, and thus all past reports need to be "converted" or basically rewritten (which is the direction chosen). Very limited (almost zero) experience using SRSS here, so the question ... Most our reports have...
  5. wiplash

    stored procedure prompt

    Haven't yet got this working correctly but now on the right track I think.
  6. wiplash

    charting

    Is it possible to chart a zero value in Crystal Reports? In other words, there are no records in the database (this time), yet I want to show the same set of "bars" every time with the appropriate "counts", even those with no data at that time. For example, I have a bar chart supposedly...
  7. wiplash

    stored procedure prompt

    As always Dell, I appreciate the help! I will try this and post the results. Thanks!
  8. wiplash

    stored procedure prompt

    I'm working on a report written with Crystal Reports 11.5 viewed in Business Objects R2. It uses a prompt from a stored procedure (in SQL). Currently the user just types in his/her data into that prompt. (it's a static prompt) However, I'd like to make the prompt a drop down to limit...
  9. wiplash

    How can you tell when a report was last run in Infoview?

    Need to delete some "obsolete" reports. BOXI R2 Crystal Reports (mostly) (a few versions) Thanks!
  10. wiplash

    Calculating previous month

    Hey it's all good and thanks again to both of you!
  11. wiplash

    Calculating previous month

    That worked perfectly, thanks much! By the way BettyJ, the parameter actually shows a list of possible periods as read in the SQL table, field defined as character. Can't explain why, but that's the way it was defined years ago. Thanks once again!!!
  12. wiplash

    Calculating previous month

    Thanks Charliy, but I'm getting an error on the formula to calculate the begin date and so far haven't determined the fix (or cause). Specifically, the formula .......... @bdate} dateadd('m',{@edate},-1) The @edate part says "a number is required here". I am probably doing something...
  13. wiplash

    Calculating previous month

    I need to calculate the previos period (previous month) based on the period parameter the user enters, and imagine there's a much easier way than the all of the formulas I currently think necessary. Using CR11.5. The period is listed in the database as a 6 digit field (yyyymm) and not an...

Part and Inventory Search

Back
Top