Search results for query: *

Ok, I got this to work. I had to create the funcation as follows to account for nulls: (IF ISNULL({#RTNotAdmin}) THEN 0 ELSE {#RTNotAdmin}) + (IF ISNULL({#RTAdmin}) THEN 0 ELSE {#RTAdmin}) Everything works now. Thanks.

Looks like the TotalQty values only display when there are records that meet the Evaluate formula in both running totals.

Ok, I apparently don't know how to create a formula. I re-created my formula and I was able to create it without error now. For some reason before, my running total vars were not showing up in the formula workshop window to select. So, I was able to create the formula TotalQty as...

When I create a formula with the following: {#RTAdmin}+{#RTNotAdmin} I get the following error: "This field cannot be used because it must be evaluated later." Maybe I'm not creating the formula correctly? I selected 'Group Selection' and put the above code there. I created a running...

Could you send me the code for your formula please? Maybe I'm doing something stupid since I haven't been using Crystal for very long. My running totals are reset on change of group (my original post has changed) and I want to put the value of the formula in the group footer.

If I had a Max and a Max instead of a Sum and a Max, would I then be able to combine those?

I don't have to use running totals, I can use all formulas if that's how I can get it to work.

Are you saying this is not possible? I want to get the sum of all quantities where the lesson title <> "Admin" and the max of all quantities where the lesson title = "Admin" and then add those two values together and display that total in the group footer. I want to do this by group.

I'm using Crystal X. I have a subreport that contains two groups. In group footer 2, I have created two running total fields. I want to display, however, the sum of these two running total fields in group footer 2. Is this possible? If so, how? Here are how my running total fields are...

I'm using SQLServer 2000 and I have several tables that have fields of TEXT data type. I have a .Net application that allows a user to insert new records with new TEXT field values or update the TEXT fields in existing records. I'm using a straight sql UPDATE statement to update the TEXT value...

That's the best news I've heard all week!! Yee-hah! Thanks for your help. Now I can be confident about my app working properly knowing that.

The updates also worked with over 72K characters in the text fields. I'm baffled.

Ok, my inserts work with no problem and shockingly my updates work as well without having to change any code. And I don't understand why. Can anyone explain this? I thought I had to use pointers to get and write updates to text fields. Maybe I didn't test with long enough data? I input a...

I know the TEXT datatype wlil be deprecated. I actually did the development of my app using a SQLServer 2005 Express db. I didn't have much choice actually, but I guess I could've pushed harder for another db server if I had known how much of a difference there was between 2005 and 2000. So...

I will try the insert first, so I guess that should work. I have seen examples of updates TEXT fields, so I will give that a try as well. I really don't want to delete the row and insert a new one. That just seems kind of ridiculous to have to do that, plus that would be a pain because I have...

So you think inserting will work, but updating won't? Is that what you mean? When that field gets updated, I want to replace the entire thing, not just part of it. Does that matter?

I'm using one of the awful datasource controls as follows: <asp:ObjectDataSource ID="LADataSource" runat="server" DataObjectTypeName="LA" InsertMethod="InsertLA" SelectMethod="GetLA" UpdateMethod="UpdateLA" TypeName="ISDFormsDBManager" OnInserted="LADataSource_Inserted"...

This problem is driving me crazy and I can't find anything about this anywhere. I am using SQLServer 2000 and VS2005. My database table has a field of TEXT data type. I want to allow the user to input a value for this field via a formview, so I've created an asp:textbox control on the...

Thanks for the link. It makes me feel better to know there's a problem with Crystal and not with me. I was going crazy. It turned out that I could not find the 'Snap to Grid' feature to turn it off and I finally found it under File - Options. But even after I turned that off and also use...

This has got to be a simple answer. I am having the toughest time aligning and sizing my field objects in my report. I'm trying to get exact heights, widths, and x/y coordinates, but Crystal always seems to change them automatically for me and it's driving me insane. For example, if I change a...