Search results for query: *

It sounds like you are trying to calculate inventory turns or something similar. The way I've done this in the past is to set up MS SQL express database and create some SSIS packages to extract the data from the production DB to the data store to report off of. Improving performance on reports...

KC - When you create the formula in the workshop, and hit save/close to exit the workshop it is going to create the formula as a field in the field explorer (most commonly found on the right hand side of the screen). To use the formula in the report, you can drag and drop the formula field...

Sometimes you have to allow for both null fields and blank fields. IF isNull({table.field}) or {table.field} = '' THEN crSomeColor ELSE IF {table.field} = true THEN crSomeOtherColor

Your statement is pretty much there. You create a new formula in the workshop, which creates a "field" in the field explorer. Just drag that formula field onto the report where needed.

The above solution will work as long as each record includes WS, Windstream, and DID in the memo. If its possible to have different permutations, i.e., includes WS and DID but not Windtream, then you will want to use "OR" statements instead of "AND

I solved my question using T-SQL and a command. But, if possible, I'd like to know how to do this using a crystal formula.

Good morning, Using Crystal XI and MS SQL 2008R2 database, I'm trying to parse a string that's basically a condition stored in the database. Here's and example of the format of the string: {dbTable.dbField}="some medication name" & {dbTable.dbField}="some medication strength" &...

Good morning. I'm not sure if this is the correct forum to post this question, and if its not, please direct me. I have a script that lists the last logons for all users on all domain controllers in my domain. I've been asked to modify the script to exclude user objects if they are a member of...

The calling application uses the same DSN as the report. Same username and password in the DSN.

Using CR XI connecting to a MSSQL 2008R2 Standard database. Ive created a report with a subreport which everything works fine from Crystal Reports. I save the .rpt file to a file location for the application to call from, using crystal reports viewer. For whatever reason, the viewer keeps...

Did you recompile the stored procedure?

Make sure the vertical size of the detail section will mathematically fit on your page size 3 times.

Good morning fellow Crystal Reporters... I've been tasked to come up with a training course for Crystal Reports XI. I found one post on this site where someone else asked the same question, but the URLs in the post no longer work. Here is a very high-level course outline that I've come up...

I have a CR XI report that utilizes a stored procedure (MSSQL 2005) to gets a dataset that is not returning the expected data. I know why, but not sure the best route to fix. The main report has 3 parameters to pass to the SP: location, startDate, and endDate. The subreport is linked to these...

In my past job where I was IT manager, I controlled this through Active Directory, Group Policy and Citrix. For XenApps- I created an AD OU for CR users, and then added the CR users to that OU. You can then install CR onto the Citrix server(s) and limit access to that application so that only...

For performance reasons, in Crystal Reports XI the maximum number of values that are returned for each level of a list of values is set to 1000. The list of values provides the data for the dynamic parameter list. How can you modify the maximum number of values available in a dynamic parameter...

As hilfy mentioned, here's the IN statement. Either works. IF {rpPatProfile.SFFormOfDeclaration} IN ["W-2","1099"] then "X

Please provide a little more information or context to this request to better be able to help you.

For shorter lists you can always group by specified order

One way would be to run the report off of a SQL command. Another way would be to create a counter and then a selection criteria that evaulates off the counter... #counter <= 100