Recent content by muffntuf

use the join function join({?parametername}, ",")

well because they want the to the dollar in the detail section and on the group summary that particular format.

No they don't have a star schema in the database, I made one out of their database with the sql command object, so there is one central table and about 6 other tables joined to that. The database I’m working against doesn’t like anything but a select or sum field construct in the SQL...

Don't know if I can yet, it is an odd database and had to set up a star schema with command objects to get data out of database with some sense to it. Unusual, but creative and effective use of command objects.

Okay the obstacle here now, the formula syntax is right, is that I have 130 fields I need to display the format for, I was hoping not to have to create 130 new fields to do the display of the results. Recommendations?

Further explanation of what I am looking for: The customer wants the report values displayed to the nearest to the nearest $1,000 with the hundredths displayed as one digit to the right of the decimal place in preview mode. This is a common format used in published financial statements...

lbass, my mistake I had -1 for the remainder, I changed that and now have the correct display. Thanks much!

Thanks for your help! That rounds up the next major increment, the result is 28,190.0 Not quite what I am after. I need to reflect the 100's as rounded up to .7 If I divide the field by 100 then I get 182,880.0 which isn't what I am after either. More help?

I need to round a number a specific way, here's an example of the number, its in the Group Summary area. I am using CRXI: 25,187,680.50 should look like: 25187.7 I don't know how to get here, but I know it probably invovles a formula. Thanks, muffntuf

Hi, I have someone who called me about publishing a report with 2005 Visual studio .net. He wants to publish a series of reports in succession. For instance show rpt 1 for a minute, show rpt 2 for a minute, show rpt 3, etc. He's got CRXI R2, VS.net 2005. Has anyone done this? Thanks, muffntuf

have you considered using a cr custom function that converts the GMT for you? They should be in your functions library.

Enough said!

Thank you lbass!

Thank you synapsevampire for the advice, have already talked till blue in the face to try to get a view on the server, but dba just doesn't want to maintain it. You know the story...

hi, I am trying to get a command object to accept multiple values. Does anyone know how to do this. I suspect I am looking at an array. For example if I wanted a user to be able to enter a number of accountid's, how could I pass them to the command object? Crystal XI is the CR and AS/400...