Showing posts with label dumb. Show all posts
Showing posts with label dumb. Show all posts

Monday, March 26, 2012

Is it possible to install server and client in one PC

This maybe a dumb question, looks not possibe to me.
But if it is possible, then it would be very nice for development.Yes it's easy. Just follow the default (single server) installation
instructions and make sure you have VS.NET already installed.
--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:41E0CAE4-2AFE-4EC6-B262-C96C942D9EB4@.microsoft.com...
> This maybe a dumb question, looks not possibe to me.
> But if it is possible, then it would be very nice for development.
>

Monday, March 19, 2012

Is it possible to chart values contained within a single field?

Just picking up SRS for the first time, so please excuse me if my question turns out to be dumb. If I have a Field that contains a csv (comma seperated variable) list of integers, is there any way to chart those values within a report?

I.e:

SELECT id, value FROM DataTable WHERE id = @.ValueId

id value

-- --

1 1,2,3,4,5,6,7,8,9,10,11

(1 row(s) affected)

I can do something like =split(Fields!Value.Value, ",") to get the individual data points out, but I'm not sure how to create a data set out of them so that I can point the chart to it. Changing the DB schema to accomidate the report is kinda out of the question at this point.

Thanks!

You could rewrite your query to split "Value" into numbers and group it by "ID", something like this:

1, ‘1,2,3,4’

2, ‘1,1,2’

1, 1

1,2

1,3

1,4

2,1

2,1

2,2

You can use split() but I don't think you can use it in the chart. It won't acceppt string[] as a value.