Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arunlgt
Starting Member
7 Posts |
 Posted - 2010-03-07 : 01:30:54
|
| I have a reporting service displaying fund information form a sql table.name of the table is risk and multiple columns one of which is : FundName and has 3 values: LPLUS,TANGENT,CEYin SSRS i have created reports showing graphs seperately for each of the 3 values in fundname,but the graphs seem to be showing only for LPLUS and TANGENT and nothing comes up for CEY.any reason why this should be?PS: ihow do i edit the report file? I can see only the XML file and not the layout i designed the reports in.please advise,i am a newcomer to ssrs |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-07 : 02:32:49
|
| is there any data for CEY?you can open rdl files using visual studio or sql business intelligence development studio------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arunlgt
Starting Member
7 Posts |
Posted - 2010-03-07 : 08:39:09
|
| yes.CEY gets the data from the same columns as LPLUS and TANGENT and I see the data in the database,the problem i am sure is in the reporting services.When I open it in visual studio I only see the XML code and not the layout.Can you please tell me what i am doing wrong?the files are located in D:\SSRS.i open VS and navigate to the folder and click on the .rdl file but it opens a XML version which i do not know how to edit. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-07 : 08:48:04
|
| dont click on rdl file. just open visual studio add a new reporting services project. then select add new item-> report and browse open your rdl------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arunlgt
Starting Member
7 Posts |
Posted - 2010-03-07 : 10:23:15
|
| ok got it thank u :)ok now i see the problem:I do see 3 series in the report.but when I click on the data tab to see my query: i get this error "error access SP_varsummary"SP_varsummary = is a stored proc from which i am retreiving data from the database.is that where the problem is? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-07 : 10:27:01
|
| yup. if thats procedure that you used to get data for CEY then that will be problem.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
zauberberg51
Starting Member
3 Posts |
Posted - 2010-03-08 : 17:18:15
|
| make sure that the query type is set to SP and not text :-)that would screw up calling the sp for sure |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-03-16 : 03:56:18
|
| I'm not surprised |
|
|
|
|
|
|
SSRS - missing data