Search results for query: *

I have installed SQL server reporting services (SSRS) and was impressed with the sample reports and how easy they were to get up and running. The SQL license my company has allows us to install SSRS for free. We are using Crystal now and are seriously looking at SSRS to replace crystal...

I have a related question. I have several columns which are color coded depending on their cell contents. The grid is loaded and looks great. The user needs to change this cells and the color should also change. I not sure which event to override. I thought about the invalidate event to...

I have a custom datagrid with an override for the paint event. The background color of each cell is dependent on the value of the cell. No problem. Grid loads fine. Now, the cell values can be modified and and I need the color to change as well. I would rather not repaint the entire grid...

jsblakely, We have crystal 9.0 with the report portal. Currently the only way to generate/export/print report is manually selecting the report entering criteria and clicking refresh. We would like to do all this from a .net app. Any chance you could elaborate on your solution ?

Do a search in .NET for PaperOrientation. It's a member of the PrintOptions class.

I have already installed a windows application that includes crystal reports. The MSI file installed all the necessary merge modules. Now, I have another application with new reports. Do I need to install the merge modules again ? Anyone ever tried creating a project that only installs the...

Well, how come I can specify 'Null' in my table design ? When I insert records, I clearly have nulls in the date fields.

This is a third party package (desktop) where I can create reports and supply the software with the report file and criteria. I don't know what they used to write the software (probably vb or c) Never tried to pass parameters at runtime. Crystal would prompt me at design-time. I am using...

I need to use a stored procedure as a datasource for a report. The sp has 3 parameters and I set these values when I select the report at design-time. My question: How can I pass these parameters at run-time ? The stored procedure is not static. If it was, I could use a view.

Yes, I have read some white papers. Looks like crystal is on it's way out. Reporting services can import access report objects and personally, I think they are superior to crystal.

Great minds think alike. For the additional cost of advanced, I would rather stick with .NET. The web page says .NET cannot handle XML -- I'll have to check that out. We have the enterprise version here and I think it's overkill -- besides it crashes, it costs A LOT and it doesn't run as a...

The insert is a straight-forward. I have checked and rechecked the VALUES clause. All field types match and number of columns match. There are no triggers and I am the DBO. Up till a few days ago, this was working fine. No design changes have been made to the table.

I originally posted this in the Crystal forum but maybe this forum is more appropriate... From what I can tell, .NET is more flexible. I can pass just about datasource I can imagine. I can publish a report as a web-service which giving me a highly scalable solution. I can pass multiple...

I am unable to insert into a table. I get the... 'Column name or number of supplied values does not match table definition' ...error. Strange thing, I can't even insert from enterprise mgr. I only have 4 required fields and the rest can be null. Updates and deletes work fine. I can try to...

From what I can tell, .NET is more flexible. I can pass just about datasource I can imagine. I can publish a report as a web-service which giving me a highly scalable solution. I can pass multiple datasets via stored procedures, make use of n-tier methodologies. It's built into .NET so I...

Ok, all you gurus, try this one. I am generating a top 10 revenue report in the following manner. For each month in the past year... INSERT INTO #topcust SELECT TOP 10 customer FROM REVENUES WHERE DATEDIFF(m,sales_date,GETDATE())=0 --this month GROUP BY customer ORDER BY SUM(amount) DESC...

Try this... http://www.crystaldecisions.com/about/events/seminars/seminarMain.asp?ls=OnlinePreRecorded

I would like to install a crystal report app on the server. The clients have the framework so they should be able to run the application, correct ? With the exception of crystal the applications are basic (enter criteria, click a button and the report appears) My question, what is the minimum...

I have a question...if I have a stored procedure which does not take any parameters, would I be better off using a view ?

Yes, the feed is automated but the accounting is not. The manufacturer will only dicusss their solution so I'm pretty much on my own. I've used 'sniiffer' software on com ports. I can give that a try. I can test a standard cable, null modem and I also have an RS422 card. Is there software...