Recent content by CrystalDuck

You make a good point, paulmarr. I hadn't really thought about that. Thank you for your input, and I think I will take your advice and put the headers and footers in the report itself. I think it might be even more maintainance with the subreports, if it ever did come to pass that something...

I have a bit of a problem, and am wondering if I can avoid making several versions of the same report just to accomodate the size of the page. First of all, I just began using CR 10. And am still farely new to it. But I've been using Crystal since before version 7 so I'm pretty familiar with...

Thank you so much...it's amazing the speed at which it goes now. *wow* Big difference! Thank you both so much for your help. Sincerely, CrystalDuck [ponytails2]

Thank you for the quick response, MrDenny...I kinda figured that's what it would take...but I am very unfamiliar with creating indexes. I even went looking Indexes up on BOL...but don't have a good enough example to go by. I know this makes me look "tres stupid" but any help on how to get...

Well, I can't seem to figure out why this works this way, but I will try to explain. I have data out of 4 different tables that I need to pull together. I have split them up into invidual temp tables, because when I try to pull it into one temp table it takes well over an hour. (And even...

Okay...I researched a little further and found a perfect solution. I got it out of one of the FAQ threads...but now I don't remember which one. Sorry. *sheepish grin* But here is the code I used. I had to create a function (dbo.Split) then use that to parse out my comma separated values...

I've found numerous posts on the site that has very similar questions to mine...but nothing quite "on the money". So I thought I would post the code I am using and see what I'm doing wrong. All I get back is a dataset for the #Dealer_Number_Search that looks like this: Dealer_Number...

I wasn't originally doing it that way...but after reading a few of the threads on this site, this was the advice I had picked up. But obviously I was WRONG! Or at least that's the message I got loud and clear from you. I HAVE to dump it into a temp table no matter if I do the dynamic SQL or...

I am on SQL Server, rtying to hit an Oracle database, and feel like I'm so close, but it just don't wanna take it....help. DECLARE @previous_date smalldatetime, @cmd varchar(4000) --DROP TABLE #OPEN_CLOSE_ALL Create Table #OPEN_CLOSE_ALL (PRI_ACCT_ID varchar(14), SHRHLD_SHORT_NAME...

({VW_TB_ACCOUNT.TOTAL_SHARE_AMT}*{VW_FUNDSTATION_NAV_POP.NET_ASSET_VALUE}) These are both long numerical values.

That worked like a champ, thank you so much!! :-) One more question...is there any way at all to group by this field. I know you can't right off the cuff...but is there a sneaky way around to pull it off? Thanks a million again! ~CrystalDuck [ponytails2]

I am working with Crystal Reports 8.5 and a SQL server 2000 data source though an ODBC connection. One of my co workers sent me this formula text and is baffled as to why it's not working. It's a little over my head, (honestly to me, it doesn't look like it would work at all for a few reasons...

Thank you so much...Funny thing I went looking at the Business Object Support site for this solution and found nothing. Guess I worded my inquiry wrong. You led me right to what I needed thank you!!! Sincerely, CrystalDuck [quack]

Okay, I'm using CR9...I am having no trouble exporting to a .csv file for the Export format. However when I use the Application for the destination, it automatically wants to open the .csv in Excel. Okay, so I only use the Disk File for the Destination. (since my file is over 65,000...

Thank you so much...I knew it had to be that simple. Sorry I had to bug you for something so miniscule. :~/ Thank you, CrystalDuck