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

  1. leveetated

    Force loop through all field values before showing the rest of the data set?

    Hello and thank you lbass - I did as you suggested and the report returned the error "The Report Application Server Failed" and did not display any results. Perhaps I should mention that the report is run after a search result, i.e. a set of results is sent to the report and the report should...
  2. leveetated

    Force loop through all field values before showing the rest of the data set?

    Hello lbass - I am linking the subreport on the publication ID. The subreport is placed in the main report header. There is one group in the main report, which groups on a sorting field in the publication table. There is one group in the subreport (and the display formula is placed in its...
  3. leveetated

    Force loop through all field values before showing the rest of the data set?

    Ah, typed a bit too soon; I was able to fix the string length issue by using a different view. However, now the subreport only displays one of the credit lines. I have tried different groups in the SR but with no success. With thanks, Lee.
  4. leveetated

    Force loop through all field values before showing the rest of the data set?

    Thank you lbass. I did as you suggested, and I am getting an error at run time: "Error in formula accum: 'Whileprintingrecords;' A string can be at most 65534 characters long. Details: errorKind". Any guidance is much appreciated, with thanks, Lee.
  5. leveetated

    Force loop through all field values before showing the rest of the data set?

    Thank you Madawc, you captured it exactly when you said I adapted your code and placed it exactly as mentioned: the accum in details, the reset in GH3, and the display in GF3. The rest of the publication data is in GF2a, 2b, 2c, etc. This is want I want to see: publisher1, publisher2...
  6. leveetated

    Force loop through all field values before showing the rest of the data set?

    Thank you for your suggestion, IanWaterman. I'm not using variables or arrays to represent any of the data set, just the straight {table.field} format. I'm not sure if that changes anything, but wanted to mention this in case my original message was unclear. With thanks, Lee.
  7. leveetated

    Force loop through all field values before showing the rest of the data set?

    Hello all, CR 2008, SQL Server 2005 I've pored over the threads on CR looping, have tried the various do/while and reset/accum/displ formula approaches, plus subreports, and nothing is working - and I'm stuck. My data set: publisher, author, title, date, genre. I simply want to loop through...
  8. leveetated

    Simple loop question

    My mistake - the sample data above is how I want it to be shown. What actually happens in the report: (Details section) Random House ---- (Group 2 footer section) John Smith "The Velveteen Rabbit" Published 1900 Annie Johnson "How to Drive a Car" Published 2010 Steve Martin "Cruel Shoes"...
  9. leveetated

    Simple loop question

    Thank you lbass and Madawc. lbass, I'll do my best to show you what I have now: DETAILS SECTION --------------- {Publications.PublisherName} GROUP 2 FOOTER (grouped on Publications.ID) --------------- {Publications.AuthorName} {Publications.Title} {Publications.PubDate} GROUP 1 FOOTER...
  10. leveetated

    Simple loop question

    I've not had success with a subreport approach, because I need ALL publishers for a given set of books, and the main report passes the subreport only one record ID (not an array of all record IDs) so I only get one publisher when I run the subreport. Am I doing this incorrectly? Is there...
  11. leveetated

    Simple loop question

    I want all values to appear. The field (publisher) isn't offered to me as an option in the "Insert Group" feature, presumably because it's a "Memo" field type. Here's what I want to do: first, list all publishers for a publication: Random House W.W. Norton Hyperion Random House Prentice Hall...
  12. leveetated

    Simple loop question

    Thank you Madawc for that perspective - it does help. hilfy: this is one field that is shared among all records; I simply want to display its value for each record and I can't group on it, and I can't (apparently) use a subreport to show all the values for this field. Madawc, should be...
  13. leveetated

    Simple loop question

    CR 2008 Hello all, I can't seem to find this covered in another thread & I feel silly asking it, but here goes: I simply want to loop through all the values for a given field before jumping to the group footer. Like so: Value 1 Value 2 Value 3 But it will print Value 1, then the group 2...
  14. leveetated

    Dynamic parameters stop working with CR 2008 SP3?

    Ken, I am seeing this too, with CR 2008 SP4 (Win 7). Unfortunately I cannot roll back because SP4 fixes something else that was broken in SP3! Did you find a resolution to this issue? Best, Lee.
  15. leveetated

    System DSN acct removed from db server but authentication still works!

    I have a mystery on my hands. I need to disable a company-wide System DSN. It's the same DSN on every computer, using the same SQL Server 2005 authentication login account. Initially I thought, I'll just remove the SQL Authentication account used in that DSN entry on all the computers. So I...
  16. leveetated

    CR XI report only passes NULL value to stored procedure

    If anyone else encounters this problem, here's what I had to do to make it work: - I had the SP as the datasource, thinking that the @param in the report would 'automagically' be passed to its matching counterpart in the SP. I was wrong (even though this method works for another report...that's...
  17. leveetated

    CR XI report only passes NULL value to stored procedure

    I forgot to add that I can execute the SP in MS SQL Server, pass in a value for the parameter, and it runs perfectly. Many thanks, Lee.
  18. leveetated

    CR XI report only passes NULL value to stored procedure

    Hello CR experts, CRXI MS SQL Server 2005 I've been going round and round on a problem over the last week and am at my wit's end! It must be a simple setting I've overlooked. I simply want to pass a number to a SP, and use that value in a WHERE statement, followed by an INSERT. I have a main...
  19. leveetated

    Reg Ex - how to match pattern EXCEPT for duplicates

    Chris, this is good - thanks so much. Will give it a try. All the best, Lee.
  20. leveetated

    Reg Ex - how to match pattern EXCEPT for duplicates

    Yes, each .txt file can contain any number of lines, and I want to go through line by line and find at *least* 2 consecutive strings ending in 1, but any two consecutive strings may not be duplicates. Below I inserted [Yes] or [No] to indicate what I'm looking for. Sample file contents 1...

Part and Inventory Search

Back
Top