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 SkipVought 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: *

  1. jkurtz

    Login failed for user 'User1'.Reason Not associated with a trusted SQL

    Generally this error is caused because the view or stored procs you are referencing does not have the proper rights. You need to give your web account right to the views or stored procs. Either that or you will have get login and password information from you user and pass that along instead of...
  2. jkurtz

    Changing the width of the report

    Not sure why you are not sending it straight to Excel if that is the final output needed. You could do something in asp like: Response.ContentType = &quot;application/vnd.ms-excel&quot; <!-- code to create the recordset here -- > <TABLE border=1 cellpadding=0 cellspacing=0> <TR> <!--...
  3. jkurtz

    CR9 Format Phone number

    You can use crystal's function picture({vw_name.fieldname},&quot;(XXX)XXX-XXXX&quot;) You can also put in to an if else statement and then based on the len of your source field do a different format. Hope this helps...
  4. jkurtz

    reports

    You didn't state which version you are working with but in Access 2000 there is a problem if you have the Name AutoCorrect flag enabled. See Microsoft article Q240826.
  5. jkurtz

    Problems with sub reports in cr for .net

    Has anyone run into the problem of the login failing when running more than one sub report? The main report and the first sub report work off the same sql view. The second sub report works of a different sql view but from the same database and the main report. All views use the same connect...
  6. jkurtz

    Suppress Group Footer based on detail record counts

    Is there a way to suppress a group footer based on the number of detail records. What I'm looking to do is if I only have one detail record I want to suppress the footer for that group otherwise show the footer with the totals for that section. I'm using the .Net version of Crystal Reports. Thanks

Part and Inventory Search

Back
Top