Search results for query: *

All the programmers agreed to use a value of '12:00:00 AM' for sentinal values on DateTime columns for our database. The problem is that when we INSERT or UPDATE '12:00:00 AM' into the column it is stored as '1/1/1900'. Does anyone know a way to store '12:00:00 AM' in a DateTime column?

My SQL statement returns the correct number of records in the SQL Query Analyzer, but Crystal only returns one record. Crystal Record Selection Formula: {TblMaster_Schedule.DayOfWeek} = {?DayOfWeek} And ({TblSpotChanges.DateEffected} = DateValue("8/1/2004") Or...

I know how to join tables in different databases, but I can't seem to join tables that are on different databases and also on different servers. Is there anyway to do this? If anyone knows the syntax please let me know. Thanks.

I am using a crosstab that has given me problems. I am wondering where the crosstab pulls data from, if you were to compare it to a report. I realize it is in the footer of the report, does that mean it uses subtotals of the information used in each group. I am getting weird results for some...

I have to create a report where there is information to be summarized from 1 of two tables: TblMaster_Schedule (1 to 1)-> TblMaster_Day TblMaster_Schedule (0 to n)-> TblSpot_Changes For the crosstab: The rows run off of The Location field in the TblMaster_schedule table and the columns run off...

I haven't really used variables so this is all new. For some reason the global array variable always sees element 1 as being "". I declare the variables in the page header and put the Formula below in a separate Formula Field. Any suggestions are appreciated. CRYSTAL SYNTAX...

I am displaying my Report through the CRViewer control in a VB6 application. I have a memo field that displays info with the Horizontal alignment set to Justified. It works fine in the report but it is left justified in the CRViewer. Here is how I load the Report Public Sub LoadCrystalReport()...

We have a Database where events are Scheduled with Projected data and Recorded with Actual Data. The Tables for Scheduling are the same as the "Actual" Tables. The Diagram Below is the Setup for our Tables with the Project Table as the Link. All Tables have a one to many relationship...

I set the RecordSelectionFormula in VB but if I get no records returned I don't want to show the report. Can I find the Number of Records Returned after I set the Selection Formula in VB???

I have a summary report and a detailed report. I want to make a link to the Detail report from the summary report. I did this by adding the Detail report as an on-demand sub report. The problem is that i can't figure out a way to link the Detail report back to the main report. how can i solve this?

i'm accessing a data field from a SQL server to display it in my report but for some reason the report will not display the field for one specific column of a table. I have displayed this information in other reports w/o problems and I even display columns from the same table in that report w/o...

I am loading a CR from a VB program and when the user selects a month it shows the different data for that month. Everything works fine when choosing the first month, but when the user closes the form, chooses a different month and loads the CR for the second time no data comes up. You have to...

I need to Write The Crystal Reports so that the information is separated on different pages by a change in the {Date} field. Is there a formula to insert a page break when the {Date} read from the database is different from the previous. Keep in mind I've been using CR for 2 days. This is what...