Search:
Type: Posts; User: rasinc
Search:
Search took 0.04 seconds.
-
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...
-
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...
-
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...
-
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`
,...
-
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].
-
Have you worked through the report wizard in Crystal Reports? If so what problems did you have with it?
-
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...
-
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,...
-
Is there any chance the port is not the default 3306 and you need to specify it in the connection string?
-
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...
-
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...
-
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...
-
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...
-
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...
-
Start program and On First hit of button
before line
intCount = Adapter.Fill(dt2)
intCount = 0
dt2.Columns.Count = 0
dt2.Rows.Count = 0
-
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...
-
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...
-
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...
-
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;
-
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...
-
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...
-
I don't know about using macros in VS, but you might want to look into using Code Snippets.
-
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...
-
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.
-
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...
-
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...
-
Your OP indicates you added the side by side with the original table, not replacing it by changing the source of the table data.
-
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...
-
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...
-
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,...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|