Search results for query: *

That did the trick, thanks so much for all your help, it is much appreciated!

LB, I've tried this, and am still getting errors about fields that can not be summarized, here is what I have: DateTime field coming in from subreport I then have a formula (this is in the details line and is calculating for every record): datediff("s",{DateTime from SubReport},{Second...

LB, I implemented all the changes and it works great, thanks so much! I did implement it in a slightly easier way (tons of fields in details) by inserting a group (there are no other groups on this report) and placing the subreport in the group header. I plan to hide the header/footer when...

Thanks so much for the quick reply!

Hi all, First, thanks much to all for your help! I'm using Crystal Reports 2013. I have a fairly complex report coming off of a SQLServer database. The report involves many tables. The records in this main report have a one-to-many relationship with one of the tables that shows actions...

Good afternoon, I have a Crystal Reports XI report that is pulling data from a SQL Server database. My report has about a dozen fields per record (listed on the details line) and it also has one sub-report that is pulling one field from a related table. The sub-report is populated with one...

Good afternoon, I have a Crystal Reports XI report that is pulling data from a SQL Server database. My report has about a dozen fields per record (listed on the details line) and it also has one sub-report that is pulling one field from a related table. The sub-report is populated with one...

Thanks so much for the help, it worked like a charm!

In this case, count A whenever present (one time for each incident, as determined by a unique incident number - same for all counting), no matter how many items are thre, count B when present and no actions are A. Count C when present and no actions are A or B, count D when present and no...

Answer #1, 2 1 0 0 I've not tried shared variables yet, could you give me a start on this? Thank you VERY MUCH for your response!

Good afternoon folks, I have a tricky problem that I've been unable to solve and am banging my head on the monitor by now! I have a SQL Server database with multiple tables, the two that I'm working with on this report have a one-to-many relationship, the first one is "incidents" (the one...

I've got some reports running against SQL Server (multiple versions at different locations) that have sub reports. I'm using Crystal Reports 2008 and these reports used to be fairly quick at running, even longer data sets. Recently, the reports that contain sub reports have started to run...

Thanks Kray and Ido! Unfortunately, Ido, the folks doing this are developing reports so they need native Crystal. I had never heard of a way to save the ODBC password for Crystal, although I know that there are great viewers and other utilities for Crystal that do have this functionality!

Good afternoon, I have connections to SQL Server 2003 from Crystal 2008 using a standard Windows (some clients on XP some on 7) ODBC SQL system DSN. Some users want to be able to save their password in addition to their user name. I'm well aware of the security issues involved here and will...

Thanks, I always learn a new way to do things here!

Good Morning, I have a formula that is for a title on a report, however, I'm having trouble formatting the year in this. Database is SQL Server. ______________Start Formula_____________ StringVar...

On additional thing, on a date parameter, how can I default it to the current date, it is set for discrete values and I want to default the current date, but allow users to choose another date if they want to run prior records. Thanks again for all help!

Good morning, I have reports in Crystal XI that use parameters. We are accessing a SQL Server 2005 database. When the report runs the first time, the parameter window comes up blank so the user can select values. From that time forward, until the report is closed and repopened or Crystal...

Good evening, I have a SQL Server database where I'm using views, there are approximately 1000 table views (800 or so are code tables) and in Crystal Reports XI, the list of views stops after about 900, the last 100 or so do not show up on the list. I've heard of this happening before, but I've...

Boy, I left the most important part out, very SORRY, it was late and I was tired after trying to solve this problem. The date in question is in a running total field because it comes from a child table that that has many dates. A bit more info that I should have included originally: 1) There...