Just started to use the Reports module in “anger” – nice and powerful.
But I got slightly caught out.
I’m giving users the opportunity to get results for their “team” we’ll call them Arsenal and Liverpool. I had them defined in an SQL table, with ClubName nchar(20) and then the data for the team.
I built a report to list the teams and then passed ClubName as a parameter, as you do in video 7.
So I have …../tabID/464/ClubName/[ClubName]/default.aspx
The test with …../tabID/464/ClubName/Arsenal/default.aspx worked a treat but when I passed the Club name as a parameter
[ ! = % but this editor actually converted "% 20" to a space]
And therefore failure
So for future reference best to use 2 tables ClubID (Int) ClubName (nchar(20)) then ClubID and the results in the 2nd table – Which is best practice for Databases anyway
Can I ask you to produce video 8 – applying CSS formatting?
I’d like to know how to get
Row 1 – white background
Row 2 – light blue background
Row 3 – white background
If anyone would like to see this in action http://www.dorsetgolfleagues.co.uk/...cords.aspx
Work In Progress (4 March 2012) should be fully live by 1 April 2012