Thanks for the reply. We have hundreds of reports. Manual documentation isn't the goal; automated is. So to rephrase my question, "How can we automatically extract the contents of a Command from an rpt file?
We need data-dependency documentation. We have CR 10 and most of our reports use Commands. A programmer tried to extract the Command from a report but it just shows as a table in the file. (He used C# .NET.)
How can we get the contents of the Command in an rpt file?
Yes, it's an SQL command. Let's assume we're logged into SQL1.
SELECT * FROM employee_table
INTO [SQL3].area51.dbo.test_table
We think the problem is there needs to be a link between the servers.
Crystal 10
I'm using a command within a report that writes its results to a table. (Server SQL1 is production; SQL3 is development.) It works as long as the data location is SQL3 and it writes the table to SQL3. But when I try to run the report with the command on SQL1, and write the table...
Hi, I appreciate the help. (And wow was it fast!) The database is on the switch, which is read-only to me. I can't create any tables.
I think a stored procedure might work, but I can't get my system developers to help with this.
Can I assume an array within Crystal wouldn't help?
Mitch
I work in a call center and use Crystal 10 on an MS-SQL database. The end-user wants a chart with the number of calls answered and abandoned by hour, by day.
The problem: the center is closed 12:00am to 6:00am every day. I grouped the report on the hour. The report doesn’t find any records...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.