Recent content by DallasAggie

Malcom, I just tried restoring (taking away commonXI_win_en) and still have the same problem :( ... Even after the reboot! I'm back to only having the Advanced DHTML as the only viewer working. Any other info from any one would be greatly appreciated. Regards, Robert

I've exported into Excel (data only) and Crystal automatically creates a new worksheet to carry the data over. If you don't want the seperated worksheets, then (if you have CE10) I would recommend exporting to XML...That's what we've done for exports that we needed to import into some other...

oops: For ProcessDate do this: Len({ProcessDate}) <= 0 .. my bad! lupins46, thanks for catching that....the suprress logic needs to be in your ApprovedCost field...

What version of Crystal? Version 9 has : ToWords() That you can use...not sure if available in prior versions.

Wha??? The parameter you enter is going to be static! If you are placing the param in the details section and want to add it up, then create a formula that takes the total number of records * parameter {?Parameter} * RecordNumber If you need a total for groups, then that'll be a little...

Who are you responding to? me or lupin46 ? Also ... That's what you asked for in your initial post You need to give more detailed information, cause that's what I thought you wanted to do...

to my knowledge, no. I use commands or stored procedures to perform all the work .. and let Crystal do as little as possible. .. just my flavor :)

I just tried using that formula lupin46 .. some reason it didn't work. I did this: In DueDate Properties, go to x-2 next to suppress Len({ProcessDate}) > 0 For ProcessDate do this: Len({ProcessDate}) <= 0 That seems to work fine on a sample report I just did... The IsNull should have...

UPDATE: go to Report - Process - Parameters -- > Check "Clear the current parameter value(s)" --- Click "Submit

Did you publish it to Crystal Enterprise? If so, go into CMC and check out the paramater properties...it could be that when you loaded it, it set some default parameters...just go in and set them to 'none'. Other than that...no idea.

lbass! You ROCK!!! That is awesome! Worked exactly the way I needed it to work. WooHoo! :) My boss will be happy that I don't have to put the page number on top of the page now :) Thanks, dA

I'd be curious too. We have a ton of tables where the data isn't very friendly for this type of view. I've been using Running Totals to get the data I need, in the format you speak of. It is very time consumuing, but I think it looks better than the crosstab, and all the columns/rows show too :)...

Here's a good definition: http://www.techonthenet.com/sql/joins.htm

check the version of Crystal Reports...I know you have v9, but do a Help-About in Crystal to get the full version number, then in VS.NET, do a Help-About too...there, you should see the Crystal Version. 1. Update your Crystal Reports v9 with the latest updates/patches. 2. Update VS.NET with...

The code you have really doesn't give much to trouble shoot...inlcude the .aspx code-behind code please. OR It could be that your CrystalReprotViewer object is not the right version. Try deleting it and re-adding the control...make note of: <%@ Register TagPrefix="cr"...