Search results for query: *

I need to format a currency field. I'm hoping someone can help me craft a format or forumla to display up to five decimal places but always display a minimum of two decimal places since this is currency. Database Value Report Display 35 35.00 35.5...

I wrote a function in SQL that returns a table of running numbers and totals. I don't know if it's possible to return a table in oracle or not. I know there are some differences between Oracle and SQL syntax so I started to modify my SQL function and pasted below. I am hoping someone can...

Hello All, I am trying to write a loop statement. It needs to reach each row in the result set and keep subtracting qty from qty_on_hand until a negative number is reached. The goal is to multiply qty by unit_cost for each row, but only until qty equals qty_on_hand. This means that sometimes...

I am using Reporting Services 2005. I need to calculate a "Payment Discount" by extracting information from a text field. The values in the field look like: Net 30 1% Net 30 20% Net 60 If a % exists in the field I need to capture everything to the left of the % sign since the percentage can...

I am converting a report from an old legacy system and I am not sure I can duplicate the functionality. I am writing the report in Reporting Services 2005 and looking for input or feedback. The legacy reporting system allowed the user to choose their own operator when querying a dollar amount...

I am converting a report from an old legacy system and I am not sure I can duplicate the functionality. I am writing the report in SSRS, but the query driving the report is SQL so I believe this is more a SQL question than a SSRS question. The legacy reporting system allowed the user to choose...

I need to format a currency field. I'm hoping someone can help me craft decimal and rounding formulas within a custom numeric style. I always need at least two decimal places displayed = Database Value Report Display 35 35.00 35.5 35.50...

I am trying to parse a string. I am quering a field called ACCOUNT_CODE from a table called PO_ACCOUNT. Each account code has 7 segment names and each segment is divided by the tilda symbol: INDEX~OBJ~USR~GRANTCD~GRANTDTL~PROJCD~PROJDTL Not all segments are required so the data in the field...

I am using a list control to provide free form style grouping. But I'm having difficulty getting header level data and a watermark to repeat on EVERY page of the report. Basically the report is a purchase order form the customer wants to print 6 times. I have the list control grouped on print...

I have created a report using Reporting Services 2005 and have a question about formatting a numeric field with three decimal places. I am trying to format a numeric (6,3) field. The data stores in the field like: 1.000 1.250 1.500 0.500 I need to print this field on the report I've created...

Hello all, I have a report that my customer wishes to print and insert into a larger document. They wish to control where page numbering begins. I have a field I have customized I can pull the number from. The field is pageNbr. The customer will enter the numeric value of the the starting...

I'm using SSRS Visual Studio 2005. This seems like it should be fairly simple, but I'm hung up and need some help. The data in my SQL query is ungrouped because it's performing some calculations by detail row. Each customer could have several detail rows associated with them. When I output...

Hi there, I have a field I am trying to format in Crystal Reports 10. This seems like it should be simple, but I can't figure it out. The field is numeric and is stored in the database like: 1.00, 1.25, 1.50, etc. If the value is like 1.00 I want output to look like: 1. If the value is 1.25...

Hi there, I am using Crystal 10. I figured out WHY my record selection criteria is not working, but not sure how to fix. I know the "OR" statements I have in here are causing the statement to evaluation everything up to the "OR" statement and if it's able to return data, is ignoring...

Hello all, I am trying to group my report by either Department or Department AND Location. Group Header 1: = Department (crosstab here) Group Header 2: = Location (crosstab here) I have a parameter that asks the user to choose the level of grouping. "Either Department" or "Department &...

I create two paramaters for date range. "startcheckdate" and "endcheckdate" I used them to calculate a date range on a payment date field. In my main report, I have the above two parameters. And I have two formulas. The formulas are name the same and just have the parameter field in...

Hello all, I am using Crystal 10. I have two tables and need to exclude data in my report based on where IDs match between the two tables. TABLEA - shows all purchase orders TABLEB - contains purchase orders I need to exclude from the larger set of data I am excluding data where PO_ID and...

Hello friends, I'm sure this has been asked before, but I can't make this query work for me as I am new to crystal. I'm using Crystal Reports 10. I need to search an Account Code string and find "35" at the 5th and 6th positions in the string. The account code looks like this...

Report in crystal 10 using 2 cross-tabs. To display data the way client has requested, I created a formula to group the data. It works great, except that if I use it in one of my cross-tabs it effects the totals in the other cross-tab (even though the formula is not used in the other...