Sub-report within Matrix
Hello,
Is it possible insert a table as subreport into a Matrix? What i want is to
allow the user to drill-down and see the detail of the matrix.
Thanks in advance,
Carlos Tag: How do you create a new chart for each variable? Tag: 80675
Error when i try access Report Server
Hello,
After i applied SP2 in a Cluster of SQL SERVER 2005 the Report Server
stop working.
The message is "The report server cannot open a connection to the report
server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get
Online Help For more information about this error navigate to the report
server on the local server machine, or enable remote errors "
How can I fix this issue ?
I already try rsconfig to recreate the key.
Thank you.
Marcelo. Tag: How do you create a new chart for each variable? Tag: 80674
RSViewerPage failing
RSViewerPage.aspx will not display reports.
Configuration-
Reporting services in Sharepoint Integrated mode, all security is
managed in the underlying database. Data model and connection use
integrated security. User can create and modify Sharepoint content
freely in the reports folder. If we create a wep part page, we are
able to add a reporting web part, which shows the data appropriate to
that user. However, when RSViewerPage.aspx tries to render a Reporting
Services Report, 'Access Denied' is returned to the browser.
Something specific to the execution of RSViewerPage.aspx is failing.
Is there anything else I should be investigating? Tag: How do you create a new chart for each variable? Tag: 80672
gif image shows jpg image does not
I am puzzeled as to why one image type will show in the browser when the
report is viewed and the other type (jpg) will not.
I have both image files in the same folder as the report. When I view the
report with te gif image and select the properties for the image I get all
the infomationsuch as type = GIF location etc. When I use the jpg image I
get a red x box and no values show for the image when right clicked and the
properties option is selected.
Any ideas of why this may be?
Thanks, Tag: How do you create a new chart for each variable? Tag: 80669
SSRS-Grand totals in the last page when grouping is applied
Hi All,
My report consists of a single group based on customer name and
we print totals in group footer for each customer. The "Page Break On
End" is set to true for the group. I have also placed the grand totals
in the table footer. However, the grand total alone prints in the new
page, after the last reporting group. I want it to be printed just
below the group total of the last group in the report, instead of
printing in a new page. Is there any way to do it?.
Any help will be appreciated.
Cheers,
Pradeep Tag: How do you create a new chart for each variable? Tag: 80667
Subscriptions on SRS 2005
We are in the process of migrating all of our reports from anSRS 2000
implementation to an SRS 2005 implementation, and I am having a
problem with subscriptions.
On the old box, when someone wanted to subscribe to a report, they
simply clicked on the subscription link and their domain name
(example: pmcbride) would appear in the To: field. They would add a
subscription, hit enter, and the subscription would work.
Now, it appears to work exacltly the same. However, when they submit
the description, it does not work. Why? Because the new implementation
requires not just the domain name, but the entier email address in the
To: box. So where the subscription page opens with "pmcbride" on the
screen, what SRS needs is the full email address of
pmcbride@mycompany.com.
Did we forget to set some important configuration?
Thanks in advance...
Paul Tag: How do you create a new chart for each variable? Tag: 80658
Adding a dataset problem
Good Morning,
I have a very frustrating problem. I have a report that needs two datasets
from two different data sources. i have reaports that already have multiple
datasources, and eveything is okay. THis report however, when i add the
dataset and source, once i save the report, it chages the datasource. let me
explain:
dset A uses dsource 1
i added
dset B that uses dsource 2
everything sets up ok, then, i go into the properties of dset A, and it has
dsource 2 as the dsource
if i change that back to 1, then it changes dset B's dsource to 1 also
This is really driving me nuts!
TIA ~K
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200807/1 Tag: How do you create a new chart for each variable? Tag: 80655
Reporting Services - Portfolio Server Installation/Config Issue
Hello
I'm setting up a demo box for Portfolio Server for the PM group. I
installed everything on the one box for the demo:
Microsoft Windows Server 2003 R2 SP2
SQL Server 2005 SP2
SharePoint Server 2007 SP1
Project Server 2007 SP1
Portfolio Server 2007
After installing SQL Server, I ran the configuration utility for Reporting
Services and everything was successful.
After installing Portfolio Server 2007, I was supposed to check to see that
the Reporting Services integration was successful by browsing to a couple of
sites:
http://<servername>/ReportServer
http://<servername>/Reports
I can navigate to http://<servername>/ReportServer, but when I navigate to
http://<servername>/Reports I get the following error:
Server Error in '/Reports' Application.
--------------------------------------------------------------------------------
Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: Cannot use 'partitionResolver' unless the mode is
'StateServer' or 'SQLServer'.
Source Error:
Line 183: </webParts>
Line 184: <machineKey
validationKey="588ECF8DDE8B5707B90224C2C11E60EAA6B8A6974AC80560"
decryptionKey="74F69FA872AED6DDB83CEECC7644DCE1FFDB34ECF6A949CF"
validation="SHA1" />
Line 185: <sessionState mode="SQLServer" timeout="60"
allowCustomSqlDatabase="true"
partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver,
Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c" />
Line 186: </system.web>
Line 187: <runtime>
Source File: c:\inetpub\wwwroot\web.config Line: 185
--
any help would be appreciated. Tag: How do you create a new chart for each variable? Tag: 80652
Dynamic Report on Dynamic recordset
sorry,
maybe I didn't searched enough, but I can't find an answer for this
question ...
I'd like to build a dynamic report based on a dynamic record set.
How can I do it?
Just to make me understand, here you find an hypothetical origin of
data I'd like to output:
create procedure [dbo].[SP_Dynamic_report]
@param int =1
as
BEGIN
if @param=1
select top 10 * from SYSOBJECTS
else
select top 10 * from syscolumns
end
then the user can chose between param 1 or 2 and get
in the same report different data ...
exec [SP_Dynamic_report] 1
exec [SP_Dynamic_report] 2
Is it possible?
Can you provide me an example? or a link?
Thank you very much for any help!
Lorenzo Tag: How do you create a new chart for each variable? Tag: 80649
Can I define what order I want reports displayed via SQL Server
I have a list of reports, which I have published into one folder.
Ideally, I would like to order the reports when the user logs onto the
web page. At the moment they default to A to Z sorting. Users would
not want to see the details screen.
can this be done?
Thanks
Paddy Tag: How do you create a new chart for each variable? Tag: 80647
What is the best way to setup SSIS, SSRS, SSAS within a two note cluster?
Hi All,
I'm fairly new Clustering and I'm looking for advices. I have successfully
setup a test SQL Server Database Engine on a two node ( passive/active )
cluster using MS Virtual Server. I would now like to setup SQL Server
Reporting, Integration, and Analysis Services on the same cluster. I know
Reporting Services and Integration Services are not cluster aware. Can
anyone give me advices on the best way to install these three components for
high availability within a two node cluster. Are there any good articles or
install guides on the web?
Current Setup:
1) SQL Server 2005 Ent - Windows 2003 Ent
2) Node1 - Windows 2003 Ent
3) Node2 - Windows 2003 Ent
Sorry if my Cluster terminology is incorrect.
Many thanks
Colin Tag: How do you create a new chart for each variable? Tag: 80646
return results from stored procedure
Hi All,
I have managed to get my Reporting Services 2005 up and running.
I have a question though: Instead of defining my dataset as a text query
(such as select * from table..) I would like to define it as executing a
stored procedure. This stored procedure will be a little bit more complex
than just a simple (select * from..)
In other words, it will look into some tables and then iterate through some
values...
WHILE
BEGIN
-- get my values here
-- Here i Used to build a string with the data needed and just print it
(e.g., SET @PrintString = @Value + N' ' + @Value2... )
-- PRINT @SPrintString
FETCH NEXT..@Value, @Value2..
...
END
I used to create a string and print that, but now I would like the results
in a table form so that Reporting Services renders them correctly as a
report. Should I somehow create a temporary table and insert the values in
it and then have my query something of the form (INSERT INTO TempTable exec
sp_StoredProcedure) ? Is this the correct way of doing it or should I go
about it a different way ? And if this is the solution, how would I create
this table and how would I actually return it ? Would I just create it
before calling the stored procedure and drop it after that?
Thanks. Tag: How do you create a new chart for each variable? Tag: 80645
Access a named parameter in an RDLC report in local mode
I need information on how to programmatically access a named parameter
within an RDLC file associated with a ReportViewer in local mode.
I also want to verify that a parameter set up like this
=Fields!personID.Value will return what I am expecting.
For example if "LName" is displayed in a box and the parameter name is
'person_id' with the associated parameter value =fields!PersonID.Value then
when the user clicks on the textbox with "George" then the ID for george
will be available in that parameter and can be obtined programatically from
the ReportViewer1_Drillthrough event.
Thanks,
Doug Tag: How do you create a new chart for each variable? Tag: 80644
Help on installing Reporting Services NOT on Default Web Site
Hello:
Long story short, our IIS box does not have the "Default Web Site". And,
for whatever reason, it does not appear that you can configure SRS 2005 to
use a site other than the Default Web Site.
I have followed Microsoft's instructions, on creating a new web site for
SRS. The problem is that we cannot use port 80, because that is our
Sharepoint port. (The instructions seem to indicate the typical port used is
the one for the Default Web Site--port 80.)
Anyway, when I went into SRS Report Configuration Manager to create a new
virtual directory, it errorred-out saying that it could not create one.
Has anyone out there been able to successfully configure SQL Reporting
Services 2005 to use a site (and a port) other than the Default Web Site? If
so, I really would like instructions for this, other than the ones that
Microsoft has posted (because they are not any good). You may please send
them to my Hotmail address at sqlprogrammer@hotmail.com.
Thanks! Please let me know, if you have these instructions.
SQL Programmer (it's just a name) Tag: How do you create a new chart for each variable? Tag: 80640
Problem with printing a SSRS report
Hi
I'm working with SQL Server 2005 and Visual Studio 2005. I'm creating an SSRS report and everything works fine...until I try to print it. When I do so on the local printer it prints fine, but when I run the application via Citrix and use ThinPrint to print it the report prints itself, but strangely, on paper I get black rectangles instead of my textboxes with information.
Help would be appreciated, thanks!
Da
From http://www.developmentnow.com/g/115_2006_3_0_1_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com Tag: How do you create a new chart for each variable? Tag: 80638
Export to MSProject
Is there a direct way to export a SQL Server report to a Microsoft Project
file?
--
stullhe104 Tag: How do you create a new chart for each variable? Tag: 80637
change label, error with asp and network reports
Hi,
I hope someone can help me with three newbie problems .
1) When I have a user editable parameter in my reports, the user can edit
the parameter and then hit the "View Report" button to see the report. Is it
possible to change the label of the "View Report" button to something else?
I basically need to translate "View Report" to a different language.
2) For some reason, I can't start my Report Server. All the configuration
sections are OK except the "Web Service Identity" one. In that particular
section, my ASP .NET Service account is listed as "COMPUTERNAME\ASPNET"
where COMPUTERNAME is my computer name. The ASP.NET State service is
started. When I hit the Apply button, I get an error stating:
"There was an error setting the identity for the web service. The previously
set identity will still be used." If I click "Tell me more about this
problem... " it says
"ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error
has occurred in the WMI Provider. Error Code 8007056B" in the
"SetWebServiceIdentity" function.
3) I am using SQL Express and I have two computers on a network (no domain,
the computers are just in a workgroup.) I have both SQL Server Express and
Reporting Services installed on Machine 1 together with IIS. Would it be OK
to connect from Machine 2 to Machine 1 via IIS and navigate to the Report
Server and see the Machine's 1 reports ? By that I mean, is it technically
possible and is it allowed by the licensing constraints ?
Thanks! Tag: How do you create a new chart for each variable? Tag: 80634
Document layout in reporting services
Good morning,
I have a question about reporting services. I have to generate a report in a
document format, not a table format. Does it allow a report layout to
simulate a document? Fields in a paragraph, text dinamically suited to
margins....
If not, could you give me any suggestions?? I have to generate it for ms crm.
Thank you very much!!! Tag: How do you create a new chart for each variable? Tag: 80633
Connecting with management studio?
I recently installed a new server with SQL 2005 Server and want to use
Reporting Services. I've logged into the server as the local administrator,
launched the Management Studio and tried to connect to the Reporting
Services. It blanks the server name so I reenter it and click connect.
That's when I get the error message listed below. I added the local
adminastrator account as well as the Domain Admins account to the
Distributed COM User group but I still cannot connect. What am I doing
wrong? Why can't I connect to the Reporting Services Server?
Heck, while I'm here, I was reading through the tutorials on Microsoft's web
site and it tells me to go to the following URL:
http://<serverName>/reports
I find that when I go there, replacing the <serverName> tag with my actuall
server name, it prompts me for login credentials but won't take anything I
give it. If I go to http://localhost/reports, it works just fine. Can
someone explain that too me too? Why does it do this? The server name does
resolve in DNS.
Thanks in advance,
Linn
TITLE: Connect to Server
------------------------------
Cannot connect to cmw-sql2k5.
------------------------------
ADDITIONAL INFORMATION:
A connection to the report server failed. Most likely, you do not have
permission to connect to the computer. You should either try to connect
using report server URL for the Server name, or if the Distributed COM Users
group exists on the remote computer, verify that you are a member.
(Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
BUTTONS:
OK
------------------------------ Tag: How do you create a new chart for each variable? Tag: 80629
subtotal problem of calculated field
I have a matrix report that is based on an AS cube. There are two
dimensions defined as rows. The report has three measures, 'Total
Value' and 'Number of Orders' are from the cube, and 'Average value'
is an calculated one, equals 'Total Value'/'Number of Orders'. Below
is what the report shows.
State Zip Total Value Number of Orders
Average Value
AZ 11111 100
10 10
11112 200
5 40
11113 90
10 9
Total 390
25 10 (should be 15.6)
AK 22222 400
2 200
22221 50
1 50
Total 450
3 200 (should be 150)
As you can see the problem, in total, I am getting the currect
sum(Total Value) and sum(Number of Orders), but Average Value is not
correct, it's replicating the first row of the group.
Can someone tell me where the problem is coming from? Thanks very much. Tag: How do you create a new chart for each variable? Tag: 80626
Access to the temp directory is denied
I receive the following error when I go to http://<server>/reports for SSRS
2005.
Access to the temp directory is denied. Identity 'CASINO\MichaelP' under
which XmlSerializer is running does not have sufficient permission to access
the temp directory. CodeDom will use the user account the process is using
to do the compilation, so if the user doesnt have access to system temp
directory, you will not be able to compile. Use Path.GetTempPath() API to
find out the temp directory location.
This issue seemed to go away when full access was given to the 'Everyone'
group on C:\Windows\Temp. I want to avoid giving the 'Everyone' group full
access to the Server's Temp directory. Any ideas? Tag: How do you create a new chart for each variable? Tag: 80623
Querying ExecutionLog Table
I'm writing a quick and dirty report to give to the powers that be showing
just how often - or not - certain reports are run. I'm also going to include
some other anecdotal information. One of the things I'd like to include are
average times (rendering, data retrieval, etc.). Here's what I've got so far
that works really well:
SELECT DISTINCT
c.Name,
c.Path,
c.CreationDate,
c.Description,
COUNT(e.ReportID) AS [Number of Times Executed],
MAX(e.TimeStart) AS [Last Time Executed],
AVG(e.[RowCount]) AS [AVG NUMBER OF ROWS],
AVG(e.timedataretrieval) AS [AVG DATA RETRIEVAL TIME],
AVG(e.timeprocessing) AS [AVG TIME PROCESSING],
AVG(e.timerendering) AS [AVG TIME RENDERING]
FROM ExecutionLog AS e INNER JOIN
Catalog AS c ON e.ReportID = c.ItemID
GROUP BY c.Name, c.Path, c.CreationDate, c.Description
ORDER BY c.Name
While this works great, there's one problem. When calculating the averages,
I only want to include those executions that had a status of rsSuccess. For
example, one report was run three times. One execution had an rsInternalError
with a row count of half a million. The other two times succeeded and had
significantly lower row counts. When calculating the averages, I'd like to
throw out the "bad" executions, so as not to skew the results.
Could someone suggest how I can tweak this query to accomplish this?
Thanks!! Tag: How do you create a new chart for each variable? Tag: 80621
Parameter not being passed to stored procedure
eI have created a report that contains several stored procedures and they
except a parameter to be passed to it... The parameter name is the same in
all the stored procedures. I created a report parameter and named it exactly
like the parameter in the stored procedures. I can run the report on my
local machine without a problem. However, when I depolyed the report to a
report server and try to run the report it comes back with an error that one
of the sp's is excepting a parameter.
How can I fix this since it works on my machine without an issue.
Thanks in advance. Tag: How do you create a new chart for each variable? Tag: 80615
Show/Hide Tables based on parameters
Has anyone created a report that shows/hides tables based on selections from
a parameter list? For example, I have a report that has 10 tables, each one
summarizing sales and dollars based on various types within an attribute of a
product. I want to allow the user to be able to select 1,2,3 or all 10
attibutes, then display the ones they select on the report.
Has any one done this or changes attributes of a table, textbox, etc...
based on some parameter or even a value?
Any help would be greatly appreciated.
Thanks in advance for your help.
Tim Tag: How do you create a new chart for each variable? Tag: 80609
Subscription tab not showing
All,
This is probably something stupid that I am missing, but I want to set
up a subscription and there is no subscription tab in Report Manager;
I only have View, Properties and History.
The security around here is insane, so could this be a security
setting?
Any ideas would be helpful; our DBA knows nothing about Reporting
Services!
Thanks,
Kathryh Tag: How do you create a new chart for each variable? Tag: 80608
Background image on more than one page?
Greetings,
My background image only prints on the first page of a multi page
report. Is that normal?
I do have some logic that tells what image to use but even when I took
that out and hard coded it to a single image it still did not repeat.
Thank you. Tag: How do you create a new chart for each variable? Tag: 80606
Upgrading from SQL Report Server Standard Edition to Enterprise Ed
Hi All,
We need to upgrade our production environment from SQL Report Server
Standard Edition to Enterprise Edition. For some reason, our development
environment is already on Enterprise Edition whereas the production
environment is on Standard Edition. So we canâ??t test in the development
environment to see what the impact of upgrading will be.
So here are some questions we have:
â?¢ Is this considered a high risk change?
â?¢ What impact should we expect to the reports we currently have?
â?¢ What other risks/issues should we be looking into regarding such an upgrade?
Thanks for any pointers.
Regards,
Woody Tag: How do you create a new chart for each variable? Tag: 80602
call external program (msaccess) from RS report?
I have developed a set of reports using Reporting Services that look at a SQL
Server database. There is a simple MS Access application for users to
insert/update/delete records against the same database. I've been asked if
there is a way to click on a link/hyperlink in a field so that it brings up
the MS Access application with the same record loaded in the form. I've
found out how to start msaccess from the command line with a specific record
loaded (basically just use the /cmd switch for msaccess.exe to pass in a
parameter which is the ID value for the record in question). So, I would
like to stress that this isn't an MS Access question as I already have that
side of it figured out. The question is, can I enable something like the
existing 'ACTION' property with 'Jump to URL' from a column/field in a report
to run the required command line to start msaccess and pass in the value of
that field? I've tried using the file:/// URL and I can start MSAccess
itself but it doesn't work when trying to add the ADP file on the 'command
line' to open up the specific Access application. It would be nice if there
was a better method anyway.
Any suggestions?
Thanks Tag: How do you create a new chart for each variable? Tag: 80599
snapShot with userID
Hello.
I have a report with parameter that depend on another parameter that
take the value of the current user (=User!UserId).
The report run fine until I'm trying to make a snapshot of the report.
I then get the error:
"The defaultValue expression for the report parameter 'user_alias' has
a user profile dependency. (rsRuntimeUserProfileDependency)".
I didn't find any help onLine. Can anybody help with this issue?
Thanks in advance,
Roy. Tag: How do you create a new chart for each variable? Tag: 80596
Designer Louis Vuitton Utah Carryall - Coffee M92993coffee Handbags,
Designer Louis Vuitton Utah Carryall - Coffee M92993coffee Handbags,
Luxury, Best,Inspired
Designer Handbags : http://www.bagsbrand.com
Louis Vuitton Utah Carryall - Coffee M92993coffee Link :
http://www.bagsbrand.com/Louis-Vuitton-M92993coffee.html
Brand : Louis Vuitton ( http://www.bagsbrand.com/Louis-Vuitton-Handbags.html
)
Model : M92993coffee
Louis Vuitton Utah Carryall - Coffee Details :
Louis Vuitton dark coffee color leather bagRound type leather handle
with bronze color buckleZipper closure on top in bronze colorAd also
it has flat pocket om both sideFour bronze color stud at the
bottomComes with serial numbers, authenticity card, dust bag, and care
booklet SIZE: 16.5" x 10.6" x 9.4"
Louis Vuitton Utah Carryall - Coffee M92993coffee :
http://www.bagsbrand.com/Louis-Vuitton-M92993coffee.html Tag: How do you create a new chart for each variable? Tag: 80595
Good Monitoring tool
Hi All,
Does anyone have a recommendation of a monitoring tool? Something to
monitor a response time to a particular report on a scheduled basis?
Monitor spun up COM components? Thanks! Tag: How do you create a new chart for each variable? Tag: 80593
Report Model with SQL Uniqueidentifier data type - I can't filter on them.
I am trying to filter a resultset from a report model that contains columns
that have a sql uniqueidentifier data type. When I attempt to use one of
these columns in a filte expression I get the following error. I haven't
been able to modify the report or model to accept this data type in a
filter. Anyone using Report Model with UniqueIdentifier data type?
Thanks,
Steve MunLeeuw Tag: How do you create a new chart for each variable? Tag: 80591
Page break not working
I have two tables one on top of the other... The second table is only
visible, via expression. I have set the properties of the table to insert a
new page after it... When I run the report, it does not add a page break and
the table is visible due to the expression being told to show the table...
However, if I make the table visible no matter what it inserts the page
break. Has anyone come across this issue and found a resolution. Tag: How do you create a new chart for each variable? Tag: 80590
Internationalization Support for SSRS
Hi,
i want to make my report multilingual.for that i need change static
label(like table header,textbox text) used in report according to the current
culture.How i can do it?
Also i am using ReportViewer control which is using text like
"Find,Next,Export etc...." with their tooltip.How i can change those in
site's present culture info?
Note: i am not looking for the client localization,but looking to make a
site for say Germany as weel as in English and language will change according
to user choice.
Thanks
Dibakar Tag: How do you create a new chart for each variable? Tag: 80587
Multiple Rectangles with Tables and Matrices on one Page
I'm working on report that has multiple tables and matrices divided up into 2
rectangles on one report plus a subreport at the bottom.
The problem I'm having is that in Print Prview mode it moves the rectangle
and all the information to a 2nd page so I end up with a lot of white space
on the first page next to the 1st Rectangle.
At first It was having problems with matrices and tables showing with a
significant amount of white space between them when I had everything in one
rectangle. Then I divided the 2 columns of tables and matrices into 2
rectangles and now get the above problem. I have everything in one group but
cannot get the 2 to stay side by side.
Thanks in advance to any suggesstions.
--
Wayne Hess Tag: How do you create a new chart for each variable? Tag: 80586
Sharepoint integration + publishing through ISA Server problems
Hello.
I'm trying to publish my internal sharepoint portal in internet using ISA
Server Sharepoint publication. All works fine except reporting services that
is integrated with Sharepoint. Consider my intranet portal URL to be
http://myportal and Internet URL of the same portal published is
http://portal.mydomain.com
So
First of all when I tried to browse .rdl-files in Sharepoint list, IE was
automatically changing URL from
http://portal.mydomain.com/doclist/myreport.rdl
to
http://portal.mydomain.com/doclist/myreport.rdl
Then I read a good article here
http://blogs.msdn.com/sharepoint/archive/2007/03/06/what-every-sharepoint-administrator-needs-to-know-about-alternate-access-mappings-part-1.aspx
and made a mapping of internet URL to local URL. After that, loading .rdl
files in IE leads to error "The request failed with an empty response".
Trying to browse .rdl files through reportviewer.aspx interface (ReportServer
directory) leads to internal error. Here is a log file (sorry, a part is in
Russian):
System.Web.HttpException: Error executing child request for
/ReportServer/Pages/ReportViewer.aspx. --->
Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: Тип
Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages,
Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c не Ñ?еализÑ?еÑ? IReportViewerMessages или не
найден.
at
Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded()
Can you help me troubleshoot this issue?
Thank you
Dmitry Jolobov Tag: How do you create a new chart for each variable? Tag: 80585
XPS support in Reporting Services 2005 or 2008
I see lots of information about the new XPS format but can't seem to find
anything on support for it within SQL Server 2005 or 2008 Reporting Services
(RC0). Will either support it like it does PDF as a report format?
Thanks
SJ Tag: How do you create a new chart for each variable? Tag: 80583
Inserting data from an excel file to SQL Server
Hi,
I have an auto generated excel file(.xlsx) in a particular format .
I tried importing the file to the SQL server database using the query
below.
SELECT * INTO temp_ExcelData2 FROM OPENROWSET('Microsoft.ACE.OLEDB.
12.0','Excel 12.0 Xml;Database=C:\test
\DashboardData.xlsx;HDR=No;IMEX=1','SELECT * FROM [Sheet1$]')
It is showing an error as
Could not locate registry entry for OLE DB provider
'Microsoft.ACE.OLEDB.12.0'. SELECT * INTO temp_ExcelData2 FROM
OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 Xml;Database=C:\test
\DashboardData.xlsx;HDR=YES;IMEX=1','SELECT * FROM [Sheet1$]') OLE DB
error trace [Non-interface error: Provider not registered.].
Also I tried importing an xls file using the below command the same
worked perfectly fine.
SELECT * INTO temp_ExcelData FROM OPENROWSET('Microsoft.Jet.OLEDB.
4.0','Excel 8.0;Database=C:\test\mydata.xls;IMEX=1','SELECT * FROM
[Data$]')
Please provide help Tag: How do you create a new chart for each variable? Tag: 80577
Invoice / Customer Datasets question
Hi Guys,
I am trying to create an invoice report. Essentially, there are two datasets
in use, the invoice set itself, with the main fields such as invoice number,
invoice items etc and the dsCustomer which contains the customer addresses.
I have the invoice details fine, but I want to be able to extract the
customer address details from the dsCustomer for each invoice in the
invoiceDetaisl Data Region and I cant work out how to do this. How can I
fill/filter/lookup List 1's fields
based on the customerID in List 2. Yeah, I could make one huge Datasetwith
all the details repeated a billion times, but there has to be an intelligent
way to do this. Am I just making life difficult for myself ? A different
approach ?
Any help is appreciated ! - Thanks
[***************** List1 - dsCustomer *******************]
[ CustomerID
[ CustomerAddress
[******************************************************]
[**************** List2 - dsInvoice ************************]
[ CustomerID
[ InvoiceNumber
[ Invoice Date
[
[ *************** List 3 Invoice Details ************
[
[*******************************************************] Tag: How do you create a new chart for each variable? Tag: 80574
Converting Crystal Report Into SQL2005 Reporting Services
Hi All,
I'm going to convert some Crystal reports into 2005 RP. I'm still new
in RP. Could someone here translate the below code from Crystal report
into 2005 RP step by step from where to define the variable until how
to display the variable at the footer section.
Basically this report will display a page total at the footer section
on every pages and at the end of the pages it will display the grand
total.
PAGE HEADER SECTION
@Init
//Code starts
WhilePrintingRecords;
shared numbervar NETBAL_TOT := 0;
shared numbervar NETCE_TOT := 0;
//Code Ends
DETAIL SECTION
@Add
//Code starts
WhilePrintingRecords;
shared numbervar NETBAL_TOT:= NETBAL_TOT +
{SP_RPT_CRR_BRROW_LENDINGRPT.CRR FOR TRANSACTION};
shared numbervar NETCE_TOT:= NETCE_TOT +
{SP_RPT_CRR_BRROW_LENDINGRPT.CE};
//Code Ends
FOOTER SECTION
//Code starts
WhilePrintingRecords;
Shared numbervar NETCE_TOT;
NETCE_TOT;
//Code Ends Tag: How do you create a new chart for each variable? Tag: 80572
Additional action during a Drill through ~ accessing a parameter
Durng a drillthrouogh or back event of the ReportViewer. I want to assign
my own dataset to the "jump".
I want to obtain the parameter that I have assigned to the hyperlink actions
for a textbox in a repport. Then I want to use this paramter as part of a
filter with a dataTable.Select method to filter and merge data into a new
dataTable then use that new table as the DataSource for reportViewer for the
resulting "Jump" (drill in or out).
What I need to know for this post is;
1.) How do I access this parameter in code?
2.) Does the hyperlink action perform any built-in behaviors that would get
in the way of my desired goal? (and if so how should I get around those
behaviors?)
Thanks,
Doug Tag: How do you create a new chart for each variable? Tag: 80570
Report databases on existing db server
I would like to deploy reporting services to 60 users. We have SQL
2005 Standard Edition
I have 1 ad server, 1 IIS server & 1 db server on the dmz.
All the apps on the IIS server have the databases on the db server. I
was hoping to run the reporting services front end webpages on the IIS
server and store the report databases & report data on the db server.
So that we dont have to install SQL server on the IIS server or allow
direct access to the db server
It seems microsoft see this as scale-out architrecture and requires
enterprise edition. This seems odd that we need two copies of sql
server just to do things securely. Can anyone claify if this is the
case or if I have misunderstood.
Thanks. Tag: How do you create a new chart for each variable? Tag: 80565
how to preserve carriage returns and new line feeds?
I am reading in ntext values in a textbox using SSRS 2005. When previewing in
BIDS, the carriage returns are maintained but when deployed to the server and
viewing the results in the browser, the carriage returns are ignored.
Does anyone know how to preserve carriage returns in SSRS 2005? I have tried
using chr() but nothing changes. Someone suggested creating a function to
read in the values then re-rendering into HTML to see if it will preserve the
formatting.
Does anyone have any suggestions to resolve this issue? Tag: How do you create a new chart for each variable? Tag: 80564
your needs are more in this site,hot and sweat to your dreams,don't
your needs are more in this site,hot and sweat to your dreams,don't
miss to visit,come on guys and girls hurry up.
**************************************************************************http://
anushkahollywood.blogspot.com/
******************************************************************************************************* Tag: How do you create a new chart for each variable? Tag: 80563
Paging Issue
I'm working on a report with the following structure.
Header
Table 1: Summary Data
Table 2: State Detail
Footer
The report should be a total of 4 pages: 1 summary and 1 each for three
states. I've set the Table 2 state grouping level to give me a page break
after each State. When it renders to PDF, I keep getting a blank last page
for a total of 5 pages. Each state section is sufficient to fit on it's own
page. If I remove Table 1, the report correctly prints 3 pages. I've
encountered this problem before and it appears as though any time two tables
are placed together like this, the page breaks on grouping levels in the
second table yield blank pages.
Any ideas? Help would sure be appreciated.
Thanks,
Ted Tag: How do you create a new chart for each variable? Tag: 80562