Search results for query: *

I could not do the 'right-click, insert' however I inserted a Summary of both fields from the menu bar, one using count and the other using sum, and then built the percentage field off those two fields and it worked. The percentage field now shows up as an available field to use in the line...

One field is merely a total of the records. The Running Total has to be used since it's posted to total each group's monthly total. So it's Summary by Count and start count over when Month changes. Then the other Running Total field adds all records which have a value of 1 and is also posted...

I have a field which is basically a percentage formula off of two other running total fields - ({rtfield1}/{rtfield2})*100. I want to build a line chart off the percentage field. The report has two grouping levels as well - one, the customer and two, the month. All three fields reside in the...

I have a field which is basically a percentage formula off of two other running total fields - ({rtfield1}/{rtfield2})*100. I want to build a line chart off the percentage field. The report has two grouping levels as well - one, the customer and two, the month. All three fields reside in the...

I am not sure what the 'minimum' configuration is but I can tell you what we've set up: Windows 2000 Server, 2 CPU’s, 2GB RAM, 30GB DISK We have somewhere around 150-200 reports posted, most of which run via automation - (about 70k processed since March). There are probably around 15-20...

Thank you

I have a spcific name with file extension at the bottom" I have found that if I put in my own report name, it sometimes doesn't run right. I use the dropdown and select "Title" and then add .pdf and they run fine. Not sure if this is your problem but thought I'd throw it out there.

When you upload the report to CMC then you need to right click on the report and select Database Configuration. You can enter the login credentials there and select "Use same database logon as when report is run" at the bottom and anyone who runs it in InfoView will not need to logon.

Quick question - does anyone know what the processing order is for the report criteria formulas? Is is Top-Down or Bottom-Up?

Can't you just do a Distinct Count against the date field based on Groups?

You can always use this: ({end time field} - {start time field})*24 = 0.00 (hrs and .00 mins) use *1440 if you want it in whole minutes.

I have a report which needs to query an excel file as well as a database to run. Does anyone know how/where I would put the excel file on the server (Crystal Server 2008) in order to run the report from the CMC? I have tried adding it to the same folder the report but I know I need to indicate...

You could use the "replace" formula and replace all the %252Bb with the proper character. Replace({fieldname}, "%252Bb", "+") Now if both the + and = gets changed to the same set of characters, then that poses a problem for this formula use.

I don't have the exact answer to your problem however I just created a calendar style report which uses subreports and if you use Sequel expressions to draw your data in the subreports off of the query on the main report, it helps the performance issue. Investigate that option. Use "Linking...

Can someone tell me where the setting is to terminate idle login sessions in the CMC? Using 2008 server on Windows. If someone logs in and then does not log out but rather 'x's" out of the window, the session remains connected and occupies a license spot. Is there somewhere to set a terminate...

Create a parameter field for each field (Dynamic). Then in the Report>Selection Formula>Record write in a formula to choose only records based on that parameter field. For example: Field to base parameter on: {dba name} Parameter field created: {?database.name} Record selection formula...

Enterprise authentication. I don't know about aliases, I don't believe any were set up.

You use the Weekly setting and pick Monday through Friday. Then select begin at 8am. End time should be a long time from now or if you have a end time. You'll have to do this for each hour of the day so you'll be setting up 8 separate instances of the report. Each one will run at the given...

In the CMC, I've deleted a user (no longer shows in user list) however I can still login using those credentials and if I try to recreate that user, it says the user object already exists under the same name. Does anyone know how to truly delete a user in the server?

The formula works fine however I have to put that formula into every string field in the report which is a pain. (like 20+ fields) If anyone else has a fix for the _b issue, please feel free to suggest. Thanks