Use a stored procedure. Put the values you want into a table variable with an identity column. Then build an array by sequencing through the values in the table variable and concatenating the values in the data column.
Table Variable key value 1 11 2 34 3 21 4 3 Use a while loop to sequence the extraction and concatenate the values with a comma between them. Make sure to use an nvarchar datatype for the array. 11,34,21,3 Then use that array for chd=t:<your data set here> On Nov 5, 6:57 am, IM <[email protected]> wrote: > Hi, > > I am trying to embedd a google chart within a SSRS report that pulls > data from our SQL database, however i am having trouble building the > URL to call the chart. > > the problem i am having is how to substiture the plain text example of > chd=t:60,40 etc with a value read in from the data base i.e. > chd=t:sum(fieldname),sum(fieldname2) > > any pointers would be useful. > > Regards, > > Ian -- You received this message because you are subscribed to the Google Groups "Google Chart API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-chart-api?hl=en.
