Search results for query: *

Hi I'm trying to populate a payment field. I have a list of all 12 months, and the report is based on a date range. The report is based on fiscal year, April 1 - March 31. If the payment is within the date range and is not zero, I want the number value to show, either negative or positive...

Nice! Perfect! Thanks, LBass!

Hello I'm trying to put the PageNumber function in a formula, and it's coming back "Page 3.00 of 4.00". I've tried the Round function but doesn't seem to be working. Is there something else I should try? Here's the function: If {V_CRYSTAL_EL_RENEWAL_NOTICE.OPTOUT} = 'NO' THEN 'Page '...

AlreadyLost: You should put how you fixed it!

Thanks, dgillz! That worked! What is that '0, "") ' anyway?

Hi I would like a column heading to read: April - 2005 Where the year is dependant on the parameter entered. I'm using the following formula: If month({?StartDate}) in 4 to 12 then 'April - ' & Year({?StartDate}) Else If month({?StartDate}) in 1 to 3 then 'April - ' &...

Oh no.... just realized that fiscal year is going to screw up the month(currentdate) part of the formula....

Awesome, thanks. That seems to work great. One more question: the dash is showing, but for some reason, there's a '$' in front of it. I don't have $ set up for any other values... wonder what's going on. Thanks very much.

Hi I'm creating a report that lists payments for a fiscal year (April 1 - March 31). I have a column for each month. I'm not using a cross tab query, as the report will be exported into an excel spreadsheet. The user inputs start and end date parameters. Say the user enters the date range...

Hey Matt Thanks. This was the problem. Actually, what happened was this: I uninstalled an older version of the application I was working on, and when I did, some SSUltraGrid files were deleted. So, the next time I re-compiled, the files were not on my computer to get packaged up. Your...

I'm not sure what you mean. Test if the row is selected? What will that do? Thanks.

Hi I would like to send a string of numbers to a PL/SQL procedure from VB6. The string of numbers represents unique IDs concatenated together. The string can only be 2000 characters, approximately the unique IDs of 200 records. If the string is 3000, I'd like to send the first 2000 along...

Hi I'm getting a runtime error 429 on the following code. Private Sub cmdPrintGrid_Click() gridPending.PrintData False, True End Sub I'm printing the information from an SSUltraGrid. This started after I created an exe using Wise Installer, and it worked fine before that! I...

Hi I'm having some issues running a procedure in PL/SQL from VB6.0. I've added in a HAVING clause to help with performace, and in PL/SQL it works fine, but when I call it from VB, I get an ORA-06512 error "Not a GROUP BY expression". Here's the procedure: SELECT COUNT (*) INTO...

That worked!!! How'd you know that? I've been looking at this for hours... Thank you so much.

Hello I'm trying to run a query checks for existing rows in a 'queue' table (Batch_Reassign). If a row is already in the Batch_Reassign table, don't return it in subsequent queries. Here's the code, when I run it without any records in the Batch_Reassign table, nothing is returned. When...

If anybody else is looking for this, here's what worked for me. Private Sub NumberRows() Dim Row As SSRow Dim RowNum As Integer If gridPending.HasRows = True Then RowNum = 0 Set Row = gridPending.GetRow(ssChildRowFirst) RowNum = RowNum + 1...

vladk: What returns Row property? I'm not sure what you mean...

Hey I was wondering if there's an easy way to number the rows in a grid. I'm using SSultragrid, and would just like to have a number next to each row. Seems simple enough, but can't find a "number" property to turn on for the grid... Thanks for any suggestions.

Got it figured out. Here is what works for me, if anyone else is interested. Golom: you were right, I needed to reference '0' where I wasn't referencing anything. Private Sub cmdRemovePending_Click() Dim aRow As SSRow Dim cellCount As SSRow Dim FolderRSN As String Dim...