Stored Procedure & Charts

[konad]

I have 2 stored procedures, one pulls information for specific parts of my main report, and i have a 2nd stored procedure just for my chart, which is also placed in the main report "no subreport", the problem is my chart is not pulling back any information. if i took this same chart and stored procedure and put it on a new form by itself it pulls back the info. Why if I am using a seperate stored procedure should i need to use a darn sub report for my chart?? my vb application which calls some of these reports is having all kinds of issues pulling up the subreports and connecting to them and such, and since i have to distribute this out to multiple clients on multiple operating systems i would like to try and avoid sub reports

 

[MalcolmW]

One sp per report is the rule. You could create another sp which calls the other two sp, and returns them as a single data set. Malcolm

 

[konad]

well i would like to use one SP however this all reverts back to my chart and an exclusion i have, in my chart formula on change of i say:

if {sproc_CADReportsMain;1.StatusType} = "B" OR {sproc_CADReportsMain;1.StatusType} = "C" then
{sproc_CADReportsMain;1.StatusCode} & " " & {sproc_CADReportsMain;1.StatusDescription}

and in that same chart i have another formula for show value is:

DateDiff("n",{sproc_CADReportsMain;1.CallTime},{sproc_CADReportsMain;1.StatusTime});

however, one of my sp*.StatusCode by another sp*.StatusType is the same, and crstal adds an empty line or bar or pie representation of the StatusType's StatusCode not used. even though i filtered it out with my IF statement as you see above.

 

[MalcolmW]

If you need information from two sp to show in one report, you have two options.
1) Use subreports
2) Create another sp to combine the data from the two sp. Use just that single new sp in the report.

Is this the issue, or is there something else? Malcolm

 

[konad]

yes you have the jist of it Malk but the problem is i did try 2 stored procedures but my chart came back empty as if it didn't acknowlege the procedure

 

[konad]

i think its just i am not sure how to call another stored procedure and its info from others in MS SQL 7.0