Search results for query: *

Thank you Diego. Both databases should have been exactly the same. But what I discovered is that my development database had gotten a bit ahead of the database at my client's site, and my client did not have a table referenced by one of my stored procs which the report uses. This error was...

Here's a link I found: http://forums.microsoft.com/msdn/rss.aspx?postid=196939&forumid=77&siteid=1 (Hope it's ok to link to another forum from this one!) And the basics: I found out how to do this. Select your Setup project, then click Project menu. Then the properties menu item. A dialog...

I have a Windows Application/Web Service project that I've been able to successfully deploy to my customer's server. Then I added Crystal Reports. I am getting an error that says "The application (mine) requires that assembly CrystalDecisions.CrystalReports.Engine Version 10.2.3600.0 be...

Because I didn't know how to do this in code, I decided to just change each rpt file to point to the other database. I have four reports. The first one I did worked, the remaining three got this error: Some tables could not be replaced, as no match was found in the new data source. Please...

I've been developing my reports on my machine and with a database on a local server. So in each ofmy rpt files, I set the datasource location to that db and server. Now I want to deploy at my customer's. Instead of changing each report file, I'd like to put the database and server names in...

I am still using the CrystalReportViewer to print. I am just not showing the form it's on. Is this approach correct? What I did was take all the code that runs when the user wants to look at a report. But I never execute the Show() method on the form containing the viewer...

I have a windows application developed in VB.NET 2005. I have a main screen from which the user might want to run a report. I have the report developed. If I view the report and print it through CrystalReportViewer it works as would be expected. However, the user does not always want to view...

Thank you for CMA (that's a variation of CYA, but you do it for somebody else)! Also, I just found this forum and my first question was about data access so I just continued on in the section I first found! Sorry...I'll get out!

Okay, the Formatting Formulas are separate from the Formula Fields so I didn't have to combine them, I did it in two steps. This is the Formula Field for RawCheckbox: If {spCr_NewCoverage;1.Raw} = True Then Chr(254) Else Chr(168) And this is my Formatting Forumula also for...

Okay, I think I'm onto something. I found this at this link: http://msdn2.microsoft.com/en-us/vstudio/aa700872.aspx if (Sales.Profit) < 0 then crRed else crBlack So now I'm pretty sure I can do what I want to do. But I still have a question, because I'm new at writing formulas, and new at...

I'm converting a Windows VB project from Access to VS .net 2005. The report currently in Access does something really cool with color-coding that I just want to know if it's possible to also do with Crystal Reports. There are boolean values in the database to indicate whether a component needs...

This issue is resolved. I had to explicitly define my AvgDaysWithoutComponents column AS int when I inserted it into the database table. It must've been defaulting to something that confused Crystal, thereby not allowing Crystal to discover any of the columns returned by the stored proc. Not...

UPDATE: I had created a backup copy of this stored procedure when I had a working report. I reverted to that backup and it is working. I am tryng to find out exactly what was added to the stored procedure that broke it (because I do need the additional data). It seems to have something to do...

My database is SQL Server 2005. I know I just saw it somewhere, but where do I see what my connectivity is? I think it was ADO, if that's specific enough. I played around with the sp to no avail. Yes, I have tested it. It return one row because it is a summary report. I had it return only...

Well that didn't matter. I have a report that works that uses a stored procedure and that procedure selects * from a temp table with no problem. And making the select explicit didn't help...

Yes, I have done all the updating and verifying I thought was required. What I think it might be and am trying now, is the last step in my sp is a select * from a temp table. My boss said Crystal probably doesn't know the structure/column names from a temp table by doing a select *. I am...

I am running Crystal Reports in VS2005 as of a few weeks ago so I'm not too skilled yet at troubleshooting problems I am having. I have a blank report and I set the DataSource and chose a stored procedure. This stored procedure should be expandable so I can indicate which columns I want to...