Using the MS SQL Server 2005 CTP on os win2k prof.
I have set up two datasets in a report that are supposed to be referencing
to separate data sources where the following connection strings are aimed at
separate files in the same target folder: -
DataSource1: -
Dsn=Excel
Files;dbq=<drive>:\<folder>\<file1.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
DataSource2: -
Dsn=Excel
Files;dbq=<drive>:\<folder>\<file2.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
I can correctly import the columns of File1.xls to DataSet1 but when
attempting to import File2.xls to DataSet2, the columns of DataSet1 are only
visible.
I have definitely referenced the correct data sources to each dataset.
Any ideas why DataSource2 is not appearing?
Cheers
TrevI have found the solution - set up individual File DSNs for each file and
point to these; they can be generic too.
Thx to those who may have provided feedback if I had not answered my own
question!!!
"auldreidy" wrote:
> Using the MS SQL Server 2005 CTP on os win2k prof.
> I have set up two datasets in a report that are supposed to be referencing
> to separate data sources where the following connection strings are aimed at
> separate files in the same target folder: -
> DataSource1: -
> Dsn=Excel
> Files;dbq=<drive>:\<folder>\<file1.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> DataSource2: -
> Dsn=Excel
> Files;dbq=<drive>:\<folder>\<file2.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> I can correctly import the columns of File1.xls to DataSet1 but when
> attempting to import File2.xls to DataSet2, the columns of DataSet1 are only
> visible.
> I have definitely referenced the correct data sources to each dataset.
> Any ideas why DataSource2 is not appearing?
> Cheers
> Trev|||how did you get the excel file to import into the dataset?
i can't seem to figure this out in the Query String window after setting up
the dsn...
"auldreidy" <auldreidy@.discussions.microsoft.com> wrote in message
news:E7921576-2D35-45CC-A742-540C46D2E13B@.microsoft.com...
> Using the MS SQL Server 2005 CTP on os win2k prof.
> I have set up two datasets in a report that are supposed to be referencing
> to separate data sources where the following connection strings are aimed
> at
> separate files in the same target folder: -
> DataSource1: -
> Dsn=Excel
> Files;dbq=<drive>:\<folder>\<file1.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> DataSource2: -
> Dsn=Excel
> Files;dbq=<drive>:\<folder>\<file2.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> I can correctly import the columns of File1.xls to DataSet1 but when
> attempting to import File2.xls to DataSet2, the columns of DataSet1 are
> only
> visible.
> I have definitely referenced the correct data sources to each dataset.
> Any ideas why DataSource2 is not appearing?
> Cheers
> Trev|||I set up a shared data source and then referenced it in the report dataset.
When you're setting up the data source, RD allows you to browse for the dsn
so you don't need to figure it out!
Trev
"TroyS" wrote:
> how did you get the excel file to import into the dataset?
> i can't seem to figure this out in the Query String window after setting up
> the dsn...
>
> "auldreidy" <auldreidy@.discussions.microsoft.com> wrote in message
> news:E7921576-2D35-45CC-A742-540C46D2E13B@.microsoft.com...
> > Using the MS SQL Server 2005 CTP on os win2k prof.
> >
> > I have set up two datasets in a report that are supposed to be referencing
> > to separate data sources where the following connection strings are aimed
> > at
> > separate files in the same target folder: -
> >
> > DataSource1: -
> >
> > Dsn=Excel
> > Files;dbq=<drive>:\<folder>\<file1.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> >
> > DataSource2: -
> >
> > Dsn=Excel
> > Files;dbq=<drive>:\<folder>\<file2.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> >
> > I can correctly import the columns of File1.xls to DataSet1 but when
> > attempting to import File2.xls to DataSet2, the columns of DataSet1 are
> > only
> > visible.
> >
> > I have definitely referenced the correct data sources to each dataset.
> >
> > Any ideas why DataSource2 is not appearing?
> >
> > Cheers
> > Trev
>
>
Showing posts with label ctp. Show all posts
Showing posts with label ctp. Show all posts
Wednesday, March 28, 2012
Tuesday, March 20, 2012
Report Builder in June CTP
Does the Report Builder included in the June CTP work?
How can I create a report in Report Builder?
The cmmand File.. New report... said that I don't have a data source...
Also the documentation for Report Builder is pre-alpha, and it is supposed to be beta 3.
Thank you
With BI Development Studio you could make a model then deploy it and that's all (New Report Model Project). By the way the documentation for these things exists, you must read and try. The only way I now to learn.
Good Luck.
VectorR3|||In addition to using BI Dev. Studio, you can auto-generate models directly from report manager. The data source page in June CTP has a new button called "Generate model".
--Robert|||Here is a good webcast that will show you everything you need.
http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050531SQLServerCC/manifest.xml
-w
Monday, March 12, 2012
Report Builder button doesn't appear....
Hi,
I have the latest CTP installed. Users do not see the report builder button.
Only members of the local admin group seem to have it displayed. Can anyone
steer me in the right direction'
AllanI have run into a similar problem on my machine. The Report Builder button
never appears in my report manager home page.
I'm using Windows 2000 workstation with SQL Server 2005 (September)
Jay
"Allan" wrote:
> Hi,
> I have the latest CTP installed. Users do not see the report builder button.
> Only members of the local admin group seem to have it displayed. Can anyone
> steer me in the right direction'
> Allan|||I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
further but still have the same problem.....
"Jay" wrote:
> I have run into a similar problem on my machine. The Report Builder button
> never appears in my report manager home page.
> I'm using Windows 2000 workstation with SQL Server 2005 (September)
> Jay
> "Allan" wrote:
> > Hi,
> > I have the latest CTP installed. Users do not see the report builder button.
> > Only members of the local admin group seem to have it displayed. Can anyone
> > steer me in the right direction'
> >
> > Allan|||I've downloaded the MSDN RTM version and installed, but I have the same
problem. I have ensured that the users are in the Reporting services Content
Manager security group (and indeed every other group) but with no joy. Only
members of Windows Domain Admins group can see the button.
I guess I must be missing something ... ?
"Allan" wrote:
> I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> further but still have the same problem.....
> "Jay" wrote:
> > I have run into a similar problem on my machine. The Report Builder button
> > never appears in my report manager home page.
> >
> > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> >
> > Jay
> >
> > "Allan" wrote:
> >
> > > Hi,
> > > I have the latest CTP installed. Users do not see the report builder button.
> > > Only members of the local admin group seem to have it displayed. Can anyone
> > > steer me in the right direction'
> > >
> > > Allan|||Make sure, that in site settings --> configure system level role definitions
--> System USer has "Execute report definitions" is checked. This is not
checked by default if you are upgrading to 05. If you are installing it brand
new, then it is checked by default.
"Furzehill Bill" wrote:
> I've downloaded the MSDN RTM version and installed, but I have the same
> problem. I have ensured that the users are in the Reporting services Content
> Manager security group (and indeed every other group) but with no joy. Only
> members of Windows Domain Admins group can see the button.
> I guess I must be missing something ... ?
>
> "Allan" wrote:
> > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > further but still have the same problem.....
> >
> > "Jay" wrote:
> >
> > > I have run into a similar problem on my machine. The Report Builder button
> > > never appears in my report manager home page.
> > >
> > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > >
> > > Jay
> > >
> > > "Allan" wrote:
> > >
> > > > Hi,
> > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > steer me in the right direction'
> > > >
> > > > Allan|||The solution provided by Nagini Indugula does not work (at least for all
cases).
Having the same issue, adding a user to the local admin group of the
SQLRS2K5 server has the Report Builder button appearing. Remove the user
from the local admin group, the button goes away.
Trying all other local groups for the user do not resolve the issue. Looking
also for a way to get this to work.
"Nagini Indugula" wrote:
> Make sure, that in site settings --> configure system level role definitions
> --> System USer has "Execute report definitions" is checked. This is not
> checked by default if you are upgrading to 05. If you are installing it brand
> new, then it is checked by default.
>
> "Furzehill Bill" wrote:
> > I've downloaded the MSDN RTM version and installed, but I have the same
> > problem. I have ensured that the users are in the Reporting services Content
> > Manager security group (and indeed every other group) but with no joy. Only
> > members of Windows Domain Admins group can see the button.
> >
> > I guess I must be missing something ... ?
> >
> >
> > "Allan" wrote:
> >
> > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > further but still have the same problem.....
> > >
> > > "Jay" wrote:
> > >
> > > > I have run into a similar problem on my machine. The Report Builder button
> > > > never appears in my report manager home page.
> > > >
> > > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > > >
> > > > Jay
> > > >
> > > > "Allan" wrote:
> > > >
> > > > > Hi,
> > > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > > steer me in the right direction'
> > > > >
> > > > > Allan|||In digging some more, a post by Blackfish was the solution.
---
The solution is:
site settings -> Configure site-wide security -> New Role Assignment ->
add user to either 'System Admin' or 'System User'
Tim
---
"TL" wrote:
> The solution provided by Nagini Indugula does not work (at least for all
> cases).
> Having the same issue, adding a user to the local admin group of the
> SQLRS2K5 server has the Report Builder button appearing. Remove the user
> from the local admin group, the button goes away.
> Trying all other local groups for the user do not resolve the issue. Looking
> also for a way to get this to work.
>
> "Nagini Indugula" wrote:
> > Make sure, that in site settings --> configure system level role definitions
> > --> System USer has "Execute report definitions" is checked. This is not
> > checked by default if you are upgrading to 05. If you are installing it brand
> > new, then it is checked by default.
> >
> >
> >
> > "Furzehill Bill" wrote:
> >
> > > I've downloaded the MSDN RTM version and installed, but I have the same
> > > problem. I have ensured that the users are in the Reporting services Content
> > > Manager security group (and indeed every other group) but with no joy. Only
> > > members of Windows Domain Admins group can see the button.
> > >
> > > I guess I must be missing something ... ?
> > >
> > >
> > > "Allan" wrote:
> > >
> > > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > > further but still have the same problem.....
> > > >
> > > > "Jay" wrote:
> > > >
> > > > > I have run into a similar problem on my machine. The Report Builder button
> > > > > never appears in my report manager home page.
> > > > >
> > > > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > > > >
> > > > > Jay
> > > > >
> > > > > "Allan" wrote:
> > > > >
> > > > > > Hi,
> > > > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > > > steer me in the right direction'
> > > > > >
> > > > > > Allan|||Hi - I'm glad you found the answer but I'm confused... why should we have to
do this versus just assigning the user to the report builder role under item
level security?
"TL" wrote:
> In digging some more, a post by Blackfish was the solution.
> ---
> The solution is:
> site settings -> Configure site-wide security -> New Role Assignment ->
> add user to either 'System Admin' or 'System User'
> Tim
> ---
> "TL" wrote:
> > The solution provided by Nagini Indugula does not work (at least for all
> > cases).
> >
> > Having the same issue, adding a user to the local admin group of the
> > SQLRS2K5 server has the Report Builder button appearing. Remove the user
> > from the local admin group, the button goes away.
> >
> > Trying all other local groups for the user do not resolve the issue. Looking
> > also for a way to get this to work.
> >
> >
> >
> > "Nagini Indugula" wrote:
> >
> > > Make sure, that in site settings --> configure system level role definitions
> > > --> System USer has "Execute report definitions" is checked. This is not
> > > checked by default if you are upgrading to 05. If you are installing it brand
> > > new, then it is checked by default.
> > >
> > >
> > >
> > > "Furzehill Bill" wrote:
> > >
> > > > I've downloaded the MSDN RTM version and installed, but I have the same
> > > > problem. I have ensured that the users are in the Reporting services Content
> > > > Manager security group (and indeed every other group) but with no joy. Only
> > > > members of Windows Domain Admins group can see the button.
> > > >
> > > > I guess I must be missing something ... ?
> > > >
> > > >
> > > > "Allan" wrote:
> > > >
> > > > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > > > further but still have the same problem.....
> > > > >
> > > > > "Jay" wrote:
> > > > >
> > > > > > I have run into a similar problem on my machine. The Report Builder button
> > > > > > never appears in my report manager home page.
> > > > > >
> > > > > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > > > > >
> > > > > > Jay
> > > > > >
> > > > > > "Allan" wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > > > > steer me in the right direction'
> > > > > > >
> > > > > > > Allan
I have the latest CTP installed. Users do not see the report builder button.
Only members of the local admin group seem to have it displayed. Can anyone
steer me in the right direction'
AllanI have run into a similar problem on my machine. The Report Builder button
never appears in my report manager home page.
I'm using Windows 2000 workstation with SQL Server 2005 (September)
Jay
"Allan" wrote:
> Hi,
> I have the latest CTP installed. Users do not see the report builder button.
> Only members of the local admin group seem to have it displayed. Can anyone
> steer me in the right direction'
> Allan|||I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
further but still have the same problem.....
"Jay" wrote:
> I have run into a similar problem on my machine. The Report Builder button
> never appears in my report manager home page.
> I'm using Windows 2000 workstation with SQL Server 2005 (September)
> Jay
> "Allan" wrote:
> > Hi,
> > I have the latest CTP installed. Users do not see the report builder button.
> > Only members of the local admin group seem to have it displayed. Can anyone
> > steer me in the right direction'
> >
> > Allan|||I've downloaded the MSDN RTM version and installed, but I have the same
problem. I have ensured that the users are in the Reporting services Content
Manager security group (and indeed every other group) but with no joy. Only
members of Windows Domain Admins group can see the button.
I guess I must be missing something ... ?
"Allan" wrote:
> I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> further but still have the same problem.....
> "Jay" wrote:
> > I have run into a similar problem on my machine. The Report Builder button
> > never appears in my report manager home page.
> >
> > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> >
> > Jay
> >
> > "Allan" wrote:
> >
> > > Hi,
> > > I have the latest CTP installed. Users do not see the report builder button.
> > > Only members of the local admin group seem to have it displayed. Can anyone
> > > steer me in the right direction'
> > >
> > > Allan|||Make sure, that in site settings --> configure system level role definitions
--> System USer has "Execute report definitions" is checked. This is not
checked by default if you are upgrading to 05. If you are installing it brand
new, then it is checked by default.
"Furzehill Bill" wrote:
> I've downloaded the MSDN RTM version and installed, but I have the same
> problem. I have ensured that the users are in the Reporting services Content
> Manager security group (and indeed every other group) but with no joy. Only
> members of Windows Domain Admins group can see the button.
> I guess I must be missing something ... ?
>
> "Allan" wrote:
> > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > further but still have the same problem.....
> >
> > "Jay" wrote:
> >
> > > I have run into a similar problem on my machine. The Report Builder button
> > > never appears in my report manager home page.
> > >
> > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > >
> > > Jay
> > >
> > > "Allan" wrote:
> > >
> > > > Hi,
> > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > steer me in the right direction'
> > > >
> > > > Allan|||The solution provided by Nagini Indugula does not work (at least for all
cases).
Having the same issue, adding a user to the local admin group of the
SQLRS2K5 server has the Report Builder button appearing. Remove the user
from the local admin group, the button goes away.
Trying all other local groups for the user do not resolve the issue. Looking
also for a way to get this to work.
"Nagini Indugula" wrote:
> Make sure, that in site settings --> configure system level role definitions
> --> System USer has "Execute report definitions" is checked. This is not
> checked by default if you are upgrading to 05. If you are installing it brand
> new, then it is checked by default.
>
> "Furzehill Bill" wrote:
> > I've downloaded the MSDN RTM version and installed, but I have the same
> > problem. I have ensured that the users are in the Reporting services Content
> > Manager security group (and indeed every other group) but with no joy. Only
> > members of Windows Domain Admins group can see the button.
> >
> > I guess I must be missing something ... ?
> >
> >
> > "Allan" wrote:
> >
> > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > further but still have the same problem.....
> > >
> > > "Jay" wrote:
> > >
> > > > I have run into a similar problem on my machine. The Report Builder button
> > > > never appears in my report manager home page.
> > > >
> > > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > > >
> > > > Jay
> > > >
> > > > "Allan" wrote:
> > > >
> > > > > Hi,
> > > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > > steer me in the right direction'
> > > > >
> > > > > Allan|||In digging some more, a post by Blackfish was the solution.
---
The solution is:
site settings -> Configure site-wide security -> New Role Assignment ->
add user to either 'System Admin' or 'System User'
Tim
---
"TL" wrote:
> The solution provided by Nagini Indugula does not work (at least for all
> cases).
> Having the same issue, adding a user to the local admin group of the
> SQLRS2K5 server has the Report Builder button appearing. Remove the user
> from the local admin group, the button goes away.
> Trying all other local groups for the user do not resolve the issue. Looking
> also for a way to get this to work.
>
> "Nagini Indugula" wrote:
> > Make sure, that in site settings --> configure system level role definitions
> > --> System USer has "Execute report definitions" is checked. This is not
> > checked by default if you are upgrading to 05. If you are installing it brand
> > new, then it is checked by default.
> >
> >
> >
> > "Furzehill Bill" wrote:
> >
> > > I've downloaded the MSDN RTM version and installed, but I have the same
> > > problem. I have ensured that the users are in the Reporting services Content
> > > Manager security group (and indeed every other group) but with no joy. Only
> > > members of Windows Domain Admins group can see the button.
> > >
> > > I guess I must be missing something ... ?
> > >
> > >
> > > "Allan" wrote:
> > >
> > > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > > further but still have the same problem.....
> > > >
> > > > "Jay" wrote:
> > > >
> > > > > I have run into a similar problem on my machine. The Report Builder button
> > > > > never appears in my report manager home page.
> > > > >
> > > > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > > > >
> > > > > Jay
> > > > >
> > > > > "Allan" wrote:
> > > > >
> > > > > > Hi,
> > > > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > > > steer me in the right direction'
> > > > > >
> > > > > > Allan|||Hi - I'm glad you found the answer but I'm confused... why should we have to
do this versus just assigning the user to the report builder role under item
level security?
"TL" wrote:
> In digging some more, a post by Blackfish was the solution.
> ---
> The solution is:
> site settings -> Configure site-wide security -> New Role Assignment ->
> add user to either 'System Admin' or 'System User'
> Tim
> ---
> "TL" wrote:
> > The solution provided by Nagini Indugula does not work (at least for all
> > cases).
> >
> > Having the same issue, adding a user to the local admin group of the
> > SQLRS2K5 server has the Report Builder button appearing. Remove the user
> > from the local admin group, the button goes away.
> >
> > Trying all other local groups for the user do not resolve the issue. Looking
> > also for a way to get this to work.
> >
> >
> >
> > "Nagini Indugula" wrote:
> >
> > > Make sure, that in site settings --> configure system level role definitions
> > > --> System USer has "Execute report definitions" is checked. This is not
> > > checked by default if you are upgrading to 05. If you are installing it brand
> > > new, then it is checked by default.
> > >
> > >
> > >
> > > "Furzehill Bill" wrote:
> > >
> > > > I've downloaded the MSDN RTM version and installed, but I have the same
> > > > problem. I have ensured that the users are in the Reporting services Content
> > > > Manager security group (and indeed every other group) but with no joy. Only
> > > > members of Windows Domain Admins group can see the button.
> > > >
> > > > I guess I must be missing something ... ?
> > > >
> > > >
> > > > "Allan" wrote:
> > > >
> > > > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > > > further but still have the same problem.....
> > > > >
> > > > > "Jay" wrote:
> > > > >
> > > > > > I have run into a similar problem on my machine. The Report Builder button
> > > > > > never appears in my report manager home page.
> > > > > >
> > > > > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > > > > >
> > > > > > Jay
> > > > > >
> > > > > > "Allan" wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > > > > steer me in the right direction'
> > > > > > >
> > > > > > > Allan
Friday, March 9, 2012
Report Builder - Format Point Labels
Is changing the display format of the Y axis of a column chart supported in the Sept CTP or is it going to be supported in the official release? For example I have built a report model with the numeric sales values set as 'C' for currency and have created a simple bar chart with year on the category axis and sales on the Y axis. The problem is that the Y axis displays as a general number (10000000) and would like to display it as a currency ($10,000,000). I can't for the life of me figure out how to display the Y axis as currency in Report Builder.
When I can create a report in BIDS and set the format to 'C' and upload it via the Reporting Services Web App the Y axis displays correctly.
I check the version of Report Builder I have installed and it is 9.0.1314.0.
Is this a know issue, bug, or not supported in this release of Reporting Services? Any help would be greatly appreciated.
Thanks,
Larry
When I can create a report in BIDS and set the format to 'C' and upload it via the Reporting Services Web App the Y axis displays correctly.
I check the version of Report Builder I have installed and it is 9.0.1314.0.
Is this a know issue, bug, or not supported in this release of Reporting Services? Any help would be greatly appreciated.
Thanks,
Larry
This is true. If you format a field and display this field value on the point labels on a graph the format doesn't apply. In the Report Design if you go to the Chart properties -->Data Tab -->Values Edit --> Point Labels Tab-->there is an option "Format Code" to format the point labels. This isn't available in report builder.
Is there a work around?
Thanks, Susan
|||I found a solution for my problem. I created a NEW field in Report Builder and I used the ROUND() Math function to round this field to two digits. I still think that you should be able to format the point labels in a graph in Report Builder. This is a bug.
Thanks, Susan
Report Builder - Format Chart Y Axis
Is changing the display format of the Y axis of a column chart supported in the Sept CTP or is it going to be supported in the official release? For example I have built a report model with the numeric sales values set as 'C' for currency and have created a simple bar chart with year on the category axis and sales on the Y axis. The problem is that the Y axis displays as a general number (10000000) and would like to display it as a currency ($10,000,000). I can't for the life of me figure out how to display the Y axis as currency in Report Builder.
When I can create a report in BIDS and set the format to 'C' and upload it via the Reporting Services Web App the Y axis displays correctly.
I check the version of Report Builder I have installed and it is 9.0.1314.0.
Is this a know issue, bug, or not supported in this release of Reporting Services? Any help would be greatly appreciated.
Thanks,
Larry
When I can create a report in BIDS and set the format to 'C' and upload it via the Reporting Services Web App the Y axis displays correctly.
I check the version of Report Builder I have installed and it is 9.0.1314.0.
Is this a know issue, bug, or not supported in this release of Reporting Services? Any help would be greatly appreciated.
Thanks,
Larry
This is true. If you format a field and display this field value on the point labels on a graph the format doesn't apply. In the Report Design if you go to the Chart properties -->Data Tab -->Values Edit --> Point Labels Tab-->there is an option "Format Code" to format the point labels. This isn't available in report builder.
Is there a work around?
Thanks, Susan
|||I found a solution for my problem. I created a NEW field in Report Builder and I used the ROUND() Math function to round this field to two digits. I still think that you should be able to format the point labels in a graph in Report Builder. This is a bug.
Thanks, Susan
Subscribe to:
Posts (Atom)