I have a custom assembly that around 150 reports all need to make use of. Is there a way for me to put this assembly reference in some global settings file so that I don't have to add the reference for every report individually? SQL Server 2005/VS 2005.
I don't think this is possible. Each report is compilied in its own assembly and global references are not supported.
Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts
Sunday, March 25, 2012
Sunday, March 11, 2012
Add search variables to report header
Hi,
I'd like to make the Search variables in my reports part of the Header, so
for example if I'm searching for dates and have @.StartDate and @.EndDate in
the SQL statement, I'd like to add something like 'Report Represents Data
From 1993-01-01 To 1995-01-01' or something like that. How can I do this?
Thanks -
AlexAlex:
Place a textbox either in the Page Header or he body of your report.
Set the value of the textbox equal to:
="Report Represents Data From: " & Parameters!StartDate.Value & " to " &
Parameters!EndDate.Value
Michael C
"Alex" wrote:
> Hi,
> I'd like to make the Search variables in my reports part of the Header, so
> for example if I'm searching for dates and have @.StartDate and @.EndDate in
> the SQL statement, I'd like to add something like 'Report Represents Data
> From 1993-01-01 To 1995-01-01' or something like that. How can I do this?
> Thanks -
> Alex
>
>
I'd like to make the Search variables in my reports part of the Header, so
for example if I'm searching for dates and have @.StartDate and @.EndDate in
the SQL statement, I'd like to add something like 'Report Represents Data
From 1993-01-01 To 1995-01-01' or something like that. How can I do this?
Thanks -
AlexAlex:
Place a textbox either in the Page Header or he body of your report.
Set the value of the textbox equal to:
="Report Represents Data From: " & Parameters!StartDate.Value & " to " &
Parameters!EndDate.Value
Michael C
"Alex" wrote:
> Hi,
> I'd like to make the Search variables in my reports part of the Header, so
> for example if I'm searching for dates and have @.StartDate and @.EndDate in
> the SQL statement, I'd like to add something like 'Report Represents Data
> From 1993-01-01 To 1995-01-01' or something like that. How can I do this?
> Thanks -
> Alex
>
>
Thursday, March 8, 2012
Add new user with web service
Hi there,
Would like to manage users (adding, deleting) and give them browsing rights
to reports programmatically, using the web service. Can't find the method
allowing me to do it anywhere.
Am I missing something ?
Cheers
ggThere are several methods depending on what you want to accomplish. Given a
user you can give them system level privledges using SetSystemPolicies() or
privledges on individual items using SetPolicies(). A policy is a mapping
of a user to a role. Roles are managed via
CreateRole()/SetRoleProperties/etc.. and define the specific privledges you
want to assign. For your purposes you might want to use the predefined
"Browser" role.
Jon Heide
SQL Server Reporting Services
----
Everything you need to know about SQL Server Reporting Services:
http://www.microsoft.com/sql/reporting/default.asp
----
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----
Would like to manage users (adding, deleting) and give them browsing rights
to reports programmatically, using the web service. Can't find the method
allowing me to do it anywhere.
Am I missing something ?
Cheers
ggThere are several methods depending on what you want to accomplish. Given a
user you can give them system level privledges using SetSystemPolicies() or
privledges on individual items using SetPolicies(). A policy is a mapping
of a user to a role. Roles are managed via
CreateRole()/SetRoleProperties/etc.. and define the specific privledges you
want to assign. For your purposes you might want to use the predefined
"Browser" role.
Jon Heide
SQL Server Reporting Services
----
Everything you need to know about SQL Server Reporting Services:
http://www.microsoft.com/sql/reporting/default.asp
----
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----
Add New Report Wizard fails
I'm using the Developer version with SP1 and have had to reinstall because
the localhost Reports DBs were lost and there's no obvious way to get just
two empty DB's created...
So, after install, I can edit and deploy to local and Production. BUT: When
I use the "Add New Report" wizard i get a showstopper! I can choose the data
source, key in a simple "SELECT * FROM dbo.ItemType" (for example) as the
query, select "Tabular" style, then move all fields to the "Details" section.
When I click "Next", I get the following error:
TITLE: Microsoft SQL Server
---
This wizard will close because it encountered the following error:
For help, click:
http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
---
ADDITIONAL INFORMATION:
Key cannot be null.
Parameter name: key (mscorlib)
For help, click:
http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
--
Program Location:
at System.Collections.Hashtable.get_Item(Object key)
at Microsoft.ReportDesigner.Wizards.ChooseTableStyle.get_StyleBitmap()
at
Microsoft.ReportDesigner.Wizards.ChooseTableStyle.OnEnterPage(EventArgs e)
at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender,
EventArgs e)
---
BUTTONS:
OK
---
For help, click:
http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
---
BUTTONS:
OK
---
I tried clicking the links from the "Send Message Text As E-mail" option on
the "Help" button's drop-down, but the response is a 404 - not found (pretty
message but that's the error code).
I did a Web Search (MSN Search) for keywords in the message but came up empty.
No forum entry with the keywords.
I've run the install again, rebooted, etc, etc, but the error persists...
Clues? Solutions? Please...Report Designer version# is:
Microsoft SQL Server Report Designer
Version 8.00.743.00
Is this SP1? If not, that may be the problem...
"SAinCA" wrote:
> I'm using the Developer version with SP1 and have had to reinstall because
> the localhost Reports DBs were lost and there's no obvious way to get just
> two empty DB's created...
> So, after install, I can edit and deploy to local and Production. BUT: When
> I use the "Add New Report" wizard i get a showstopper! I can choose the data
> source, key in a simple "SELECT * FROM dbo.ItemType" (for example) as the
> query, select "Tabular" style, then move all fields to the "Details" section.
> When I click "Next", I get the following error:
> TITLE: Microsoft SQL Server
> ---
> This wizard will close because it encountered the following error:
> For help, click:
> http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
> ---
> ADDITIONAL INFORMATION:
> Key cannot be null.
> Parameter name: key (mscorlib)
> For help, click:
> http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
> --
> Program Location:
> at System.Collections.Hashtable.get_Item(Object key)
> at Microsoft.ReportDesigner.Wizards.ChooseTableStyle.get_StyleBitmap()
> at
> Microsoft.ReportDesigner.Wizards.ChooseTableStyle.OnEnterPage(EventArgs e)
> at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
> at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
> nextPage)
> at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender,
> EventArgs e)
> ---
> BUTTONS:
> OK
> ---
> For help, click:
> http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
> ---
> BUTTONS:
> OK
> ---
> I tried clicking the links from the "Send Message Text As E-mail" option on
> the "Help" button's drop-down, but the response is a 404 - not found (pretty
> message but that's the error code).
> I did a Web Search (MSN Search) for keywords in the message but came up empty.
> No forum entry with the keywords.
> I've run the install again, rebooted, etc, etc, but the error persists...
> Clues? Solutions? Please...|||Report Designer version#:
Microsoft SQL Server Report Designer
Version 8.00.743.00
Is this SP1? If not, perhaps that's my issue?|||I found the SP1 download and applied it - Version 8.00.878.00
However, I still get the original bomb!
Help, please, again...
the localhost Reports DBs were lost and there's no obvious way to get just
two empty DB's created...
So, after install, I can edit and deploy to local and Production. BUT: When
I use the "Add New Report" wizard i get a showstopper! I can choose the data
source, key in a simple "SELECT * FROM dbo.ItemType" (for example) as the
query, select "Tabular" style, then move all fields to the "Details" section.
When I click "Next", I get the following error:
TITLE: Microsoft SQL Server
---
This wizard will close because it encountered the following error:
For help, click:
http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
---
ADDITIONAL INFORMATION:
Key cannot be null.
Parameter name: key (mscorlib)
For help, click:
http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
--
Program Location:
at System.Collections.Hashtable.get_Item(Object key)
at Microsoft.ReportDesigner.Wizards.ChooseTableStyle.get_StyleBitmap()
at
Microsoft.ReportDesigner.Wizards.ChooseTableStyle.OnEnterPage(EventArgs e)
at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender,
EventArgs e)
---
BUTTONS:
OK
---
For help, click:
http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
---
BUTTONS:
OK
---
I tried clicking the links from the "Send Message Text As E-mail" option on
the "Help" button's drop-down, but the response is a 404 - not found (pretty
message but that's the error code).
I did a Web Search (MSN Search) for keywords in the message but came up empty.
No forum entry with the keywords.
I've run the install again, rebooted, etc, etc, but the error persists...
Clues? Solutions? Please...Report Designer version# is:
Microsoft SQL Server Report Designer
Version 8.00.743.00
Is this SP1? If not, that may be the problem...
"SAinCA" wrote:
> I'm using the Developer version with SP1 and have had to reinstall because
> the localhost Reports DBs were lost and there's no obvious way to get just
> two empty DB's created...
> So, after install, I can edit and deploy to local and Production. BUT: When
> I use the "Add New Report" wizard i get a showstopper! I can choose the data
> source, key in a simple "SELECT * FROM dbo.ItemType" (for example) as the
> query, select "Tabular" style, then move all fields to the "Details" section.
> When I click "Next", I get the following error:
> TITLE: Microsoft SQL Server
> ---
> This wizard will close because it encountered the following error:
> For help, click:
> http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
> ---
> ADDITIONAL INFORMATION:
> Key cannot be null.
> Parameter name: key (mscorlib)
> For help, click:
> http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
> --
> Program Location:
> at System.Collections.Hashtable.get_Item(Object key)
> at Microsoft.ReportDesigner.Wizards.ChooseTableStyle.get_StyleBitmap()
> at
> Microsoft.ReportDesigner.Wizards.ChooseTableStyle.OnEnterPage(EventArgs e)
> at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
> at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
> nextPage)
> at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender,
> EventArgs e)
> ---
> BUTTONS:
> OK
> ---
> For help, click:
> http://www.microsoft.com/events.asp?progname=MicrosoftSqlServer&progver=9.0&msgsrc=CreatePubWizard.dll&msgid=CantStartSnapshotAgent
> ---
> BUTTONS:
> OK
> ---
> I tried clicking the links from the "Send Message Text As E-mail" option on
> the "Help" button's drop-down, but the response is a 404 - not found (pretty
> message but that's the error code).
> I did a Web Search (MSN Search) for keywords in the message but came up empty.
> No forum entry with the keywords.
> I've run the install again, rebooted, etc, etc, but the error persists...
> Clues? Solutions? Please...|||Report Designer version#:
Microsoft SQL Server Report Designer
Version 8.00.743.00
Is this SP1? If not, perhaps that's my issue?|||I found the SP1 download and applied it - Version 8.00.878.00
However, I still get the original bomb!
Help, please, again...
Friday, February 24, 2012
Add constant variable to report project
I'd like to add a constant string variable to my report project.
Something like stCOMPANY_NAME. I'd like the reports to be portable to some
of our other plants so it would be nice so be able to change the company
name on the header of all the reports by just changing one constant
somewhere in the project. I know this could be done at the report level
(putting a constant in the code block for the report), but can it be done at
the project, public level ?I'm sure there must be an OLEDB/ODBC driver for reading in text files.
Stick in a text file and read it in as a dataset.
If you use the OLEDB provider for ODBC drivers, you can read from Excel.
Hope that helps.
Chris
D Witherspoon wrote:
> I'd like to add a constant string variable to my report project.
> Something like stCOMPANY_NAME. I'd like the reports to be portable
> to some of our other plants so it would be nice so be able to change
> the company name on the header of all the reports by just changing
> one constant somewhere in the project. I know this could be done at
> the report level (putting a constant in the code block for the
> report), but can it be done at the project, public level ?|||You can make Company name as parameter.
Kiran
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:%23$PMtNocFHA.3040@.TK2MSFTNGP14.phx.gbl...
> I'm sure there must be an OLEDB/ODBC driver for reading in text files.
> Stick in a text file and read it in as a dataset.
> If you use the OLEDB provider for ODBC drivers, you can read from Excel.
> Hope that helps.
> Chris
> D Witherspoon wrote:
>> I'd like to add a constant string variable to my report project.
>> Something like stCOMPANY_NAME. I'd like the reports to be portable
>> to some of our other plants so it would be nice so be able to change
>> the company name on the header of all the reports by just changing
>> one constant somewhere in the project. I know this could be done at
>> the report level (putting a constant in the code block for the
>> report), but can it be done at the project, public level ?
>
Something like stCOMPANY_NAME. I'd like the reports to be portable to some
of our other plants so it would be nice so be able to change the company
name on the header of all the reports by just changing one constant
somewhere in the project. I know this could be done at the report level
(putting a constant in the code block for the report), but can it be done at
the project, public level ?I'm sure there must be an OLEDB/ODBC driver for reading in text files.
Stick in a text file and read it in as a dataset.
If you use the OLEDB provider for ODBC drivers, you can read from Excel.
Hope that helps.
Chris
D Witherspoon wrote:
> I'd like to add a constant string variable to my report project.
> Something like stCOMPANY_NAME. I'd like the reports to be portable
> to some of our other plants so it would be nice so be able to change
> the company name on the header of all the reports by just changing
> one constant somewhere in the project. I know this could be done at
> the report level (putting a constant in the code block for the
> report), but can it be done at the project, public level ?|||You can make Company name as parameter.
Kiran
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:%23$PMtNocFHA.3040@.TK2MSFTNGP14.phx.gbl...
> I'm sure there must be an OLEDB/ODBC driver for reading in text files.
> Stick in a text file and read it in as a dataset.
> If you use the OLEDB provider for ODBC drivers, you can read from Excel.
> Hope that helps.
> Chris
> D Witherspoon wrote:
>> I'd like to add a constant string variable to my report project.
>> Something like stCOMPANY_NAME. I'd like the reports to be portable
>> to some of our other plants so it would be nice so be able to change
>> the company name on the header of all the reports by just changing
>> one constant somewhere in the project. I know this could be done at
>> the report level (putting a constant in the code block for the
>> report), but can it be done at the project, public level ?
>
Add commend to report.
Hi all,
I am currently doing some reports using reporting service for my company.
Some of the report require SA to input commend after analyse the report data
and their commend will be part of the report. ( Ex: commends on chart showed
in report)
Anyway I can accomplish this?
Thanks!
Regards,
KH Tan.KH TAN [KT], on Tuesday, May 24, 2005 at 19:33 (-0700) wrote:
KT> I am currently doing some reports using reporting service for my company.
KT> Some of the report require SA to input commend after analyse the report data
KT> and their commend will be part of the report. ( Ex: commends on chart showed
KT> in report)
KT> Anyway I can accomplish this?
you have to do web access, where they could write comments - store that to
database, and generate that from it.
--
How do you protect mail on web? I use http://www.2pu.net
["Dammit, Jim, I'm not a doctor, just a terrible actor!"]
I am currently doing some reports using reporting service for my company.
Some of the report require SA to input commend after analyse the report data
and their commend will be part of the report. ( Ex: commends on chart showed
in report)
Anyway I can accomplish this?
Thanks!
Regards,
KH Tan.KH TAN [KT], on Tuesday, May 24, 2005 at 19:33 (-0700) wrote:
KT> I am currently doing some reports using reporting service for my company.
KT> Some of the report require SA to input commend after analyse the report data
KT> and their commend will be part of the report. ( Ex: commends on chart showed
KT> in report)
KT> Anyway I can accomplish this?
you have to do web access, where they could write comments - store that to
database, and generate that from it.
--
How do you protect mail on web? I use http://www.2pu.net
["Dammit, Jim, I'm not a doctor, just a terrible actor!"]
Sunday, February 19, 2012
add another report to the existing report
Hi All,
I have one report with 3 graphs on it. Now I want to add another report to the existing report. So basically I have seperate reports and I want to add all together that way when I do the preview it will show may be 3 of 1 page, 3 of 2 and 3 of 3 pages. Please let me know the process how to add the reports.
Thanks
Rozarm02
You would use the sub-report control in the toolbox. Right click on it and open up the properties window. There are several tab on that dialog that allow you to select the report, set parameters, etc.
BobP
Add an export format
I want to add an export option for the report dropdown menus that will allow
users to export reports to tab delimited files. This will allow them to open
up the data of a report directly in excel.
Does anyone know if this can be done?First you can render a report in Excel already using one of the rendering
extensions... You may have the report rendered in excel immediately by
calling the report from a URL passing the rendering extention , or having a
user subscribe to the report in Excel.
However if you really wish to, you may write a new rendering extension which
renders a tab delimited report, and load it into reporting services, and
modify some config files... This is documented in books on line... look for
rendering extensions..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:A5CBA5C7-9FA1-40A1-8132-45DC9E838D60@.microsoft.com...
>I want to add an export option for the report dropdown menus that will
>allow
> users to export reports to tab delimited files. This will allow them to
> open
> up the data of a report directly in excel.
> Does anyone know if this can be done?|||Were you able to get this adding to the dropdown menu? -Peter
"Wayne Snyder" wrote:
> First you can render a report in Excel already using one of the rendering
> extensions... You may have the report rendered in excel immediately by
> calling the report from a URL passing the rendering extention , or having a
> user subscribe to the report in Excel.
> However if you really wish to, you may write a new rendering extension which
> renders a tab delimited report, and load it into reporting services, and
> modify some config files... This is documented in books on line... look for
> rendering extensions..
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "DBA72" <DBA72@.discussions.microsoft.com> wrote in message
> news:A5CBA5C7-9FA1-40A1-8132-45DC9E838D60@.microsoft.com...
> >I want to add an export option for the report dropdown menus that will
> >allow
> > users to export reports to tab delimited files. This will allow them to
> > open
> > up the data of a report directly in excel.
> >
> > Does anyone know if this can be done?
>
>
users to export reports to tab delimited files. This will allow them to open
up the data of a report directly in excel.
Does anyone know if this can be done?First you can render a report in Excel already using one of the rendering
extensions... You may have the report rendered in excel immediately by
calling the report from a URL passing the rendering extention , or having a
user subscribe to the report in Excel.
However if you really wish to, you may write a new rendering extension which
renders a tab delimited report, and load it into reporting services, and
modify some config files... This is documented in books on line... look for
rendering extensions..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:A5CBA5C7-9FA1-40A1-8132-45DC9E838D60@.microsoft.com...
>I want to add an export option for the report dropdown menus that will
>allow
> users to export reports to tab delimited files. This will allow them to
> open
> up the data of a report directly in excel.
> Does anyone know if this can be done?|||Were you able to get this adding to the dropdown menu? -Peter
"Wayne Snyder" wrote:
> First you can render a report in Excel already using one of the rendering
> extensions... You may have the report rendered in excel immediately by
> calling the report from a URL passing the rendering extention , or having a
> user subscribe to the report in Excel.
> However if you really wish to, you may write a new rendering extension which
> renders a tab delimited report, and load it into reporting services, and
> modify some config files... This is documented in books on line... look for
> rendering extensions..
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "DBA72" <DBA72@.discussions.microsoft.com> wrote in message
> news:A5CBA5C7-9FA1-40A1-8132-45DC9E838D60@.microsoft.com...
> >I want to add an export option for the report dropdown menus that will
> >allow
> > users to export reports to tab delimited files. This will allow them to
> > open
> > up the data of a report directly in excel.
> >
> > Does anyone know if this can be done?
>
>
Thursday, February 16, 2012
add additional right scale on chart report
Hi there,
I have a case. I have 3 numeric fields and 1 category field to be displayed on bar chart reports. the problem is 2 of the 3 numeric fields have significant different scale value. so I need to add additonal scale at the right side of bar chart to represent 1 numeric fields + the 2 other numeric fields at the left side scale (Y). Please advice. Thanks.
R'gards
Toni
A secondary y-axis is currently not supported natively. Adding this feature in RS charts natively is under consideration for a future release.
Note: RS 2005 also has the new CustomReportItem feature. This enables ISVs to offer add-on components which integrate with RS 2005 and e.g. provide secondary y-axis in charts already today. E.g. Dundas Software offers such a product which needs to be licensed separately.
-- Robert
Add a print button on to Reportviewer of srs
Hi,
I have generated reports using SQL server reporting services 2000. I need to
put a print button in the report tool bar which will prints the content
displayed in the report(only the report content). Can any body tell me how to
enable the print option in the tool bar of repotviewer.
Thanks in advance
AjayAjay,
To my knowledge, you need to export to PDF, then print from acrobat reader.
Ask for a second opinion though...
--
TIM ELLISON
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:8517AE77-6E2F-4F29-AB37-93FEEEA5C173@.microsoft.com...
> Hi,
> I have generated reports using SQL server reporting services 2000. I need
to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how
to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||Ajay,
It is simple ... you can't :-(
However, if you are willing to hold you breath a couple of months, Service
Pack 2 will come with a print control and you will have the much coveted
print button.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:8517AE77-6E2F-4F29-AB37-93FEEEA5C173@.microsoft.com...
> Hi,
> I have generated reports using SQL server reporting services 2000. I need
> to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how
> to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||When Service Pack 2 will be released ? Is it before SQL Server 2005 ?
Thanks
"Teo Lachev [MVP]" wrote:
> Ajay,
> It is simple ... you can't :-(
> However, if you are willing to hold you breath a couple of months, Service
> Pack 2 will come with a print control and you will have the much coveted
> print button.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/|||The last think I heard is that it will be slated to January - February
timeframe.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Keenz" <Keenz@.discussions.microsoft.com> wrote in message
news:E60EFA77-809F-476B-BE01-FD58778ABF05@.microsoft.com...
> When Service Pack 2 will be released ? Is it before SQL Server 2005 ?
> Thanks
> "Teo Lachev [MVP]" wrote:
>> Ajay,
>> It is simple ... you can't :-(
>> However, if you are willing to hold you breath a couple of months,
>> Service
>> Pack 2 will come with a print control and you will have the much coveted
>> print button.
>> --
>> Hope this helps.
>> ---
>> Teo Lachev, MVP [SQL Server], MCSD, MCT
>> Author: "Microsoft Reporting Services in Action"
>> Publisher website: http://www.manning.com/lachev
>> Buy it from Amazon.com: http://shrinkster.com/eq
>> Home page and blog: http://www.prologika.com/|||Has the new service pack release for print option in the report veiwer .
Please need the information urgently.
Thanks
Ajay kumar
"Ajay Kumar" wrote:
> Hi,
> I have generated reports using SQL server reporting services 2000. I need to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||SP2 will contain a new print button on the tool bar. We are currently in
beta.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
> Has the new service pack release for print option in the report veiwer .
> Please need the information urgently.
> Thanks
> Ajay kumar
> "Ajay Kumar" wrote:
>> Hi,
>> I have generated reports using SQL server reporting services 2000. I need
>> to
>> put a print button in the report tool bar which will prints the content
>> displayed in the report(only the report content). Can any body tell me
>> how to
>> enable the print option in the tool bar of repotviewer.
>> Thanks in advance
>> Ajay|||Any news from service pack 2 ?
Greetz
"Daniel Reib [MSFT]" wrote:
> SP2 will contain a new print button on the tool bar. We are currently in
> beta.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
> news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
> >
> > Has the new service pack release for print option in the report veiwer .
> >
> > Please need the information urgently.
> >
> > Thanks
> > Ajay kumar
> >
> > "Ajay Kumar" wrote:
> >
> >> Hi,
> >>
> >> I have generated reports using SQL server reporting services 2000. I need
> >> to
> >> put a print button in the report tool bar which will prints the content
> >> displayed in the report(only the report content). Can any body tell me
> >> how to
> >> enable the print option in the tool bar of repotviewer.
> >>
> >> Thanks in advance
> >>
> >> Ajay
> >>
>
>|||Not sure what you are asking. SP2 was released last week.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Koen" <Koen@.discussions.microsoft.com> wrote in message
news:6D56A681-91A3-4E37-8910-E63F38D321DF@.microsoft.com...
> Any news from service pack 2 ?
> Greetz
> "Daniel Reib [MSFT]" wrote:
>> SP2 will contain a new print button on the tool bar. We are currently in
>> beta.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
>> news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
>> >
>> > Has the new service pack release for print option in the report veiwer
>> > .
>> >
>> > Please need the information urgently.
>> >
>> > Thanks
>> > Ajay kumar
>> >
>> > "Ajay Kumar" wrote:
>> >
>> >> Hi,
>> >>
>> >> I have generated reports using SQL server reporting services 2000. I
>> >> need
>> >> to
>> >> put a print button in the report tool bar which will prints the
>> >> content
>> >> displayed in the report(only the report content). Can any body tell me
>> >> how to
>> >> enable the print option in the tool bar of repotviewer.
>> >>
>> >> Thanks in advance
>> >>
>> >> Ajay
>> >>
>>
I have generated reports using SQL server reporting services 2000. I need to
put a print button in the report tool bar which will prints the content
displayed in the report(only the report content). Can any body tell me how to
enable the print option in the tool bar of repotviewer.
Thanks in advance
AjayAjay,
To my knowledge, you need to export to PDF, then print from acrobat reader.
Ask for a second opinion though...
--
TIM ELLISON
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:8517AE77-6E2F-4F29-AB37-93FEEEA5C173@.microsoft.com...
> Hi,
> I have generated reports using SQL server reporting services 2000. I need
to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how
to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||Ajay,
It is simple ... you can't :-(
However, if you are willing to hold you breath a couple of months, Service
Pack 2 will come with a print control and you will have the much coveted
print button.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:8517AE77-6E2F-4F29-AB37-93FEEEA5C173@.microsoft.com...
> Hi,
> I have generated reports using SQL server reporting services 2000. I need
> to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how
> to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||When Service Pack 2 will be released ? Is it before SQL Server 2005 ?
Thanks
"Teo Lachev [MVP]" wrote:
> Ajay,
> It is simple ... you can't :-(
> However, if you are willing to hold you breath a couple of months, Service
> Pack 2 will come with a print control and you will have the much coveted
> print button.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/|||The last think I heard is that it will be slated to January - February
timeframe.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Keenz" <Keenz@.discussions.microsoft.com> wrote in message
news:E60EFA77-809F-476B-BE01-FD58778ABF05@.microsoft.com...
> When Service Pack 2 will be released ? Is it before SQL Server 2005 ?
> Thanks
> "Teo Lachev [MVP]" wrote:
>> Ajay,
>> It is simple ... you can't :-(
>> However, if you are willing to hold you breath a couple of months,
>> Service
>> Pack 2 will come with a print control and you will have the much coveted
>> print button.
>> --
>> Hope this helps.
>> ---
>> Teo Lachev, MVP [SQL Server], MCSD, MCT
>> Author: "Microsoft Reporting Services in Action"
>> Publisher website: http://www.manning.com/lachev
>> Buy it from Amazon.com: http://shrinkster.com/eq
>> Home page and blog: http://www.prologika.com/|||Has the new service pack release for print option in the report veiwer .
Please need the information urgently.
Thanks
Ajay kumar
"Ajay Kumar" wrote:
> Hi,
> I have generated reports using SQL server reporting services 2000. I need to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||SP2 will contain a new print button on the tool bar. We are currently in
beta.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
> Has the new service pack release for print option in the report veiwer .
> Please need the information urgently.
> Thanks
> Ajay kumar
> "Ajay Kumar" wrote:
>> Hi,
>> I have generated reports using SQL server reporting services 2000. I need
>> to
>> put a print button in the report tool bar which will prints the content
>> displayed in the report(only the report content). Can any body tell me
>> how to
>> enable the print option in the tool bar of repotviewer.
>> Thanks in advance
>> Ajay|||Any news from service pack 2 ?
Greetz
"Daniel Reib [MSFT]" wrote:
> SP2 will contain a new print button on the tool bar. We are currently in
> beta.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
> news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
> >
> > Has the new service pack release for print option in the report veiwer .
> >
> > Please need the information urgently.
> >
> > Thanks
> > Ajay kumar
> >
> > "Ajay Kumar" wrote:
> >
> >> Hi,
> >>
> >> I have generated reports using SQL server reporting services 2000. I need
> >> to
> >> put a print button in the report tool bar which will prints the content
> >> displayed in the report(only the report content). Can any body tell me
> >> how to
> >> enable the print option in the tool bar of repotviewer.
> >>
> >> Thanks in advance
> >>
> >> Ajay
> >>
>
>|||Not sure what you are asking. SP2 was released last week.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Koen" <Koen@.discussions.microsoft.com> wrote in message
news:6D56A681-91A3-4E37-8910-E63F38D321DF@.microsoft.com...
> Any news from service pack 2 ?
> Greetz
> "Daniel Reib [MSFT]" wrote:
>> SP2 will contain a new print button on the tool bar. We are currently in
>> beta.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
>> news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
>> >
>> > Has the new service pack release for print option in the report veiwer
>> > .
>> >
>> > Please need the information urgently.
>> >
>> > Thanks
>> > Ajay kumar
>> >
>> > "Ajay Kumar" wrote:
>> >
>> >> Hi,
>> >>
>> >> I have generated reports using SQL server reporting services 2000. I
>> >> need
>> >> to
>> >> put a print button in the report tool bar which will prints the
>> >> content
>> >> displayed in the report(only the report content). Can any body tell me
>> >> how to
>> >> enable the print option in the tool bar of repotviewer.
>> >>
>> >> Thanks in advance
>> >>
>> >> Ajay
>> >>
>>
Monday, February 13, 2012
Add A dynamic image value In Header Reports
Dear All,
i have a problem ,
In report header i add an image, we know that in header and footer i can't enter value like this "value=Fields!<Name>.value " and i can replace it with
"value =reportitems!<Name>.value " but and this didn't work exactly , it just work local or when i post the image from my computer like this/images/">"http://<computrname>/images/<image name>" but when write /images/">"http://<servercomputername>/images/<image name>" it doesn't work
Please Help
with my best regard
khalil hamad
Hi,
From your description, it seems that you want to add a image in your report, right?
You can include stored images in a report by specifying a URL to the image. When you use an external image in a report, the image source is set to External and the value for the image is the URL address to the image. For a report published to a report server configured for native mode, use a full or relative path. For example,/images/image1.jpg">http://<servername>/images/image1.jpg. For a report published to a report server configured in SharePoint integrated mode, use a fully qualified URL. For example,//Documents/images/image1.jpg">http://<SharePointservername>/<site>/Documents/images/image1.jpg.
For more information, see:
http://msdn2.microsoft.com/en-us/library/ms156482.aspx
Thanks.
Add a dynamic Image Value In Header Reports
Dear All,
I need your help , i need to add an image in header and the image take the value from database , it will not work because
the header and footer cann't take from database or value=Fields!<FieldName>.value it will not work soo i drag a text box in body and made the
image call the text box value by reportitems<FieldName>.value , In this case the textbox has error because the datatype of data it binary
and the text box value appear like this "#Error"
Note: it's soo urgent
Please any one help Thanks
Hi,
From your description, it seems that you want to add the image into your report's header, also, you want to add the data in the page's header right?
If so, for adding data into page's header, you may refer the following article:
http://blog.irm.se/blogs/eric/archive/2006/05/25/Reporting-Services_3A00_-Data-in-a-Page-Header.aspx
For adding images, just include stored images in a report by specifying a URL to the image. When you use an external image in a report, the image source is set to External and the value for the image is the URL address to the image.
More information see:http://msdn2.microsoft.com/en-us/library/ms156482.aspx
Thanks.
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.
Sunday, February 12, 2012
Ad hoc reports multiple tables
HI,
i am a new to SSRS and i am facing a problem with Ad Hoc reporting.
actually i wanted to create a report with data from two different table. now its the relation between these two tables that is not allowing me to create a req. adhoc report.
i am a new to SSRS and i am facing a problem with Ad Hoc reporting.
actually i wanted to create a report with data from two different table. now its the relation between these two tables that is not allowing me to create a req. adhoc report.
i want the report to have data from table A and table B and the relationship between A and B is many-to-many. so in the database design i have an associate table C between A and B. so in .dsv file i have C related to A as one-to-many and C related to B as one to many.
Now here how do i get data from both table A and table B?
i will put some more info, put the question in a different way.
Say I have 3 tables related as shown in the diagram below
Say
1) plan organization
2) plan
3) plan opportunity
in the ad hoc report I wanted to have data from plan organization and plan opportunity.
How will I do that?
plan organization >-|- Plan -|--< plan opportunityone-to-many relation between plan and plan organization
one-to-many relation betweeb plan and plan opportunity
Ad hoc reports multiple tables
HI,
i am a new to SSRS and i am facing a problem with Ad Hoc reporting.
actually i wanted to create a report with data from two different table. now its the relation between these two tables that is not allowing me to create a req. adhoc report.
i am a new to SSRS and i am facing a problem with Ad Hoc reporting.
actually i wanted to create a report with data from two different table. now its the relation between these two tables that is not allowing me to create a req. adhoc report.
i want the report to have data from table A and table B and the relationship between A and B is many-to-many. so in the database design i have an associate table C between A and B. so in .dsv file i have C related to A as one-to-many and C related to B as one to many.
Now here how do i get data from both table A and table B?
i will put some more info, put the question in a different way.
Say I have 3 tables related as shown in the diagram below
Say
1) plan organization
2) plan
3) plan opportunity
in the ad hoc report I wanted to have data from plan organization and plan opportunity.
How will I do that?
plan organization >-|- Plan -|--< plan opportunityone-to-many relation between plan and plan organization
one-to-many relation betweeb plan and plan opportunity
Ad hoc reporting for sql server
Hi,
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
Henry
I have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
Henry
I have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
Ad hoc reporting for sql server
Hi,
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
HenryI have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
HenryI have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
Ad hoc reporting for sql server
Hi,
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
HenryI have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
HenryI have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
Ad Hoc Company Security
Is there a way in Ad Hoc reports to prevent users from querying data from another companies data? In my database each table row has a company Id so that my application only displays data for the currently logged in users company. Can I inforce this in ad hoc reporting?
Thanks,
Duncan
You could create a view that displays only the data for the company of the current user and then grant permission only to that view.
|||The only problem with that is that you would need to create a different view for every company and have to set up a different model for each company. We have decided to leave out Ad-Hoc reporting for this version of our application and look at other alternatives later.
Duncan
Subscribe to:
Posts (Atom)