|
jonathans
Starting Member
40 Posts |
Posted - 2005-06-01 : 07:05:02
|
| Ok, I seem to have made some progress with this 'bug'. It turns out that because I have 1 stored procedure, which returns a single dataset each time, but because the stored procs nesting level changes according to the parsed paramters and as such the returning datasets are different.So it would seem that the report designer doesnt base its columns on the returning dataset of the stored proc, but instead on the 1st workable returning route.The below example is the calling procedure i use to generate the data for the reports. Everything works great, till I get to level 5, which in the dataset view returns correctly, but in the Field Property tab it returns Level 1's fields.Example:Execution Level 1: r_NFPLeadsReport '2001-01-01', '2010-01-01'Returns: ID, Name, AverageLeadAge, TotalLeadsSent, OpenLeads, PendingLeads, ClosedLeads, Sales, TotalSalesValue, ConversionRate, TypeExecution Level 2: r_NFPLeadsReport '2001-01-01', '2010-01-01', 5933Returns: ID, Name, AverageLeadAge, TotalLeadsSent, OpenLeads, PendingLeads, ClosedLeads, Sales, TotalSalesValue, ConversionRate, TypeExecution Level 3 : r_NFPLeadsReport '2001-01-01', '2010-01-01', 9444Returns: ID, Name, AverageLeadAge, TotalLeadsSent, OpenLeads, PendingLeads, ClosedLeads, Sales, TotalSalesValue, ConversionRate, TypeExecution Level 4 : r_NFPLeadsReport '2001-01-01', '2010-01-01', null, 'ABC'Returns: ID, Name, BankerName, BankerID, BranchName, PlannerName, PlannerID, ClientName, ClientCISNumber, LeadDuration, LeadSent, LeadStatus, TimesRefered, TimesRescheduled, Product, SalesValuesExecution Level 5a : r_NFPLeadsReport '2001-01-01', '2010-01-01', null, null, 1, 1Returns: RescheduleDate, RescheduledByExecution Level 5b : r_NFPLeadsReport '2001-01-01', '2010-01-01', null, null, 1, 0Returns: RedirectDate, RedirectFrom, RedirectToWARNING: Running on cold coffee! |
 |
|
BUG? Multiple Dataset Columns