Search results for query: *

I am hoping you can help me. When you look at the view below, do you know why multiple rows are being created, instead of the fields displaying in one row? Could it be because of the “else null” in the View script? Do I need to group something? I just don’t know how to get this done. ALTER...

Perfect! Thanks so much for your help!

I believe the Crystal formula with the "0##########" is adding a leading zero and the "#" represents the length of the field. With the cast function, what is the syntax for Cognos 8.4 to dictate the fixed length? If I have a numeric field that I am converting to varchar, I would normally do...

I am new at Cognos and working contract for a company using Cognos version 8.4. I have used Crystal Reports since version 4, and I am seeing so many functional differences between the two. I desperately need someone's expertise. I have searched on the Internet and cannot find a solution. I...

Is it safe to do the BACKUP LOG databasename WITH TRUNCATE ONLY, while users are logged in?

I need to convert an amount to a fixed string of 15 characters with leading zeros. I had this working when I did not need to include decimal places. Now, I have to include the full amount. Example: 1457.70 was 000000000001457 I need it to show as 000000000145770. I must have missed...

I have imported data where I need to strip out (exclude) certain records. I will then take those records to invoice from. How could I do a "not equal" join? Tables: tblMarchTransactions, tblPLSUserIDs I basically need to see all fields in tblMarchTransactions, but I need to exclude any...

In an earlier thread, someone suggested using this code to figure the Invoice #, instead of using Autonumber. My question is where does this code go? Dim varID As Variant With recordset .MoveLast 'Moves to the last record varID = ![ID] 'Gets the number first varID = varID + 1...

I am new to ASP, and I'm responsible for correcting errors written by previouse programmers. Can someone tell me what is missing in the following code? There is a calculation and it should be formatted with dollar sign (currency).. <th...

I am trying to correct an exporting issue with Crystal 10. I downloaded the Hot Fix from the Business Objects website, dbex10win_en.zip. It was supposed to update the u2ftext.dll file, but it didn't. Does anyone have this version of the u2ftext.dll - dated 12/15/2004, version 10.0.5.596? If...

I am trying to get started with learning SQL Reporting Services with VS.NET, so I would like to download the "free" version of SQL Reporting Services. I found where I can download the 120-day Evaluation Edition, but how do I get a non-Evaluation edition of SQL Reporting Services? Another thing...

I have been fighting with this issue for a few weeks now. I have a client who has to send a file to their bank, and the format of the file is very specific. I created a Crystal report to pull the data out of the database. The header, detail, and summary records all require a specific # of...

Can someone tell me the syntax to create a SQL table that would calculate weeks in a year, using Saturday as the week ending date? Example of data in proposed table: Week_num Week_end_date 01 01/08/2005 02 01/15/2005 03 01/22/2005 ... and...

Does the CR or line feed count as a character? Example: The line needs to have 184 spaces at the end. Would I use something like Space(183) + ChrW(013)? Thanks. Sheila

Has anyone come up with any better way to export a report to a text file and not have spaces on a line truncated? I have to have a certain # of spaces after each line for use in a mainframe system. It is unacceptable to my client to have to export to a rich text file format, then open that...

Is there a way to make a numeric field, i.e. 1234.56, to always have a fixed length of 12 with leading zeros? 1234.56 to be 000000123456 Any help is greatly appreciated!