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

  1. bzss7x

    Record Selection Windows Pop Up Before Parameter Window

    Thanks anyway, but I appear to have resolved the problem. The issue was that in the Select Expert I had (amongst other code) {Outstanding balance} <> 0. When the crystal was compiled and run from the .exe there is a checkbox called 'Modify selection formula'. By default this checkbox is ticked...
  2. bzss7x

    Record Selection Windows Pop Up Before Parameter Window

    When I run my latest CR 8.5 compiled report, I get two Record Selection windows that appear prior to the main parameter window. The two Record Selection windows correspond with two fields in the select expert. However, the select expert has a value for each field already in there. How do I...
  3. bzss7x

    ? about graph of start / stop time of event

    The join problem came when one join is greater than or equal to (gte), then the other join becomes gte. So when I joined Event.StartTime to TimeDimension.Time as a gte join, then the join from Event.StopTime to TimeDimension.Time becomes a gte join. What I ended up doing was putting two...
  4. bzss7x

    ? about graph of start / stop time of event

    As the beer guys say - Brilliant! That is really thinking outside of the box. The only issue that I had was doing greater than and less than joins between the same two tables. Crystal only wants one type of join there. I just put in one join and it seems to be giving me good results. I'm in...
  5. bzss7x

    ? about graph of start / stop time of event

    First of all, here's a data sample: EventID StartTime StopTime 1 7:00 AM 5:00 PM 2 6:00 AM 4:00 PM 3 9:00 AM 6:00 PM 4 7:30 AM 2:00 PM 5 8:00 AM 3:30 PM ... OK, What I need is a graph in the report...
  6. bzss7x

    Word Date Variable &amp; Calculation - Please Help. Thanks.

    Shouldn't dteFirstTrimester = dteDueDate – 196 be dteFirstTrimester = dateadd (d, -196, dteDueDate) ? Also, how do I display the results? Do I use {DueDate} or what? Thanks for all assistance.
  7. bzss7x

    Word Date Variable &amp; Calculation - Please Help. Thanks.

    Need help, please! I am helping an OB/GYN with a word problem. Requirement: 1. Open Word Doc and be greeted with Input Box for Due Date. 2. Have references to that entered date and calculations from it throughout document. Example: Input Box will assign due date (e.g. 8/23/06). First...
  8. bzss7x

    PowerPoint Viewer - How to print from link ???

    I figured it out... On the hyperlinks, point to a local bat file (.\local.bat) . local.bat @pptview.exe /S /P printpage.ppt Make the page you want to print into its own presentation (printpage.ppt). I still get a warning about harmful files, but I can live with that.
  9. bzss7x

    PowerPoint Viewer - How to print from link ???

    I've put together a nice presentation and packaged it to CD using powerpoint viewer to display it. I was ready to send it to clients when I tested it and found a major problem - I couldn't run macros from the hyperlinks. I used the macros to print slides. So on to plan B - I reworked the...
  10. bzss7x

    Kill after x number of refreshes??

    Excellent suggestions! Because of these, I was able to get it to work!!! What I ended up doing was a combination of the ideas above. <% refreshcount = Request("refreshcount") if refreshcount = 20 then response.write("<BODY onload='KillMe();self.focus();'>") else refreshcount = refreshcount + 1...
  11. bzss7x

    Kill after x number of refreshes??

    Thanks guys, you've given me some good ideas... I try these tomorrow and report back.
  12. bzss7x

    Kill after x number of refreshes??

    Maybe I'm not following you or I wasn't clear... My code... <HTML> <!--#include file="kill_screen_inc.asp" --> <HEAD><TITLE></TITLE> <META HTTP-EQUIV="Refresh" CONTENT="60"> <BODY onload="KillMe();self.focus()"> yada yada yada After 60 seconds the page refreshes and again loads the...
  13. bzss7x

    Kill after x number of refreshes??

    I have a problem... First requirement - I need a page to refresh every minute. OK, simple enough I can use the <META> tag for that. Second requirement - I need the page to kill itself after 20 minutes. I'm running a JS loaded by a BODY onload statement that will kill the page after 20...
  14. bzss7x

    Please Help With Parameter in SP Query

    Ok Guys I have a problem. I'm sure someone know the answer to this. I'd appreciate any advice.... Query: declare @PRODN_DATE_START datetime, @PRODN_DATE_END datetime set @PRODN_DATE_START = '04/17/02' set @PRODN_DATE_END = '04/17/02' (SELECT COUNT(EVENT_TRACKER.EVENT_CD) FROM { oj...
  15. bzss7x

    Problems passing parameters via ASP.

    Any assistance would be appreciated... First of all this works on my development PC (XP/CR8.5) but not on our web server (NT/IIS4.0/CR8.5). DLL maybe?? The problem.... I want to pass a parameter called &quot;shift&quot; to a Crystal Report using ASP. The ASP page extracts the value entered...
  16. bzss7x

    Problem Passing Parameters via ASP. UGH!!

    Any assistance would be appreciated... First of all this works on my development PC (XP/CR8.5) but not on our web server (NT/IIS4.0/CR8.5). DLL maybe?? The problem.... I want to pass a parameter called &quot;shift&quot; to a Crystal Report using ASP. The ASP page extracts the value entered...
  17. bzss7x

    UGH! Problems passing parameters from ASP

    Any assistance would be appreciated... First of all this works on my development PC (XP/CR8.5) but not on our web server (NT/IIS4.0/CR8.5). DLL maybe?? The problem.... I want to pass a parameter called &quot;shift&quot; to a Crystal Report using ASP. The ASP page extracts the value entered...

Part and Inventory Search

Back
Top