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 SkipVought 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. TheBigO

    Pass null date value to SQL via VB

    Let me try to explain better: I have a vb form. On that form is a masked edit box called mebClaimEndDate. THis date might not be filled in by the user so that it will be null. I have a class called Claim. When the user enters all information and hits Okay, I pass the form's information to the...
  2. TheBigO

    Pass null date value to SQL via VB

    How do you pass a null date value to a SQL server table through a recordset in VB?
  3. TheBigO

    How do you set a Masked Edit Box (date) to blank

    How do you set a masked edit box's date so that it is blank. I get an error when I use the following expression: mebFromDate = ""
  4. TheBigO

    Confused Consternation with Subreports and shared variable

    balves...you're a genius! It worked, by golly, it worked! Thanks for all of your help. I learned a ton today:) TheBigO
  5. TheBigO

    Confused Consternation with Subreports and shared variable

    Another idea I had was to to suppress a section if the number of records of a certain length equals zero? I.E. the formula: count({@Length}=10)=0 I tried this and it gave me an error message saying "The summary/running total field could not be created"
  6. TheBigO

    Confused Consternation with Subreports and shared variable

    2 more questions: 1 - Under "Format Section" do you choose "Suppress(No drill-down)" or "Suppress Blank Section"? 2 - I want it to suppress if there are 10 digit numbers AND 4 digit numbers. I Want to show it only when there are no 10 digit numbers. THe...
  7. TheBigO

    Confused Consternation with Subreports and shared variable

    Thanks lfl and balves for your help. balves, I used your approach and it works. However, when there is a department which has no 10 digit account numbers, the report won't print the subtotals for the 10 digit accounts. It will only show the information for the 4 digit accounts. How do I...
  8. TheBigO

    Confused Consternation with Subreports and shared variable

    balves, Thanks. that works. However, when there is a department which has no 10 digit account numbers, the report won't print the subtotals for the 10 digit accounts. It will only show the information for the 4 digit accounts. How do I get it to to print out a sub-total for departments...
  9. TheBigO

    Confused Consternation with Subreports and shared variable

    Thanks for listening. I'm using CR 8.5. I have a report which is set up to print information for one department based on the parameter it is passed. The report should show the department name and department number in the page header. In the detail it should show all 10 digit account numbers...
  10. TheBigO

    How do I get a new target window to open maximized??

    Thanks. That worked like a charm.
  11. TheBigO

    How can I view data over the web?!?

    I'm new to crystal reports but this is the way I would do it assuming you're using Crystal version 8.5. Go to File - Insert Field Object. The Field Explorer box will open. Right click on [?]Parameter Fields. Click New. Type in a name of your choice. Click Okay. Now go up to Report - Select...
  12. TheBigO

    How do you get Crystal Report Viewer to open up Maximized?

    With the help of a co-worker, to get this to work, I put the following code in the SmartViewerActiveX.asp file after <BODY BGCOLOR=C6C6C6 ONUNLOAD=&quot;CallDestroy();&quot;> <script language=&quot;javascript&quot;> window.resizeTo(window.screen.availWidth, window.screen.availHeight)...
  13. TheBigO

    How do I get a new target window to open maximized??

    I am opening a new window from an ASP file but it only opens about 1/3 of the computer screen. Is there an HTML or ASP command that I can use to make it automatically open so that the new browser window fits the computer screen?
  14. TheBigO

    Automatically Maximize CRViewer to fit screen from ASP ??

    Is there a Crystal Reports class used with ASP that controls the size of the window which holds the CRViewer? I want it to maximize when the report is opened from the .rpt file which calls it. Thanks.
  15. TheBigO

    How do you get Crystal Report Viewer to open up Maximized?

    I have an ASP application which uses rptserver.asp to show the crystal reports on the web. It works fine however the reports come up as a small box and I'd like them to open up fully maximized. How do I do this?
  16. TheBigO

    Passing identical parameter from Main to Subreport using ASP

    - I'm using Crystal Reports 8.5 - Report connects to three linked MS SQL Server tables using ODBC - I'm calling the report from an ASP page I am trying to generate a report from an ASP file. The report has a main report and a subreport. The ASP file is passing a &quot;department number&quot...

Part and Inventory Search

Back
Top