Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JulsY
  • Order by date
  1. JulsY

    Wait for bat file to complete before continuing

    Hi, Please help with the following. I have an Execute Process Task calling a bat file, (File1) with arguments, in a loop. I want SSIS to wait for it to complete before going to the next value in the loop. It doesn't seem to do that. The File1 that SSIS calls makes a call to rcmd to run File2...
  2. JulsY

    Variable data type in ForEach Loop

    Hi, I have a SQl task that runs a query that is assigned to an Object type variable. There are 4 columns being returned by this query. First 3 are string and last is a tinyint. Then in a Foreach loop I use Foreach ADO Enumerator to extract the rusults out from this Object variable. In the...
  3. JulsY

    Seagate Info and Active Directory

    Hi, Can anyone tell me if Seagate Info 7 can be made to work with Active Directory? I haven't found anything on Crystal's site and am fearing that this is not possible. Thanks.
  4. JulsY

    Javascript syntax

    Hello, Can anyone tell me the correct javascript syntax fro returning the total number of current values a parameter has set? Here is my sample that doesn't deem to work: result = queried report... ReportObject = Result.Item(1); ReportInterface =...
  5. JulsY

    Get instance parameter info

    ...this? Thanks so much. Set iStore = es.Service("","InfoStore") Set objects = iStore.query("SELECT top 1 * FROM CI_INFOOBJECTS WHERE SI_NAME = 'Companies Merged' and si_instance = 1") Set rptPlugin = infoObject.PluginInterface("") Set...
  6. JulsY

    Creating Custom reports by users?

    BlurredVision you are absolutely correct!
  7. JulsY

    Prompt for disabled parameter

    I need tohave it there because sometimes this report is used as subreport and doesn't use this parameter and other times it is a stand alone report and uses this parameter. If you are saying that CE will give me just a list of all parameters, then why it does not list it when viewing on demand...
  8. JulsY

    Prompt for disabled parameter

    I have a report that has a parameter that is NOT used in running the report and is not placed anywhere in the report. It is hust listed under "Parameters" section in Field Explorer window. When I run this report from Designer and from "View on Demand" in CE 8.5 I am not...
  9. JulsY

    APS Clustering

    The 2 APS's are the way it should be in your situation. However, I am not sure about processors question.
  10. JulsY

    Can't re-run scheduled reports as "run now"

    Go to www.apos.on.ca and download a Demo copy of Instance Manager. With the DEMO copy you can re-schedule 10 instances at a time. At least this will give you a quick way out.
  11. JulsY

    Excel instance - garbled data

    In the CR report exports fine. This only happens sometimes when I run the report. I think I found one pattern.. if the report outputs a lot of data this happens. In the CMC I have Excel set as default format. I have also redid the report file, but still the same. I have CE services...
  12. JulsY

    RAS & trusted connections

    Here is ASP syntax for connecting to DB - Trusted connection and getting recordset out: set DB = Server.CreateObject("ADODB.Connection") strConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI; Persist Security Info=False;Initial Catalog=PUT_NAME_OF YOUR_DB_HERE; Data Source =...
  13. JulsY

    Excel instance - garbled data

    ...ÿ € ÿ € ÿ € ÿ €ÿ€ÿ€ÿ€ÿ€ÿ€ÿ€ÿ€ÿ€ÿ€ÿ€ÿ€ÿ€€ÿ€ÿ€ÿ€ÿ€ÿ€ ÿ €!ÿ!€"ÿ"€#ÿ#€$ÿ$€%ÿ%€&ÿ&€'ÿ'€(ÿ(€)ÿ)€*ÿ*€+ÿ+€,ÿ,€-ÿ-€.ÿ.€/ÿ/€0ÿ0€1ÿ1€2ÿ2€3ÿ3€4ÿ4€5ÿ5ýÿÿÿþÿÿÿþÿÿÿ  ...
  14. JulsY

    change month from number to value

    It should not be looking for anything else. What version are you using? Also, try this: MonthName(8,False)
  15. JulsY

    Exporting report to Excel from ASP

    The version is fine. Try this: Find craxdrt.dll on your system and rename it to something like craxdrtabc1234.dll Reboot and see if you still have the problem.
  16. JulsY

    change month from number to value

    Use Create a formula and use MonthName(month number ) MonthName(5) = May
  17. JulsY

    VB6 & Crystal parms

    just have them enter a value and then take what they entered and assign it to each report as shown above.
  18. JulsY

    VB6 & Crystal parms

    Try this: rep.ParameterFields.GetItemByName("ParamName").AddCurrentValue "200212"
  19. JulsY

    sorting on running total

    Hi, please help.. I have a report with one group and a number of Group total fields in theat group footer. I need to sort the report on one of the running totals. Is this possible???? Thanks.
  20. JulsY

    changing multiple rows into a csv string

    Hi, I have a table that has values structured as follows: PersonID Degree 55 MD 55 Phd 55 RN 60 MD 60 Phd I need a stored procedure that will give me output like this: PersonID Degree 55 MD, Phd, RN 60 MD, Phd I am having a hard time getting...

Part and Inventory Search

Back
Top