Search results for query: *

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...

I don't think you can link on groups, you did mean the fields themselves, correct? Thanks for you assistance. Although I don't have it running yet, I am working on it.

Also can you clarify - the subreports you are suggesting to go into Group Header 7? I think that is what you mean. Thanks!

Thank you for responding, Here's another one, I need to include a couple of expenses and they do not link back to anything in the main report, yet I need to show it, how can I do that?

Hi, I am using CR10. I have a main report that I need to grab subtotals out of subreport for. I got the Report Grand Total to come out of the subreport, but haven't been successful at bringing the subtotals up yet. The subreport is in the first group footer. This report has 7 groups with...

CR10 only brings back the first 500 rows of unique data or the first 5 seconds of unique data. CRXI only brings back the first 1000 rows of unique data or the frist 5 seconds of unique data. You could do a separate list and then import it, but then you would have to manually update it. Or...