Search:

Type: Posts; User: ducky

Page 1 of 5 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    5
    Views
    5,742

    Re: pass value in crystal report through textbox

    Looks like maybe your missing quotes in the parameter field name, thus causing the subscript out of range. Try

    rpt.ParameterFields("bill_amt").Value = Text5.Text
  2. Replies
    1
    Views
    556

    Re: Crystal 8.5 formula problem

    the crSilver, etc conditional formatting only works in the background or border color formula editors. Is that where you are placing the formula?
  3. Re: How To Limit A Record And Columns In Each Page Of Crystal Report8.5

    To limit the number of records per page use a formula along with the Section Expert.

    Go to the Section Expert for the Details section, click the formula button for New Page After and use a formula...
  4. Replies
    5
    Views
    1,362

    Re: [2005] Windows Integration with Oracle Issue

    Tried the SSPI connection string, and it still occurs. I switched the code over to use the Oracle ODP.Net provider and the same phenomenon happens. So my assumption is it is not a bug with the...
  5. Replies
    5
    Views
    1,362

    Re: [2005] Windows Integration with Oracle Issue

    Thanks mendhak. I was able to get our DBA to do an audit as you suggested. It appears the application is trying initially to logon with the os user 'NT Authority\Anonymous Logon' from the web server...
  6. Replies
    5
    Views
    1,362

    [2005] Windows Integration with Oracle Issue

    Has anyone had success implementing an ASP.NET 2.0 appliction to use windows authentication via Micorosoft's trusted subsystem model to connect to an Oracle database? I have the model working for our...
  7. Re: [CR .NET 2k5 Edition] Printing Crystal Reports via code.

    It may be that the printer that the report was designed with is not found in your local printers on your machine. Try setting the printer to a valid printer to print to via code just before the...
  8. Re: Providing database logon credentials to CrystalReports XI thru VB6.0

    If i recall correctly the dll specified should be "crdb_odbc.dll" for ODBC connections. Try it out.
  9. Replies
    2
    Views
    1,344

    Re: Upgrading Crystal Reports

    Yes I would say believe your source. If you purchase any of the developer editions, those always include the components to integrate with development tools such as visual studio. The free crystal...
  10. Replies
    7
    Views
    2,086

    Re: Set datasource from VB through dialog

    Did you uninstall the pro version before installing R2? Or did it ask you about it before letting you install? I seem to remember something about needing a clean install. Its been a while since I...
  11. Replies
    7
    Views
    2,086

    Re: Set datasource from VB through dialog

    If you purchased a separate copy of Crystal XI as you say you have, then you may be able to download the XI R2 from their web site and install. Its available, just check the licensing restriction. I...
  12. Replies
    0
    Views
    589

    Oracle Stored Procedures

    I use the MS .NET Oracle Data Provider (System.Data.OracleClient) for connecting to Oracle and selecting data from stored procedures just fine by setting the OracleCommand.CommandText to the...
  13. Replies
    9
    Views
    609

    Re: VS 2005 Standard or Professional?

    If you have 2005 at work you may be able to install it at home too. Check the eula which may say you can install at home too. However since your company licensed it to you, if you're thinking of...
  14. Re: Check connectivity for an oracle server from with in a SQL Server Stored procedure.

    You could create a "Linked Server" in your SQL Server database that establishes a connection to your Oracle server. Then in your stored procedure do a query against the linked server connection, and...
  15. Replies
    5
    Views
    703

    Re: Want to add a meesage before shut down PC

    If you just want to show a quick message as such, you can just create a shortcut to the shutdown.exe. This allows you to shutdown windows and accepts an optional parameter for adding a comment...
  16. Replies
    3
    Views
    465

    Re: Summing the number of groups?

    Create a Running Total Field. The field to summarize should be the field you are grouping by and the type of summay should be count. The running total should be set to evaluate on change of the group...
  17. Replies
    16
    Views
    1,515

    Re: Accessing an Oracle Stored Procedure Using ADO

    I never use a number other than 0 in the resultset. It will return all records into the recordset fine. No need to get fancy with the resultset notation. In fact I always define the first parameter...
  18. Replies
    16
    Views
    1,515

    Re: Accessing an Oracle Stored Procedure Using ADO

    I don't think so. I've always put my sys_refcursor as the first parameter in my procedures and don't recall any troubles otherwise.
  19. Replies
    16
    Views
    1,515

    Re: Accessing an Oracle Stored Procedure Using ADO

    Ok, I've included code below that works using you variable names, etc. To answer your questions, the cursor does not need to be an IN OUT, OUT is good enough. I do not use the OraOLEDB.Oracle driver,...
  20. Re: [02/03] “Upgrading” Crystal version in VS

    I upgrade my VS2003 with Crystal 10 by using the Crystal 10 Developer CD and chosing the option Install .NET Components. Does your Crystal 11 cd have something similar?
  21. Replies
    1
    Views
    564

    Re: Help with Crystal formula

    The trouble is the datafield is null and the formula does not know how to handle it. You can solve this in a couple of ways
    1) Go into File/Report Options and check Convert Database NULL Values to...
  22. Replies
    5
    Views
    600

    Re: How is a web page processed?

    I reviewed some of my web code that has this exact script/src tag. By viewing the web server log files you can clearly see it listed as a separate GET. However if multiple pages use the same...
  23. Re: CR 11... format a number in a formula field?

    I'm guessing in your formula was interpreted as a string now because you added the "-" in the formula by using a string concatenation like "-" & yournumber. You need to create a formula that retains...
  24. Thread: Monitor port 80

    by ducky
    Replies
    8
    Views
    1,920

    Re: Monitor port 80

    Yea, I guess if your being contracted the big $ comes into question, give them what they want. Otherwise, if its an internal application for your employer, then I always pick the easy route.
  25. Thread: Monitor port 80

    by ducky
    Replies
    8
    Views
    1,920

    Re: Monitor port 80

    You could just configure the web server to log the data you need, then create an application to monitor those log files.
  26. Re: [RESOLVED] reinstall windows on motherboard upgrade??

    As with any hardware update, it may find it on the hard drive already, or may ask for the OS install disk, or it may be a disk provided with the motherboard. I suggest you keep a backup of the drive...
  27. Re: [RESOLVED] reinstall windows on motherboard upgrade??

    Although not necessary to reinstall, realize that since your changing motherboards the OS will detect new hardware related to the new motherboard system resources. This may prompt for new drivers,...
  28. Thread: Pc Dvr

    by ducky
    Replies
    11
    Views
    1,049

    Re: Pc Dvr

    Check out this forum

    http://www.htpcnews.com/forums/index.php
  29. Replies
    4
    Views
    465

    Re: Enterprise level design question

    Oracle on Linux is available. Don't be scared off by the previous post. Since Oracle and SQL Server can be linked databases, you have a native two way street between your data and anythings possible...
  30. Replies
    10
    Views
    728

    Re: Starting out programming

    Find out what programming languages they offer at your university as an elective. Physics may require one anyhow. Choose one of those to start learning yourself, then take the class when you get...
  31. Replies
    4
    Views
    521

    Re: Resetting a variable for new group

    Don't actually count with a shared variable on your detail record, create a separate formula say AwaitingOutcome10 with

    If {tbl_Enquiry.AwaitingOutcome} = "Yes" Then 1
    Else 0

    Drop that on the...
  32. Replies
    1
    Views
    454

    Re: Using info from forms in a crystal report

    No problem. You don't have to connect to a database. You can set Crystal Parameters, Formulas, etc at runtime or even create a recordset and use that all of which could display on your Crystal Report.
  33. Replies
    3
    Views
    717

    Re: Can't export in preview

    I know in the past I've had to manually install the export file types, for the export button. It seemed the export button dynamically looks for them and presents the options depending on what it...
  34. Replies
    2
    Views
    523

    Re: Getting Started with Crystal 8.0

    My preference has always been to design reports with the Crystal Reports application, save as .rpt files and then reference them in my application by using either the crystal viewer control or...
  35. Re: Yet another Oracle/Stored Procedure question

    Ok, try this for an example if you were to re-write the function. Create a new procedure as follows. I'll use the same exact parameters, just without a select statement.


    CREATE OR REPLACE...
  36. Re: Yet another Oracle/Stored Procedure question

    Just re-read the definition and see stub_get_cust_address is a function. You can not call oracle functions directly from vb ado. You need to convert the function into a procedure, or wrap it in a...
  37. Re: Yet another Oracle/Stored Procedure question

    The ? is a place holder stating there is a parameter in the procedure call. So if you have another procedure that has only two parameters there would only be (?,?), three (?,?,?) etc.

    ADO and the...
  38. Replies
    17
    Views
    1,266

    Re: Free Oracle Database?

    I don't know about 10g, but Oracle had previously provided personal editions of 8i and 9i you could download and use. The personal editions would install on a workstation and was good for as in this...
  39. Re: Determine if connection object is in a transaction

    AFAIK, you'll have to keep track of it yourself. You can either use a boolean or long to track it. Examples:

    connection.begintrans
    blnInTran = true

    In this case after every begintrans...
  40. Re: Yet another Oracle/Stored Procedure question

    You're trying to use the AdCmdStoredProc command type that is not supported with the Oracle ODBC Driver from what I recall. That's why it bombs on the execute.

    Change your code:

    .CommandType =...
Results 1 to 40 of 187
Page 1 of 5 1 2 3 4



Click Here to Expand Forum to Full Width