Anyone,
What would be the easiest statement to trim this?
Filler Order ID: <10190968MMDSCR> Filler Facility ID: <RAD>
I only want what is in between the < > to then compare to another column.
Thank you,
Anyone,
One PC has SQL Server Enterprise Manager MMC 1.2 version 5.0 sp.4 Windows 2000. I can access all databases.
The other PC has Enterprise Manager 8.0 and MMC 2.0 v5.1 sp2.0 on a windows XP machine. Cannot access all databases.
Has anyone ever encountered a problem like...
I have an 8.5 report that has two groups. On group is split into 1a and 1b. I would like to suppress 1b if the details section is suppressed. The formulas on Group 1b are New page after "not onlastrecord" , new page before is checked, and Keep together is checked.
I have tried using a...
I have an application that sits on a test as well as a production server. On the win2k client in order to change from test to production, I must go into the registry and modify a Server Profile setting. I go into the setting and remove a few alpha characters to access test and add them back to...
Hello,
Using CR 9.0, I have a record selection that looks like this:
({a.COLLECTED} in {?Begin Date} to {?End Date}) and
(("ALL" IN {?Test Code})OR ({a.TESTCODE} = {?Test Code})) and
{a.PS} in [" ", "210", "91840"] and
(("All" in {?Site}) OR {a.LS} = {?Site})
for the a.PS in [" ", "100"...
I am using CR9.0. I have a parameter field that has multiple locations set as default values. In the report header I want to display the parameter values input at runtime. I have put the parameter field into the report header but it only lists the First value input. How do I see multiple...
How do you modify the Sql in the CR9.0 "Show Sql Query" text box. In earlier versions, you could modify the query directly in this box. How do you do it in 9.0.
From Database>Show Sql Query.
Thanks for any help.
Anyone,
I think this is simple but I cannot figure it out. I have a running total that I only want the last record to display. How can suppress an unknown amount of records before the last record is displayed?
Any help is appreciated.
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.