Recent content by craigK

Is this something that is in Crystal or is it a Windows thing?

Unhandled Exeception Error Occurred in crw32.exe [3636] i got this error while setting new datasource for the report. I put a lot of work into this report today, now it gives me this error every time i try to open it. Running XI SP4 Hotfix 12. i also tried opening the report with version 9 on...

Thanks, that's good to know. i am surprised that from an aesthetics point of view that CR would not allow this to happen. Maybe there is not a big need to create column headers from formulas so they can be flexible? Anyway it was just my personal preference to anchored my column headers to a...

CR XI Can't seem to figure out how to vertically align the data in a text box with can grow option enabled, or is this not possible? I would like the cells to be vertically aligned to the "bottom" of the text box.

Why can't you copy parameters between reports anymore in Crystal 11. i used to be able to do this in 9.0. Does anyone know?

it took 15 minutes, but it did complete and it does look like what i wanted, so i'll do some testing and see if i can figure out why its running so long on my system. i really appreciate your help with this. thanks

Thanks, i understand now. I tried to run it in Query Analyzer against about 10,000 sample rows of data and it's been running for 10 minutes.. I'm not sure why that would be. i'll set up crystal to use this query and see if data is returned faster when there is a WHERE condition.

i'm having trouble understanding how to incorporate the date and amount from my data into this. Sorry, i haven't done a lot of sql. will this work in a view?

Last 30 days exclusive of the date displayed. I am using Crystal reports, but because i need the current data grouped by day, i found impossible to do without subreports, which killed the performance.

I'm trying to create a view that will display a single day as well as last months data based on the date of the data. Rolling on each day. Data is like this: Date Current 5/15/2008 30 6/1/2008 100 6/2/2008 50 6/29/2008 25 6/30/2008 10...

Thanks for your help Denis. It works perfectly!! i thought i would post the final product in case it might help anyone else trying to do something similar. CREATE TRIGGER [ParseSIPAddress] ON [dbo].[CallData] INSTEAD OF INSERT AS BEGIN INSERT INTO CallData (CallId, PhoneNumber)...

Thanks for that. Can you give me any guidance on how it incorporate this into the INSTEAD OF trigger?

So, it might be possible to use an INSTEAD OF trigger? This is specifically what I'm trying to do. TABLE CALLDATA If PhoneNum = SIP:3025551212@10.1.1.200 THEN strip out the SIP: and everything to the right of the @ sign including the @ sign. THEN insert formatted phone number into PhoneNum...

The problem is i do not have control of the application that is sending the data. I do have access to the database so that was my thought for a trigger, but it doesn't sound like i can do a data validation anyway? There are many reports that access the data that all have to be changed unless i...

I have to do a data validation on the DB level and would like to re-format the phone number before it is inserted. I am thinking to implement this by a trigger. I rarely have to do something like this and don't even know if it is possible. Any help or advise would be appreciated. thanks,