Search results for query: *

I have about 5 text fields the need to be converted to a number, modified and displayed. When I try to convert, I lost 90% of the number. If the text was .677655576821 and it needs to be converted to a percent with 6 numbers after the decimal, it needs to change to this 67.765576%. Crystal...

I am trying to create a grid layout which there is conditional backround color of a field in CR 8.5. If left({procRptSummaryBySiteGradeSpan;1.vcProResult},3) = "yes" then green else if {procRptSummaryBySiteGradeSpan;1.vcProResult} = "No" then Red else What would I place in here if I want no...

I am generating a deatils section in CR8.5. In the page fotter, I need to place a legend there to show what the symbols and colors stand for. I cannot seem to find a funtion in CR that will allow me to create this without making a chart. Is it possible to make a grid or a table to hold this...

what is the char() reference for a tab field? What i am trying to do is create a legend table and I have no chart, just the fields. I was originally hoping just to insert both the key and the descr fields. Well, now I need to add spaces. Was contemplating just drawing a line between the two...

I have several fields I am trying to format in formulas. The problem is when i convert them to text, the formatting keeps changing from what I want. Cstr(int(year(currentdate)))+ "AYP Status" How do i remove the columns and decimals within the formula? I have tried changing the global...

I have several rows duplicated in my temp table that contain text and objects. As I am creating the procedure to create the table, is there any way of filtering out to insert only 1 record per ID? I have tried grouping and selecting distinct, however because of the text fields, it will not...

I think I can do this with a case statement, however, I am not 100% sure of the syntax or how to do this. What I have done so far is created a temp table with all the fields I need. I have 20 user defined fields that I need to export as a single record from a 1-many relationship. I started...

I need to convert this query from SQL Server to Access. Any help would be appreciated. Thanks in advance SELECT dbo.Project.PROIDNO, dbo.Project.PROOFFICE, dbo.Project.PRODEPT, Employee_1.EMPSNAME AS Pic, dbo.Employee.EMPSNAME AS PM, dbo.Project.PROLNAME FROM...

Somehow my Db is being a pain, I cannot seem to link my sql Server view to access. Keeps giving me an ODBC error when trying to run it. I need to rewrite this query in access. Any help is appreciated. SELECT dbo.Project.PROIDNO, dbo.Project.PROOFFICE, dbo.Project.PRODEPT...

I have a view in SQL serever 2000 that I was trying to link to access. However every time I linked it, I could not open the table. So I need to rewrite this view in access. I am not an access programmer, so my SQL seems to be off in this, even though it runs fine in SQL Server. SELECT...

I am having a brainf*&*t today. Simple string query to remove the first character off of the string. They could be various lengths so just need to cut off the leading char.

I have to generate a text file for an application to pick up. I have the query written, however cannot execute the query in the DTS package. Also tried creating a view, but i cannot find the view in the list of source data to go to text. Here is my query: select ('"' + p.wbs1 + '"'),('"' +...

Currently using Access 97. Will be upgrading to access 2003. What coding issues are common on an access project with multiple modules, forms and macros? Thanks in advance

I have a client using Access 97... yes 97. They want to upgrade from 97 to 2003. They have various forms and a lot of VBA code. Was there any major change between the 97 version and the 2003 versions of VBA that I need to be aware of? I am trying to estimate how much time this will take and...

I started writing this stored procedure and it keeps claiming: Server: Msg 16915, Level 16, State 1, Line 23 A cursor with the name 'statcur' already exists. Server: Msg 16905, Level 16, State 1, Line 25 The cursor is already open. here is the code as I am not at my best today: declare...

I am trying to do an upgrade, but before I can do it, I have to remove all instances of the prior control. I have walked through this project step by step, but yet when I try to remove the reference, I keep getting the same message: Can't remove control or reference; in use How do I find the...

I am trying to do a sum on amount (t_amnt) but I need to know whether it is a debit or credit first. it is stored as a binary field, however I was able to get the value of debit = 0x01 and credit = 0x02. Anyone know how I can write this to process correctly? sum( case when t_dbcr = '0x01'...

I have 2 tables Tbl1, tbl2 and both tables have a record in it: rec1. What I need is a statement that will allow me to get all the records in tbl1 where they are not = to the record in tbl2.

Hi, I am trying to write a view for a report and have come acros a field that is displaying <Binary>. This field should be either 01 or 06, but for the life of me I am not sure how to convert it so I can implement the view.

I am running CE9.0. I created this report with CR Pro 9.0 with an ODBC link to SQL Server. When I uploaded this to CE9.0 I keep getting a looping logon. I set up the ODBC on the crystal server and cannot figure this out. Please help new to Enterprise.