Search results for query: *

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 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 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, 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...

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...

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...

Hi, I'm not sure if this is the right forum, anyway here goes: I have created reports in crystal reports. I use a line graph to show the Time vs. Usage report. Ideally, the database should look something like this, TimeStamp (x-axis) Usage (y-axis) 09-01-03 00:00 10329887 09-01-03...

Hi, I'm not sure if this is the right forum, anyway here goes: I have created reports in crystal reports. I use a line graph to show the Time vs. Usage report. Ideally, the database should look something like this, TimeStamp (x-axis) Usage (y-axis) 09-01-03 00:00 10329887 09-01-03...

Hi, I created a web site for my Crystal Reports via CE8.0 Web Publishing wizard. What I would want is when I access these reports, the window would be automatically be maximize. I have checked reports.csp file, and found this piece of code, <script language=Javascript> function...

Hi all, Can anyone give me a quickstart on how to use the &quot;Protocol Forcing&quot; in Sniffer. An example on how to use this option would be very much appreciated. Thanks very much. Regards, Topy

Hi all, Is there a way to generate the nodes (MAC Address) with errors (such as CRC, Jabbers, etc.) in Host Table to a report? Which file/database does Sniffer store these records? I have checked the csv files generated by Sniffer and for some unknown reason, Sniffer doesn't seem to log these...