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 TouchToneTommy 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 johnugly

  1. johnugly

    number format

    I use an Oracle ODBC driver for my subreports, they work fine. For my main reports I use the "Push Model", I create the main reports by using an xml-scheme (ADO.NET), then I fill a Datatable on the Oracle database, and push it to the report, ReportDocument.SetDataSource(datatable). I just can't...
  2. johnugly

    number format

    I forgot to say that I use Oracle 9i, before I used SQL-Server and they worked fine. And the oracle-number fields cause the problem
  3. johnugly

    number format

    Hi, I use CR 9 to develop my reports, but in my program I use the Crystal Reports for .NET dll's. I have problems with the representation of numberfields, for ex : 129 --> 129,00 I set all the options on how they should be formatted, but they keep appearing in "0,00" - format. This also...
  4. johnugly

    Execute a report from command line

    -http://www.recrystallize.com/merchant/crystaldesk/crystal-command.htm
  5. johnugly

    change subreport command content

    Hi, I have a main report(CR 9) with a linked subreport using an ODBC connection. The subreport uses a command to retrieve data. Is it possible to change the content of the command in code, i.e. .NET?
  6. johnugly

    Query Engine Error

    check the groupfields?
  7. johnugly

    Multiple Prarmeters passed via VB.NET

    try this, this works fine Dim paramFields As ParameterFields = New ParameterFields Dim Param As ParameterField Dim dcParam As ParameterDiscreteValue Dim ParamName As String If ParameterCount > 0 Then Dim i As Integer = 1 For i = 1 To ParameterCount Param = New...
  8. johnugly

    change the data Provider for a subreport ??

    Hi, I'm using CR9 and have the following question. Is it possible to change the data Provider for a subreport at runtime, i.e. from MS OLE DB Provider for SQL Server to MS OLE DB Provider for Oracle? If not do you know how to solve this problem, the report should work on both SQL Server and...
  9. johnugly

    text style depending on formula

    hello, i use CR 9 and i want a specific field to have style bold when its equal to another field. You can write a formula under the tab "Font" of the "style" item. I just don' know how to formulate it :p. Thanks in advance
  10. johnugly

    Load Picture(OLE) from code

    hi, I want to load a picture into a report(CR9) from code, i.e. VB.NET. Anyone knows how this can be done? blobobject, pictureobject, none of these have a load property, and I cant cast to OLE Object
  11. johnugly

    problem with where clause in command

    you may be right, I'll try it the next time
  12. johnugly

    problem with where clause in command

    ok, that's it, i was trying to concatinate it with a "+" tnx
  13. johnugly

    problem with where clause in command

    Hi, i'm using CR9 and have a report with a subreport. The supbreport uses a command to get its data. In the command there's a where-clause which uses a parameter from the main report. ((where table.culture = {?Culture})) culture is a string (varchar(5) in sql server) Now here's the problem...

Part and Inventory Search

Back
Top