Search results for query: *

Hi all, Thank you all for your suggestions. I have already tested them and it works! :-) Cheers, Chris

Hi rjohn Thanks for your prompt reply. I already replaced the @String with @List. Just one last question, can you provide a sample how to use this? :-) I'm still kinda new with UDF in MSSQL. Can you relate it with the example I mentioned above. A basic query showing how to use this syntax...

Hi there, I'm quite new in MSSQL. I'm having problems creating my custom query in MSSQL syntax. Background: I need to separate the string value of one field into separate columns. See example below. OriginalField TRUE,FALSE,Victoria,Phone,"Application Today",... I need to create a query...

Hi Bob and huggyd, Thanks for your tips. Will surely help me with my reports (both for 8.5 and 9.0). Regards, Chris

Hi there, I'm using Crystal Reports 8.5. I have a report wherein users can drilldown the crystal report for more info. I'm having problems with my report format (aesthetics) reg. drilldowns. Question: Is there a field or function that will tell me if I am on a drilldown page or if I am on the...

Hi there, I'm currently creating a stored procedure. I would like to group my data by hour. Not sure which command to use. My database source looks like the example below: 10/01/2005 01:25 Tom 10 10/01/2005 01:25 Tom 15 10/01/2005 01:30 John 25 10/01/2005 02:30 Tom...

Hi dgillz, I get this error in Crystal Report 8.5 when I tried to add the stored procedure in my report. Like I mentioned earlier, I do not get this error when I am using Crystal Reports 9. Also I have tested the stored procedure in SQL Query Analyzer and it works fine. Any ideas? Thanks...

Hi there, I am using Crystal Reports Dev 8.5 and the database I am using is MSSQL 2000 with SP3. I have created several stored procedures which I would use in my crystal reports. Now when I try to access the stored procedures in Crystal Reports, I get an error "Syntax error or access...

Hi, I'm not familar with all the Crystal math functions, just would like to know if there is a Hex to Decimal function (converter) that I can use in Crystal Reports? Currently working on reports where I need to display raw values (Hex) in Decimal form. Thanks in advance. Regards, Chris

Hi, I am using CR 9.0. I'm currently using bar charts to present my data. My data consist of dates vs sum of a particular field. They DB look similar like below: Field1 Field2 10/01/04 102 10/02/04 346 10/03/04 223 ... 11/01/04 987 11/02/04 214 11/03/04 567 ...etc. Everyday there...

Hi Guys, Thanks for the quick reply. I believe the minimum and maximum functions on the dates should do the trick :) Cheers, Chris

Hi, Just would want to ask how can I put in formula the start date and end date of my report based from the database fields (datetime)? Not sure if its OnFirstRecord function? Basically I'm in charge of doing the reports only. I have no control over the database fields. My report consists of a...

Thanks guys. Will try this out. Cheers, Chris

Hi, Currently I have created two groups (Date and Names) in Crystal Reports. My reports look like the ones below: 10/24/2004 John Doe Lisa Marie John Preston etc. 10/25/2004 Erwin Days Selvis Richmond Welwin Darrack etc. I would like to achieve the above with the...

jacob200, You can try to generate by creating an Address group first in nPOVisualizer. Specify the IP address you want in Address Groupings. You can actually add additional IP address in every group. Then generate the Traffic Analysis Report from Custom reports. Choose the group you created...

Well I have resolved my problem by creating another "time period" table like what synapsevampire suggested. I have created two tables, "per hour" and "per minute" tables. I have joined my original tables with this new ones. I am now using the time fields in these...

Hi Sonny, I'm not quite sure what you're asking. If you want to have trendlines in your report, there is an option in Crystal reports to set it up. See steps below. 1. Right click the graph (line chart for example), 2. Click Format Chart->Grid. Go to Group Axis tab. 3. In Labels tab, you can...

Thanks guys for all this info. Currently we are only backing up the database our Crystal reports are using (SQL Server). Regards, Topy

Hi, We have posted our Crystal reports via Crystal Enterprise and currently using it in production. Our main fear now is if ever we encounter any hardware failure (such as hard disk failure) in the future. We would want to restore the Crystal Enterpise as quickly as possible, with minimal...

Thanks for the tip. I was just hoping that there is already a built-in function (running fields, crosstab, etc.)in crystal that would automatically do this for me :) Well anyways, I'll just create a new table like what you suggested. Thanks again for this tip. Regards, Topy