Recent content by nlaliberte

Okay, So the issue was really with the title being displayed in the Group Footer, the fields in the detail section were strictly debug fields. I'VE FIGURED OUT THE CAUSE OF THE PROBLEM, though I still don't quite understand why this was an issue. The code in the Custom Function read...

Unfortunatly they all do have the same values, as that was the first thing I checked. The values are the same when both inserting the fields in the detail section and running the stored proc through Management Studio. {proc.group2_type_id} = 70 {proc.group2_value} = -1...

I say they are all on the group level because Group 2 is being grouped on the {proc.group2_display} field. However, this field is governed within the procedure by the combination of {proc.group2_type} and {proc.group2_value}. So essentially the three fields combined are what make up group2.

The fields that the formula is referencing are all on the group level, and one of them is the field that I am grouping on. If I put the formula in a seperate formula object ('test') than it returns the desired result on a per record basis. Also, the reason the only time GF2 says 'Linked' is...

I'm using Crystal XI on an OLE DB connection. This is the strangest bug I've ever encountered in a Crystal Report. Here is the situation: Group 2 has 'Use a Formula as a Group Name' selected. In that formula it states; IF {proc.group2_type_id} = 70 THEN IF {proc.group2_value} = -1 THEN "...

I'm using Crystal XI and an ODBC connection to a SQL server. This issue is that an excel export is displaying zeros in cells that are supposed to be NULL. These are summary fields in a total line that are conditionally set to suppress. These fields are dynamically set in the stored proc that...

Good Morning I'm using Crystal XI and an ODBC connection to a SQL Server. I'm running a report off of a stored procedure that calls on a datetime parameter (@report_date). I would like to prompt the user for just a DATE, and leave out the timestamp, however once I connect to the procedure in...

hilfy you were correct. I happened to figure this out just testing it out, but I came back and saw you're response and it's definitely the way to go. Resetting the page number will also reset the 'M'.

Basically what I'm trying to accomplish is running what looks like multiple reports all in one shot. Each instance of the group should have it's own report, which means starting a new page and resetting the page number. However, the user would like to have a 'Page N of M' field in the header...

I'm using Crystal XI. What I'd like to do is conditionally suppress one of the parameter prompts based on the values selected in another paramter. The functionality is as such; The report has three sections and the user has the ability to pick any/all of these sections to display. IF only...

Thanks Scott... but do repeat the verbage in one subreport 4 times is basically the same as calling the same subreport 4 times. If we have to make a change we still have to make it 4 times in either situation. I agree that storing the verbage in a word document and calling that with an OLE...

There is only 1 record of data, which is why I need a repeating section as opposed to just suppressing >4... We would also like to avoid building a 'dummy' proc or pointing it to any database object simply to get 4 records. The current proc on the main report will only return 1 record as...

I get what you're saying, and that's a good idea. Unfortunatly the static data is more like a form that is printed along with the report. It contains several instances of text along with places for a client to fill in information. Currently we have it in a subreport, and we repeat the...

Good Afternoon, I'm using Crystal XI and an ODBC connection. I am working on a report that has a large section of static data, 'terms' if you may, that needs to be repeated 3 times, one after the other, per record. Maintaining these as 4 seperate sections could prove to be pretty tedious...

Good Afternoon, I have a simple relationship table that I need to add a contrainst to. The table is supposed to be a parent/child relationship, as well as the date the relationship is effective. See Below: CREATE TABLE relation ( child_id INT ,parent_id INT ,acq_date DATETIME ) We have...