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...
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...
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.
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.
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...
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.
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...
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"...
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...
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...
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...
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...
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...
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.
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...
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...
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...
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...
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.