Search:

Type: Posts; User: rasinc

Page 1 of 12 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    18
    Views
    1,063

    Re: Mysql Nested sub query

    Zvoni, I do admit that when I saw the use of Partition, I did not dissect your query very closely. I knew Partition was not useable in version 5.7 and i have not read much about version 8 yet. So...
  2. Replies
    18
    Views
    1,063

    Re: Mysql Nested sub query

    Zvoni, i interpreted the OP's question with the SQL statement I created. Yes, you are correct, a LEFT JOIN would be a better option if the OP wanted all items, and the last purchase for each if...
  3. Replies
    18
    Views
    1,063

    Re: Mysql Nested sub query

    wqweto, you are correct but the OP did not include that in their requirements, nor did they indicate that in their own sample SQL that they tried. Had those indicators been there, the SQL statement...
  4. Replies
    18
    Views
    1,063

    Re: Mysql Nested sub query

    I use MySQL 5.xx and the following should work if you still need a solution.


    SELECT `i`.`item_code`
    , `i`.`item_description`
    , `i`.`item_unit`
    , `ip`.`order_number`
    , `ip`.`order_date`
    ,...
  5. Re: VB and crystal reports yearly reports shows different dates

    I'm not an SQL Server expert but some DBMS use Date as a reserved word that will return the system date in some or all cases. You may have to enclose the field name Date as [Date].
  6. VS 2015 Re: How to print spicific data in crystal report..

    Have you worked through the report wizard in Crystal Reports? If so what problems did you have with it?
  7. Re: Unable to connect to any of the specified MySQL hosts

    The only other option I have had to work with is when upgrading from an older MySQL version I had to add


    SSLMode=None

    But I think the error message indicated this as a problem. Sorry, I have...
  8. Replies
    4
    Views
    901

    Re: error while returning values from API

    Without testing, I think Peter is correct.
    Shouldn't

    .Account = If(IsDBNull(sdr("Account"), String.Empty, sdr("Account")),

    be


    .Account = If(IsDBNull(sdr("Account")), String.Empty,...
  9. Re: Unable to connect to any of the specified MySQL hosts

    Is there any chance the port is not the default 3306 and you need to specify it in the connection string?
  10. Replies
    5
    Views
    1,542

    MsOf365 Re: MS Access Form ComboBox Data

    Prahlad

    Thank you for your instructions. It helped me learn more about the user interface of Access and now I can more easily setup a Combobox with queries. I don't think the Listbox is a good...
  11. Replies
    5
    Views
    1,542

    MsOf365 Re: MS Access Form ComboBox Data

    Thanks westconn1.

    The combobox is set up with a query written into the Row Source field. I assigned the query directly and changed the query to prompt for a date the user could enter manually but...
  12. Replies
    5
    Views
    1,542

    MsOf365 [RESOLVED] MS Access Form ComboBox Data

    I have a request from a client and I am not very familiar with the Access data model, so I need some help. This Access database was created by a previous employee and I have been helping the client...
  13. Replies
    1
    Views
    426

    Re: text object in crystal report

    What you probably need is to set up each text object in a different section. You can right-click the left side where the section labels are and select Insert Section Below.

    If your text object is...
  14. Replies
    6
    Views
    1,772

    Re: Adapter not filling datatable on second run

    Ok, I'll test this again another time on a different scenario when I have a bit more time. I've set it up to read the data with a MySQLDataReader that will load the datatable and created my own...
  15. Replies
    6
    Views
    1,772

    Re: Adapter not filling datatable on second run

    Start program and On First hit of button


    before line
    intCount = Adapter.Fill(dt2)

    intCount = 0
    dt2.Columns.Count = 0
    dt2.Rows.Count = 0
  16. Replies
    6
    Views
    1,772

    Re: Adapter not filling datatable on second run

    But it only executes successfully right after starting the program. While the program is running, the concept is that the data can be updated in the original database from another program, so I've...
  17. Replies
    6
    Views
    1,772

    Adapter not filling datatable on second run

    I am trying to learn how to properly work with adapters and I thought I had it working properly. The code below is triggered from a button on a form. The data in tblaccounts is pulled from a table...
  18. Thread: Blank Page

    by rasinc
    Replies
    2
    Views
    1,515

    Re: Blank Page

    In the Design view, your image is a blank page. Can you provide some more information on what you are trying to do?

    For example, if your goal is to just have a blank page at the beginning of your...
  19. Replies
    3
    Views
    3,305

    Re: Crystal report local variable

    This will likely give you what you want


    local stringvar Mor;
    local stringvar Aft;
    local stringvar Eve;
    local stringvar Night;
    local stringvar times;
    local numbervar count;
  20. Replies
    3
    Views
    3,305

    Re: Crystal report local variable

    In the future you might want to tell us what you get because "not as per desire" does not tell us that you get an error message. Tell us the error message. What you want is also not clear. On one...
  21. Replies
    2
    Views
    649

    Re: vb login with mysql

    I may not be the person to answer this but I thought I would give it a try.

    From what I am seeing, the program is operating as programmed.

    I am not sure that you even need the log in for the...
  22. Replies
    3
    Views
    647

    VS 2010 Re: How to record macro? Help

    I don't know about using macros in VS, but you might want to look into using Code Snippets.
  23. Replies
    4
    Views
    859

    Re: Trying to Group by a Date Field

    I don't known if this will help because I do not work with SQL Server so my SQL is not necessarily correct, but I have never done a count on a formatted field, let alone grouped on it. I don't know...
  24. Re: Helpless to show multiple records on crystal report page separately

    OK, glad you got it worked out. Make sure you mark the thread as Resolved so others will know there is an answer. Use the Thread Tools menu option at the top of the page to mark it Resolved.
  25. Re: Helpless to show multiple records on crystal report page separately

    I am not quite getting the concept here. Normally the records you return from the database will show in the Detail section. You can then set the Detail Section to have a New Page Before or New Page...
  26. Re: How to make my class parameters like .NET classes

    You might be referring to placing your cursor above a sub or function declaration and entering '''.

    This will then allow you to put in a description summary and a description of what it returns if...
  27. Re: How can I "copy paste" a existing table command with a stored procedure one?

    Your OP indicates you added the side by side with the original table, not replacing it by changing the source of the table data.
  28. Re: How can I "copy paste" a existing table command with a stored procedure one?

    On a copy of your report so you don't alter the original, try changing the DataSource using the Set DataSource option on the Database menu (these are menus in the stand-alone version but should be...
  29. Re: How to sort data in crystal report using selection formula codes

    What happens when you click the "Suppress Blank Section" checkbox in the Section Expert? I suspect it will make no difference because of the drawn line.

    Unfortunately your second image does not...
  30. Re: How to sort data in crystal report using selection formula codes

    A record selection formula is for filtering what data is returned from the data source. Once the data is returned to the report, you use the features of Crystal to format, sort, do calculations,...
  31. Re: Get date from table according to a pre - stored procedure run.

    Ok, so the Crystal Engine installed is more current and therefore will support dynamic parameters. I don't know which engine you have installed but if it is greater than service pack 14, then you...
  32. Re: Get date from table according to a pre - stored procedure run.

    Just one last thought. I don't know how much you have explored the other reports but just because you don't get a prompt when running them, doesn't mean there isn't a parameter in them that is...
  33. Re: Get date from table according to a pre - stored procedure run.

    Either you are stuck with having an error and seeing if you can get a Dynamic parameter to show the company codes using your more current version of the Crystal Designer, or explore the third-party...
  34. Re: Get date from table according to a pre - stored procedure run.

    I think you are stuck. From what you have said and if I have this correct, without control over the program that calls the Crystal Report, you can't pass in the parameter you want. Therefore if you...
  35. Re: Get date from table according to a pre - stored procedure run.

    Sorry but it looks like you have the Crystal Print Engine from version 8/8.5. This engine does not allow for Dynamic parameters as I showed in my image Parameter Setup in Post #5 above. That image...
  36. Re: Get date from table according to a pre - stored procedure run.

    Dynamic parameters existed in Crystal XI c 2005 and I just checked VS 2015 and it allows me to create a dynamic parameter as well. So while my images were from the stand alone CR2011, it is...
  37. Re: Get date from table according to a pre - stored procedure run.

    Original Data in Table - not exactly the same as your's but similar in the fact that you want to select from the first column only to get the rest of the matching records
    139699


    Parameter setup...
  38. Re: Get date from table according to a pre - stored procedure run.

    I would look at using a Dynamic parameter that pulls it's values from the field in that table. It will prompt the user for a value in a dropdown. I haven't used them a lot but I believe it pulls a...
  39. Replies
    3
    Views
    2,627

    Re: Crystal with mysql and datagidview

    One approach would be to create the report on the same table. Use a parameter in the Selection Formula of the report and then feed in the id selected in the datagridview to the parameter as a...
  40. Re: Combine Two Complex count queries from Two tables

    I would start with whether each one will return results.

    Then depending on error messages you may or may not be receiving, I would look at the LIKE statement. I have never used a LIKE in a JOIN...
Results 1 to 40 of 477
Page 1 of 12 1 2 3 4



Click Here to Expand Forum to Full Width