Search results for query: *

That worked just as I needed it to. Thank you very much!

I am using the following formula and get a "Bad Number Format String" error: If month(currentdate) = 1 then ToText((year(currentdate)- 1),"yyyy") else ToText(year(currentdate),"yyyy") If I remove the formatting argument on the second line of code as the following, it works: If...

Thank you for all your help!

It is working now. I created all the variables correctly, but I didn't actually use the variables in the subreports. Once I placed all of them in the subreports, they calculated corrected in the main report.

Yes, I see data in the subreports. Everything works and displays exactly as it should except for the shared variable value in the main report.

I am not suppressing any sections of the report. However, I do see that the subreports are not linked to the main report as you suspected, and I assume this is the problem. Unfortunately, I have been unsuccessful in trying to link them, as I am not familiar with it.

I get a value of 0 for all formulas in the main report. When I use the variables in the subreports, I get the correct values.

I currently have a subreport in sections Detail B, Detail C, Detail F, and Detail G. I placed the formulas in Detail H and it did not work. I tried it again by placing all four subreports in Detail B and the formulas in Detail C. This did not work either. Any suggestions on what else could...

I am attempting to pass values from subreports to the main report and the resulting values are 0 rather that the correct value. Where is my error? I am using a main report that contains 4 subreports. Each subreport contains a formula that creates a shared variable. The formula in each...

The problem has been resolved. In the database options menu, "Tables" should have been selected in the Data Explorer section. Thank you for your assistance.

That is what it has normally done, and I just began having this problem yesterady.

It allows me to choose the file and it adds the file to the list of connections. However, it does not allow me to add it to the selected tables section.

I am trying to create a connection to an Excel spreadsheet in the database expert in Crystal Reports 11. When I create the connection, Crystal does not recognize the worksheet in the spreadsheet, but only says "Add a Command" below the connection. What am I doing wrong?

Thank you! This worked for me.

I want members who have the code fchfen, but do not have the code fepedb. A member can several records with several different codes, but I only want members who have a record with fchfen and do not have a record with fepedb. For example, if the records below existed in the table, Member1...

I have members in a table that are assigned a HMP Code, but a member can show up in the table several times with differnt HMP Codes. I would like to extract members who have a record with HMP code "fchfen", but exclude those members who also have a record with an HMP Code of "fepedb". I am...