Search results for query: *

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

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

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

I have a report that is working fine from within Crystal Reports XI. The report consists of a main report that lists a location (hospital or clinic) and the provider (doctor or RN) and is linked to a sub report that shows the tasks associated with that provider at that location. I have...

CR XI XP SQL Server 2005 MS Server 2008 I write a lot of reports using cascading, dynamic parameters. I ran into an issue where Crystal Reports was limiting the number of results returned on the lowest level parameter. I found the fix for the issue as listed below. However, I was wondering if...

I've been tasked with creating reports off SQL 2005 and 2008 database(s). When creating new reports on these databases, the database expert does not list all of the tables in the database. Since the database is quite large and has many tables, I'm wondering if there is some default setting that...