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 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. 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...
  14. johnugly

    Grids in Crystal?

    Is it possible to define a grid in CR9 report, or do you have to do everything by yurself drawing lines and boxes thanks in advance, john
  15. johnugly

    create reports programmatically

    Hello, is it possible in .net to create crystal reports(9) in your own application. Can you use the same designer Visual Studio offers to make reports(new item --> Crystal report..)? Thanks in advance, john
  16. johnugly

    How to dynamically import logo

    Is it possible to import a logo for a report from the database when opening the report? (CR9)
  17. johnugly

    changing database connection

    hello, i have a report in CR9 using an oldb command. So now when I open the database expert I can see the name of the database which i used when creating the connection and underneed the command. The question is how I can change the database in code in .NET. I can do it when I use tables but...
  18. johnugly

    extra query for 1 field

    Hello, is it possible in CR 9 to do a call to the database for just one field (this field is in a subreport), or do you need to get up all your data by query when the report loads? thanks in advance.

Part and Inventory Search

Back
Top