Recent content by SFinch

Thank you, that article helped, I finally got it to work.<br><br>Scott

Could someone please show me a working example of how to declare a shared variable in a subreport and use it in the main report (SCR7)?&nbsp;&nbsp;Peck explains it on pages 254-255, but I can't seem to get it to work.<br><br>Peck says in the subreport:<br><br>WhilePrintingRecords;<br>Shared...

I recently had a problem like this and it was the set up of the ODBC data source.&nbsp;&nbsp;I had to change the authenticity verification from SQL server username/password to WinNT verification.&nbsp;&nbsp;Once this change was made, the CR no longer asks for a username/password.<br><br>Scott

I have created a crosstab in CR7 which looks like this:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUN MON TUE WED THU FRI SAT TOTAL<br>AREA1<br>AREA2<br>AREA3<br>AREA4<br>AREA5<br>TOTAL<br><br>When I run the report with sparse data it looks something...

Thanks Malcolm, that did the trick.<br><br>Scott

PS I am using SCR 7 and SQLServer.<br><br>Scott

I would like a report that appears like this:<br><br>Group&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Rank&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Person<br>Group A<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Joe...

Thank you.&nbsp;&nbsp;That did it.<br><br>Scott

I would like to print the &quot;N&quot; number with a TopN report, something like this:<br><br>1 Vanilla<br>2 Chocolate<br>3 Strawberry<br><br>without hard coding the text as text fields.&nbsp;&nbsp;I can't seem to find any documentation that evens hints that it might be a built in...