Search results for query: *

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

I'm using Crystal XI. I'd like to put criteria on the 'On Change Of' in a running total. The report is run by two possible scenarios, 'run_by' 1 and 2. When 'run_by' = 1 I'd like the running total to never reset. However when it's run by 2 I'd like to reset on the change of my Group1 value...

I'm using Crystal XI with an OLE DB connection to a SQL server. I'm getting the 'Failed to Retrieve Data from Database: Arithmetic overflow error converting numeric to data type varchar' error but the odd thing is I can still run the proc just fine in SQL Management Studio. The error only...

I'm using Crystal XI and an OLE DB Connection. Basically I have a report that looks something like this. Report Header A Report Header B Report Header C Details Report Footer A Report Footer B The Report Headers and Footers are pretty important legal mumbo-jumbo, and it's very important...

I'm using Crystal XI and an ODBC Connection to a SQL Server. The issue I'm having is with a Group where 'Keep Together' is true is creating a blank page. Essentially Group 1 is the top group in the report, and each new Group 1 starts on a new page. I have Group 2 set to 'Keep Together' to...

Also an improvement on how I'm doing it... Thanks one more time MVP :) haha