473,326 Members | 2,173 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

SQL Reporting Services (SRS) and DB2

In case anyone finds this helpful:

Microsoft SQL Reporting Services (SRS) works with DB2, but parameters
for stored PROCEDUREs do not, as It does not pull a list of them from
DB2. The problem, IIRC, is that SRS sends a query to the system
catalog, and quotes the PROCEDURE's name (as it must) but the
PROCEDURE's name is in smallcaps. Which means, unless the PROCEDURE is
CREATEd in quoted-smallcaps, SRS's query will return no parameters.

The solution someone here provided was to hack the XML manually. Using
a SELECT statement that does the equivalent of the stored PROCEDURE, it
will generate a report. Then, the XML report file can be editted adding
the two section of parameters, and changing the SELECT statement to a
CALL statement.

HTH,
B.

Oct 31 '06 #1
0 3025

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jay Douglas | last post by:
Greetings. For the most part, my reporting solutions have been ad-hoc (usually html for web apps) to the current project. I'm currently trying to figure out what would be a good reporting...
8
by: Brendan Reynolds | last post by:
I'm trying to integrate SQL Server Reporting Services reports into an ASP.NET app (SRS 2000, ASP.NET 1.1). I know how to do this using direct URL addressing, but this exposes in the query string...
8
by: Woody Splawn | last post by:
I am asking this question here because I asked this question in the Reporting Services Newsgroup and did not get an answer. Does anyone know if Reporting Services is intended to work in a...
2
by: Brad Pears | last post by:
Has anyone used SQL Server Reporting Services to develop reports with using vb .net ?? We are wondering whether or not to stick with Crystal (hence purhcase the pro version of .net) or go with the...
1
by: rmk | last post by:
How can I get the 2000 and 2005 versions of SQL Server Reporting Services both working on my development laptop ????? I have ASP.NET 1.1 and 2.0 installed on my laptop. I have Visual Studio...
0
by: =?Utf-8?B?amRzdGVudG8=?= | last post by:
(I apologize if this is a repeat. I was told to post under the managed news group. I'm a little confused, but...) I'm running SRS 2000 with SP2 and I'm using IE 6.0 with SP2 (and IE 7.0) to...
3
by: Blasting Cap | last post by:
I'm using VS 2005, SQL 2005 reporting services. SQL reporting services is working, and I have it both on my local computer, as well as on a server. I've created a report in the SQL Business...
1
by: =?Utf-8?B?Skw=?= | last post by:
I am doingn dual-server installation. The reporting services is installed on the Application-Tier. Since we already have a report server farm, we would like to utilize that farm to house all the...
0
by: Doug | last post by:
Can anyone show me how to display an internet link within an SRS report? I tried to include an href link and it didn't work. How is this normally done? I have posted this question out on the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.