OLAP calculated membres and Report Model/Builder

My question is related to Report Builder but my data model is build using OLAP database so I am posting my question in OLAP group in case this issues is related to OALP side.

I have OLAP database. There are 5 cubes and one linked cube. My one linked cube has mapped all 5 cubes (like virtual cube in AS 2000) I am using AS 2005.

In my linked cube I have calculated members. I created a Report model using my olap database in reporting services.

In report builder I am not able to see my calculated members when I select linked cube. Is there any thing I am missing?

Thanks for help - Ashok

I think this may be related to whether the calculations are associated with a measure group. The Report Model only seems to list measures that are associated with a measure group. Try going into the calculations tab for your cube clicking on the calculation properties button (looks like a little window with a yellow hand over it) as associating your calculations with a measure group. Unfortunately I think you will need to delete and re-generation your report model.

OLAP AS Connection Weirdness

I have a stand alone win2k3 report server(i.e. SQL is not on the box).
RS SP1 is installed
I have a SQLRS report developed in visual studio (also loaded on RS
box) that runs MDX against an analysis services cube. I am using the
OLE DB provider for OLAP services 8.0. (Note that we had to run
ptsfull.exe to get the pivot table service and 8.0 provider to be
available)
I can successfully preview the report in visual studio.
When I upload the report to Report Manger, the report bombs with...
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'AAHP'.
(rsErrorOpeningConnection) Get Online Help
Database '<source name>' does not exist.
Am I missing something on the report server?
Thanks!Jim wrote:
> When I upload the report to Report Manger, the report bombs with...
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'AAHP'.
> (rsErrorOpeningConnection) Get Online Help
> Database '<source name>' does not exist.
> Am I missing something on the report server?
The report bombs while uploading?
Do you tried to open the AS-DB in the analysis-manager on the reportserver?
regards
Frank|||Sorry, no. The report bombs when I try to run it via report manager. I
can open the AS-DB and cube in Analysis Manger (which is Not on the
report server). I have a role setup that should allow the stored
credentials to successfully authenticate.|||Jim wrote:
> Sorry, no. The report bombs when I try to run it via report manager. I
> can open the AS-DB and cube in Analysis Manger (which is Not on the
> report server). I have a role setup that should allow the stored
> credentials to successfully authenticate.
Jim,
lets have a look into the eventlog of the server where the analysis cube
resides.
Source MSSQLSERVEROLAPSERVER.
If there errors with something like "NT-Authority/Anonymous" your
security-settings on the report-server are not valid (especially the
settings in internet service manager)
If there aren't any errors it become more difficult...Do you run ptsfull on
reportserver either?
regards
Frank|||Thanks for your replies.
No errors unfortunately.
I ran ptsfull on the reportserver.
As I mentioned I can connect to the AS server via Visual Studio. As
soon as I deploy the report (using a stored connection or shared
connection) to report manager it won't run. I'm running MDAC 2.8 on the
report server.|||Jim wrote:
> As I mentioned I can connect to the AS server via Visual Studio.
Yes..i know. You can connect to the AS from YOUR workstation and your
reportserver can't as you wrote.
The problem should be between reportserver and AS-server but wich problem? I
dont know!
regards
frank|||Just to clarify...
Visual Studio - where I am developing the reports - is on the report
server.|||Jim,
I am having same problems and was wondering if you found solution of this
one. Thanks.
"Jim" wrote:
> Just to clarify...
> Visual Studio - where I am developing the reports - is on the report
> server.
>

Ok, now here's an easy one...

Programic render of a report to PDF, how to remove my html, and or render to a
pdf w/out my param controls?
Can I call a NewWindow? or what should I do?
I've overcome how to pass a .Net dataset to a SSRS report, smoke & mirrors, it
is a kluge but I've got it working.
It wasn't much code just'a diff'rent way o'do'in it...
Anyway, my pain.
On my web page when I call w/rs.render my report to html I get my report at top
of the page and my one paramerter textbox and cmd button, no problem.
However, when I render to PDF, .Net Dev opens and I get trash back.
When I save to disk I get trash, but if I rename and edit in Notepad, strip out
everything after the EOF, basically all the html, I get a viable PDF.Ok, I found the Example Sample FindSavePrint....
I just thought that it'd be simpler....
I streamed it....
TIA
JeffP....
"JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
news:uZdyHO4bEHA.252@.TK2MSFTNGP10.phx.gbl...
> Programic render of a report to PDF, how to remove my html, and or render to a
> pdf w/out my param controls?
> Can I call a NewWindow? or what should I do?
> I've overcome how to pass a .Net dataset to a SSRS report, smoke & mirrors, it
> is a kluge but I've got it working.
> It wasn't much code just'a diff'rent way o'do'in it...
> Anyway, my pain.
> On my web page when I call w/rs.render my report to html I get my report at
top
> of the page and my one paramerter textbox and cmd button, no problem.
> However, when I render to PDF, .Net Dev opens and I get trash back.
> When I save to disk I get trash, but if I rename and edit in Notepad, strip
out
> everything after the EOF, basically all the html, I get a viable PDF.
>
>

Ok, Apply buttons not working in Report Manager

This is weird. I have 2 different installs of Reporting Services and both do
nothing when trying to upload a file (rdl, datasource, etc)
Basically, the buttons don't post. This also happens on the apply buttons
in the property pages. Cancel and other buttons work.
I am thinking I need something in my aspnet_client folder that is not there.
I have the 1_1_4322 folder.
Any ideas?Nevermind...This happens if you misconfigure stuff when moving virtual
directories to another site.
"Eric" wrote:
> This is weird. I have 2 different installs of Reporting Services and both do
> nothing when trying to upload a file (rdl, datasource, etc)
> Basically, the buttons don't post. This also happens on the apply buttons
> in the property pages. Cancel and other buttons work.
> I am thinking I need something in my aspnet_client folder that is not there.
> I have the 1_1_4322 folder.
> Any ideas?

OK code experts....

Hi all,
I have been working on this report for a while and I am lost. I am getting
#'s correctly but I am getting too many part numbers. I was wondering, with a
union all query if i can put the where clause on the outside of the union all
statement like the order by clause? And if not does anyone have a suggestion
on what I should do? The first select statement is my problem because I can
not put the where clause of the other two select statements. As soon as I
join all or a combination of tables I get duplicate rows of data.
Here is the syntax...
SELECT *
FROM(
SELECT
PART.PART_NBR AS PART_NBR
,PART.PART_DESC AS PART_DESC
,PART.PART_TYPE AS PART_TYPE
,NULL AS ORD_STAT
,NULL AS ORD_TYPE
,NULL AS RQMT_CODE
,INVD.QTY_ON_HAND AS QTY_ON_HAND
,TO_NUMBER(NULL) AS DEMAND_OVERDUE
,TO_NUMBER(NULL) AS DEMAND_0TO20DAYS
,TO_NUMBER(NULL) AS DEMAND_21TO40DAYS
,TO_NUMBER(NULL) AS DEMAND_41TO60DAYS
,TO_NUMBER(NULL) AS DEMAND_61TO90DAYS
,TO_NUMBER(NULL) AS DEMAND_91TO180DAYS
,TO_NUMBER(NULL) AS DEMAND_BEYOND
,TO_NUMBER(NULL) AS ORDERS_OVERDUE
,TO_NUMBER(NULL) AS ORDERS_0TO20DAYS
,TO_NUMBER(NULL) AS ORDERS_21TO40DAYS
,TO_NUMBER(NULL) AS ORDERS_41TO60DAYS
,TO_NUMBER(NULL) AS ORDERS_61TO90DAYS
,TO_NUMBER(NULL) AS ORDERS_91TO180DAYS
,TO_NUMBER(NULL) AS ORDERS_BEYOND
,TO_DATE(NULL) AS PLAN_RECV_DATE
,TO_DATE(NULL) AS DATE_REQD
,TO_NUMBER(NULL) AS QTY_REQD
,TO_NUMBER(NULL) AS OTY_ISSUED
,TO_NUMBER(NULL) AS DEMAND_DUE
,NULL AS ORD_NBR
,NULL AS LINE_NBR
,NULL AS STATUS
,CASE WHEN
INVD.LOCATION_KEY LIKE '%SCRAP%' OR INVD.LOCATION_KEY LIKE '%DROP%'
THEN 0
ELSE INVD.QTY_ON_HAND
END AS AVAIL_INVENTORY
,CASE WHEN
INVD.LOCATION_KEY LIKE '%LINE%'
THEN INVD.QTY_ON_HAND
ELSE 0
END AS LINE_INVENTORY
,CASE WHEN
INVD.LOCATION_KEY LIKE '%SCRAP%'
THEN INVD.QTY_ON_HAND
ELSE 0
END AS SCRAP_INVENTORY
,CASE WHEN
RPAD(TO_CHAR(INVD.LOCATION_KEY),2) = 'RD' OR RPAD(TO_CHAR(INVD.LOCATION_KEY)
,2) = 'RI'
THEN INVD.QTY_ON_HAND
ELSE 0
END AS RECV_INVENTORY
,CASE WHEN
INVD.LOCATION_KEY LIKE '%DROP%'
THEN INVD.QTY_ON_HAND
ELSE 0
END AS DROP_INVENTORY
,TO_NUMBER(NULL) AS QTY_ON_ORD
,TO_NUMBER(NULL) AS QTY_RECVD
,NULL AS HORIZON
FROM
PART
,INVD
WHERE
PART.PART_NBR = INVD.PART_NBR (+) AND
PART.PART_TYPE = 'P'
UNION ALL
SELECT
PART.PART_NBR AS PART_NBR
,PART.PART_DESC AS PART_DESC
,PART.PART_TYPE AS PART_TYPE
,NULL AS ORD_STAT
,NULL AS ORD_TYPE
,RQMT.RQMT_CODE AS RQMT_CODE
,TO_NUMBER(NULL) AS QTY_ON_HAND
,TO_NUMBER(CASE WHEN
RQMT.DATE_REQD < SYSDATE
THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
ELSE 0
END) AS DEMAND_OVERDUE
,TO_NUMBER(CASE WHEN
RQMT.DATE_REQD >= SYSDATE AND RQMT.DATE_REQD <= (SYSDATE + 20)
THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
ELSE 0
END) AS DEMAND_0TO20DAYS
,TO_NUMBER(CASE WHEN
RQMT.DATE_REQD >= (SYSDATE + 21) AND RQMT.DATE_REQD <= (SYSDATE + 40)
THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
ELSE 0
END) AS DEMAND_21TO40DAYS
,TO_NUMBER(CASE WHEN
RQMT.DATE_REQD >= (SYSDATE + 41) AND RQMT.DATE_REQD <= (SYSDATE + 60)
THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
ELSE 0
END) AS DEMAND_41TO60DAYS
,TO_NUMBER(CASE WHEN
RQMT.DATE_REQD >= (SYSDATE + 61) AND RQMT.DATE_REQD <= (SYSDATE + 90)
THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
ELSE 0
END) AS DEMAND_61TO90DAYS
,TO_NUMBER(CASE WHEN
RQMT.DATE_REQD >= (SYSDATE + 91) AND RQMT.DATE_REQD <= (SYSDATE + 180)
THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
ELSE 0
END) AS DEMAND_91TO180DAYS
,TO_NUMBER(CASE WHEN
RQMT.DATE_REQD >= (SYSDATE + 181)
THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
ELSE 0
END) AS DEMAND_BEYOND
,TO_NUMBER(NULL) AS ORDERS_OVERDUE
,TO_NUMBER(NULL) AS ORDERS_0TO20DAYS
,TO_NUMBER(NULL) AS ORDERS_21TO40DAYS
,TO_NUMBER(NULL) AS ORDERS_41TO60DAYS
,TO_NUMBER(NULL) AS ORDERS_61TO90DAYS
,TO_NUMBER(NULL) AS ORDERS_91TO180DAYS
,TO_NUMBER(NULL) AS ORDERS_BEYOND
,TO_DATE(NULL) AS PLAN_RECV_DATE
,RQMT.DATE_REQD AS DATE_REQD
,RQMT.QTY_REQD AS QTY_REQD
,RQMT.QTY_ISSUED AS OTY_ISSUED
,(RQMT.QTY_REQD - RQMT.QTY_ISSUED) AS DEMAND_DUE
,NULL AS ORD_NBR
,NULL AS LINE_NBR
,NULL AS STATUS
,TO_NUMBER(NULL) AS AVAIL_INVENTORY
,TO_NUMBER(NULL) AS LINE_INVENTORY
,TO_NUMBER(NULL) AS SCRAP_INVENTORY
,TO_NUMBER(NULL) AS RECV_INVENTORY
,TO_NUMBER(NULL) AS DROP_INVENTORY
,TO_NUMBER(NULL) AS QTY_ON_ORD
,TO_NUMBER(NULL) AS QTY_RECVD
,NULL AS HORIZON
FROM
PART
,RQMT
WHERE
PART.PART_NBR = RQMT.COMP_PART_NBR AND
PART.PART_TYPE = 'P' AND
(RQMT.RQMT_CODE <> 'CL' AND
RQMT.RQMT_CODE <> 'IS')
UNION ALL
SELECT
PART.PART_NBR AS PART_NBR
,PART.PART_DESC AS PART_DESC
,PART.PART_TYPE AS PART_TYPE
,OORD.ORD_STAT AS ORD_STAT
,OORD.ORD_TYPE AS ORD_TYPE
,NULL AS RQMT_CODE
,TO_NUMBER(NULL) AS QTY_ON_HAND
,TO_NUMBER(NULL) AS DEMAND_OVERDUE
,TO_NUMBER(NULL) AS DEMAND_0TO20DAYS
,TO_NUMBER(NULL) AS DEMAND_21TO40DAYS
,TO_NUMBER(NULL) AS DEMAND_41TO60DAYS
,TO_NUMBER(NULL) AS DEMAND_61TO90DAYS
,TO_NUMBER(NULL) AS DEMAND_91TO180DAYS
,TO_NUMBER(NULL) AS DEMAND_BEYOND
,CASE WHEN
OORD.PLAN_RECV_DATE < SYSDATE
THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
ELSE 0 END AS ORDERS_OVERDUE
,CASE WHEN
OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE <= (SYSDATE + 20)
THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
ELSE 0 END AS ORDERS_0TO20DAYS
,CASE WHEN
OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE >= (SYSDATE + 21)
AND
OORD.PLAN_RECV_DATE <= (SYSDATE + 40)
THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
ELSE 0 END AS ORDERS_21TO40DAYS
,CASE WHEN
OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE >= (SYSDATE + 41)
AND
OORD.PLAN_RECV_DATE <= (SYSDATE + 60)
THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
ELSE 0
END AS ORDERS_41TO60DAYS
,CASE WHEN
OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE >= (SYSDATE + 61)
AND
OORD.PLAN_RECV_DATE <= (SYSDATE + 90)
THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
ELSE 0
END AS ORDERS_61TO90DAYS
,CASE WHEN
OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE >= (SYSDATE + 91)
AND
OORD.PLAN_RECV_DATE <= (SYSDATE + 180)
THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
ELSE 0
END AS ORDERS_91TO180DAYS
,CASE WHEN
OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE >= (SYSDATE + 181)
THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
ELSE 0
END AS ORDERS_BEYOND
,OORD.PLAN_RECV_DATE AS PLAN_RECV_DATE
,TO_DATE(NULL) AS DATE_REQD
,TO_NUMBER(NULL) AS QTY_REQD
,TO_NUMBER(NULL) AS OTY_ISSUED
,TO_NUMBER(NULL) AS DEMAND_DUE
,OORD.ORD_NBR AS ORD_NBR
,OORD.SUB_ORD_NBR AS LINE_NBR
,OORD.ORD_STAT AS STATUS
,TO_NUMBER(NULL) AS AVAIL_INVENTORY
,TO_NUMBER(NULL) AS LINE_INVENTORY
,TO_NUMBER(NULL) AS SCRAP_INVENTORY
,TO_NUMBER(NULL) AS RECV_INVENTORY
,TO_NUMBER(NULL) AS DROP_INVENTORY
,OORD.QTY_ON_ORD AS QTY_ON_ORD
,OORD.QTY_RECVD AS QTY_RECVD
,CASE WHEN PLAN_RECV_DATE < SYSDATE THEN 'OVERDUE'
WHEN PLAN_RECV_DATE >= SYSDATE AND PLAN_RECV_DATE <= (SYSDATE + 20) THEN
'0 To 20 Days'
WHEN PLAN_RECV_DATE >= (SYSDATE + 21) AND PLAN_RECV_DATE <= (SYSDATE +
40) THEN '21 To 40 Days'
WHEN PLAN_RECV_DATE >= (SYSDATE + 41) AND PLAN_RECV_DATE <= (SYSDATE +
60) THEN '41 To 60 Days'
WHEN PLAN_RECV_DATE >= (SYSDATE + 61) AND PLAN_RECV_DATE <= (SYSDATE +
90) THEN '61 To 90 Days'
WHEN PLAN_RECV_DATE >= (SYSDATE + 91) AND PLAN_RECV_DATE <= (SYSDATE +
180) THEN '91 To 180 Days'
ELSE 'BEYOND' END AS HORIZON
FROM
PART
,OORD
WHERE
PART.PART_NBR = OORD.PART_NBR (+) AND
PART.PART_TYPE = 'P' AND
OORD.ORD_TYPE = 'PO' AND
(OORD.ORD_STAT <> '--' AND
OORD.ORD_STAT <> 'OR' AND
OORD.ORD_STAT <> 'FP' AND
OORD.ORD_STAT <> 'PL' AND
OORD.ORD_STAT <> 'CL' )
)
ORDER BY 1 ,25,28,29
Any suggestions will be appreciated.
Thanks in advance!!!!
Kerrie
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200602/1Hi,
"UNION ALL" will include all records ie even duplicate records. Try putting
"Union"
It will eliminate duplicate records.
Regards
Amarnath
"Ksorrell via SQLMonster.com" wrote:
> Hi all,
> I have been working on this report for a while and I am lost. I am getting
> #'s correctly but I am getting too many part numbers. I was wondering, with a
> union all query if i can put the where clause on the outside of the union all
> statement like the order by clause? And if not does anyone have a suggestion
> on what I should do? The first select statement is my problem because I can
> not put the where clause of the other two select statements. As soon as I
> join all or a combination of tables I get duplicate rows of data.
> Here is the syntax...
> SELECT *
> FROM(
> SELECT
> PART.PART_NBR AS PART_NBR
> ,PART.PART_DESC AS PART_DESC
> ,PART.PART_TYPE AS PART_TYPE
> ,NULL AS ORD_STAT
> ,NULL AS ORD_TYPE
> ,NULL AS RQMT_CODE
> ,INVD.QTY_ON_HAND AS QTY_ON_HAND
> ,TO_NUMBER(NULL) AS DEMAND_OVERDUE
> ,TO_NUMBER(NULL) AS DEMAND_0TO20DAYS
> ,TO_NUMBER(NULL) AS DEMAND_21TO40DAYS
> ,TO_NUMBER(NULL) AS DEMAND_41TO60DAYS
> ,TO_NUMBER(NULL) AS DEMAND_61TO90DAYS
> ,TO_NUMBER(NULL) AS DEMAND_91TO180DAYS
> ,TO_NUMBER(NULL) AS DEMAND_BEYOND
> ,TO_NUMBER(NULL) AS ORDERS_OVERDUE
> ,TO_NUMBER(NULL) AS ORDERS_0TO20DAYS
> ,TO_NUMBER(NULL) AS ORDERS_21TO40DAYS
> ,TO_NUMBER(NULL) AS ORDERS_41TO60DAYS
> ,TO_NUMBER(NULL) AS ORDERS_61TO90DAYS
> ,TO_NUMBER(NULL) AS ORDERS_91TO180DAYS
> ,TO_NUMBER(NULL) AS ORDERS_BEYOND
> ,TO_DATE(NULL) AS PLAN_RECV_DATE
> ,TO_DATE(NULL) AS DATE_REQD
> ,TO_NUMBER(NULL) AS QTY_REQD
> ,TO_NUMBER(NULL) AS OTY_ISSUED
> ,TO_NUMBER(NULL) AS DEMAND_DUE
> ,NULL AS ORD_NBR
> ,NULL AS LINE_NBR
> ,NULL AS STATUS
> ,CASE WHEN
> INVD.LOCATION_KEY LIKE '%SCRAP%' OR INVD.LOCATION_KEY LIKE '%DROP%'
> THEN 0
> ELSE INVD.QTY_ON_HAND
> END AS AVAIL_INVENTORY
> ,CASE WHEN
> INVD.LOCATION_KEY LIKE '%LINE%'
> THEN INVD.QTY_ON_HAND
> ELSE 0
> END AS LINE_INVENTORY
> ,CASE WHEN
> INVD.LOCATION_KEY LIKE '%SCRAP%'
> THEN INVD.QTY_ON_HAND
> ELSE 0
> END AS SCRAP_INVENTORY
> ,CASE WHEN
> RPAD(TO_CHAR(INVD.LOCATION_KEY),2) = 'RD' OR RPAD(TO_CHAR(INVD.LOCATION_KEY)
> ,2) = 'RI'
> THEN INVD.QTY_ON_HAND
> ELSE 0
> END AS RECV_INVENTORY
> ,CASE WHEN
> INVD.LOCATION_KEY LIKE '%DROP%'
> THEN INVD.QTY_ON_HAND
> ELSE 0
> END AS DROP_INVENTORY
> ,TO_NUMBER(NULL) AS QTY_ON_ORD
> ,TO_NUMBER(NULL) AS QTY_RECVD
> ,NULL AS HORIZON
> FROM
> PART
> ,INVD
> WHERE
> PART.PART_NBR = INVD.PART_NBR (+) AND
> PART.PART_TYPE = 'P'
> UNION ALL
> SELECT
> PART.PART_NBR AS PART_NBR
> ,PART.PART_DESC AS PART_DESC
> ,PART.PART_TYPE AS PART_TYPE
> ,NULL AS ORD_STAT
> ,NULL AS ORD_TYPE
> ,RQMT.RQMT_CODE AS RQMT_CODE
> ,TO_NUMBER(NULL) AS QTY_ON_HAND
> ,TO_NUMBER(CASE WHEN
> RQMT.DATE_REQD < SYSDATE
> THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
> ELSE 0
> END) AS DEMAND_OVERDUE
> ,TO_NUMBER(CASE WHEN
> RQMT.DATE_REQD >= SYSDATE AND RQMT.DATE_REQD <= (SYSDATE + 20)
> THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
> ELSE 0
> END) AS DEMAND_0TO20DAYS
> ,TO_NUMBER(CASE WHEN
> RQMT.DATE_REQD >= (SYSDATE + 21) AND RQMT.DATE_REQD <= (SYSDATE + 40)
> THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
> ELSE 0
> END) AS DEMAND_21TO40DAYS
> ,TO_NUMBER(CASE WHEN
> RQMT.DATE_REQD >= (SYSDATE + 41) AND RQMT.DATE_REQD <= (SYSDATE + 60)
> THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
> ELSE 0
> END) AS DEMAND_41TO60DAYS
> ,TO_NUMBER(CASE WHEN
> RQMT.DATE_REQD >= (SYSDATE + 61) AND RQMT.DATE_REQD <= (SYSDATE + 90)
> THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
> ELSE 0
> END) AS DEMAND_61TO90DAYS
> ,TO_NUMBER(CASE WHEN
> RQMT.DATE_REQD >= (SYSDATE + 91) AND RQMT.DATE_REQD <= (SYSDATE + 180)
> THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
> ELSE 0
> END) AS DEMAND_91TO180DAYS
> ,TO_NUMBER(CASE WHEN
> RQMT.DATE_REQD >= (SYSDATE + 181)
> THEN (RQMT.QTY_REQD - RQMT.QTY_ISSUED)
> ELSE 0
> END) AS DEMAND_BEYOND
> ,TO_NUMBER(NULL) AS ORDERS_OVERDUE
> ,TO_NUMBER(NULL) AS ORDERS_0TO20DAYS
> ,TO_NUMBER(NULL) AS ORDERS_21TO40DAYS
> ,TO_NUMBER(NULL) AS ORDERS_41TO60DAYS
> ,TO_NUMBER(NULL) AS ORDERS_61TO90DAYS
> ,TO_NUMBER(NULL) AS ORDERS_91TO180DAYS
> ,TO_NUMBER(NULL) AS ORDERS_BEYOND
> ,TO_DATE(NULL) AS PLAN_RECV_DATE
> ,RQMT.DATE_REQD AS DATE_REQD
> ,RQMT.QTY_REQD AS QTY_REQD
> ,RQMT.QTY_ISSUED AS OTY_ISSUED
> ,(RQMT.QTY_REQD - RQMT.QTY_ISSUED) AS DEMAND_DUE
> ,NULL AS ORD_NBR
> ,NULL AS LINE_NBR
> ,NULL AS STATUS
> ,TO_NUMBER(NULL) AS AVAIL_INVENTORY
> ,TO_NUMBER(NULL) AS LINE_INVENTORY
> ,TO_NUMBER(NULL) AS SCRAP_INVENTORY
> ,TO_NUMBER(NULL) AS RECV_INVENTORY
> ,TO_NUMBER(NULL) AS DROP_INVENTORY
> ,TO_NUMBER(NULL) AS QTY_ON_ORD
> ,TO_NUMBER(NULL) AS QTY_RECVD
> ,NULL AS HORIZON
> FROM
> PART
> ,RQMT
> WHERE
> PART.PART_NBR = RQMT.COMP_PART_NBR AND
> PART.PART_TYPE = 'P' AND
> (RQMT.RQMT_CODE <> 'CL' AND
> RQMT.RQMT_CODE <> 'IS')
> UNION ALL
> SELECT
> PART.PART_NBR AS PART_NBR
> ,PART.PART_DESC AS PART_DESC
> ,PART.PART_TYPE AS PART_TYPE
> ,OORD.ORD_STAT AS ORD_STAT
> ,OORD.ORD_TYPE AS ORD_TYPE
> ,NULL AS RQMT_CODE
> ,TO_NUMBER(NULL) AS QTY_ON_HAND
> ,TO_NUMBER(NULL) AS DEMAND_OVERDUE
> ,TO_NUMBER(NULL) AS DEMAND_0TO20DAYS
> ,TO_NUMBER(NULL) AS DEMAND_21TO40DAYS
> ,TO_NUMBER(NULL) AS DEMAND_41TO60DAYS
> ,TO_NUMBER(NULL) AS DEMAND_61TO90DAYS
> ,TO_NUMBER(NULL) AS DEMAND_91TO180DAYS
> ,TO_NUMBER(NULL) AS DEMAND_BEYOND
> ,CASE WHEN
> OORD.PLAN_RECV_DATE < SYSDATE
> THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
> ELSE 0 END AS ORDERS_OVERDUE
> ,CASE WHEN
> OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE <= (SYSDATE + 20)
> THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
> ELSE 0 END AS ORDERS_0TO20DAYS
> ,CASE WHEN
> OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE >= (SYSDATE + 21)
> AND
> OORD.PLAN_RECV_DATE <= (SYSDATE + 40)
> THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
> ELSE 0 END AS ORDERS_21TO40DAYS
> ,CASE WHEN
> OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE >= (SYSDATE + 41)
> AND
> OORD.PLAN_RECV_DATE <= (SYSDATE + 60)
> THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
> ELSE 0
> END AS ORDERS_41TO60DAYS
> ,CASE WHEN
> OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE >= (SYSDATE + 61)
> AND
> OORD.PLAN_RECV_DATE <= (SYSDATE + 90)
> THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
> ELSE 0
> END AS ORDERS_61TO90DAYS
> ,CASE WHEN
> OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE >= (SYSDATE + 91)
> AND
> OORD.PLAN_RECV_DATE <= (SYSDATE + 180)
> THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
> ELSE 0
> END AS ORDERS_91TO180DAYS
> ,CASE WHEN
> OORD.PLAN_RECV_DATE >= SYSDATE AND OORD.PLAN_RECV_DATE >= (SYSDATE + 181)
> THEN (OORD.QTY_ON_ORD - OORD.QTY_RECVD)
> ELSE 0
> END AS ORDERS_BEYOND
> ,OORD.PLAN_RECV_DATE AS PLAN_RECV_DATE
> ,TO_DATE(NULL) AS DATE_REQD
> ,TO_NUMBER(NULL) AS QTY_REQD
> ,TO_NUMBER(NULL) AS OTY_ISSUED
> ,TO_NUMBER(NULL) AS DEMAND_DUE
> ,OORD.ORD_NBR AS ORD_NBR
> ,OORD.SUB_ORD_NBR AS LINE_NBR
> ,OORD.ORD_STAT AS STATUS
> ,TO_NUMBER(NULL) AS AVAIL_INVENTORY
> ,TO_NUMBER(NULL) AS LINE_INVENTORY
> ,TO_NUMBER(NULL) AS SCRAP_INVENTORY
> ,TO_NUMBER(NULL) AS RECV_INVENTORY
> ,TO_NUMBER(NULL) AS DROP_INVENTORY
> ,OORD.QTY_ON_ORD AS QTY_ON_ORD
> ,OORD.QTY_RECVD AS QTY_RECVD
> ,CASE WHEN PLAN_RECV_DATE < SYSDATE THEN 'OVERDUE'
> WHEN PLAN_RECV_DATE >= SYSDATE AND PLAN_RECV_DATE <= (SYSDATE + 20) THEN
> '0 To 20 Days'
> WHEN PLAN_RECV_DATE >= (SYSDATE + 21) AND PLAN_RECV_DATE <= (SYSDATE +
> 40) THEN '21 To 40 Days'
> WHEN PLAN_RECV_DATE >= (SYSDATE + 41) AND PLAN_RECV_DATE <= (SYSDATE +
> 60) THEN '41 To 60 Days'
> WHEN PLAN_RECV_DATE >= (SYSDATE + 61) AND PLAN_RECV_DATE <= (SYSDATE +
> 90) THEN '61 To 90 Days'
> WHEN PLAN_RECV_DATE >= (SYSDATE + 91) AND PLAN_RECV_DATE <= (SYSDATE +
> 180) THEN '91 To 180 Days'
> ELSE 'BEYOND' END AS HORIZON
> FROM
> PART
> ,OORD
> WHERE
> PART.PART_NBR = OORD.PART_NBR (+) AND
> PART.PART_TYPE = 'P' AND
> OORD.ORD_TYPE = 'PO' AND
> (OORD.ORD_STAT <> '--' AND
> OORD.ORD_STAT <> 'OR' AND
> OORD.ORD_STAT <> 'FP' AND
> OORD.ORD_STAT <> 'PL' AND
> OORD.ORD_STAT <> 'CL' )
> )
> ORDER BY 1 ,25,28,29
> Any suggestions will be appreciated.
> Thanks in advance!!!!
> Kerrie
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200602/1
>|||Thanks for replying!!!!!!
I finally figured it out last night. I had to group by one of the select
statements (INVD Table) and do complex where statements on the INVD and OORD
selects'. For example...
FROM
INVD
WHERE
INVD.PART_NBR IN (SELECT
PART.PART_NBR AS PART_NBR
FROM
PART
,RQMT
WHERE
PART.PART_NBR = RQMT.COMP_PART_NBR AND
PART.PART_TYPE = 'P' AND
(RQMT.RQMT_CODE <> 'CL' AND
RQMT.RQMT_CODE <> 'IS'))
I only wanted the information coming out of the RQMT table (requirements).
Thanks for your help, I do appreciate it.
Kerrie
Amarnath wrote:
>Hi,
>"UNION ALL" will include all records ie even duplicate records. Try putting
>"Union"
>It will eliminate duplicate records.
>Regards
>Amarnath
>> Hi all,
>[quoted text clipped - 253 lines]
>> Kerrie
--
Message posted via http://www.sqlmonster.com

OK button doesn't Work In Report Manager RS2005

Hi, i have a new instalation of RS2000 under Windows 2003 Server SP1 with a fresh reaplied Windows Service Pack 1 and RS2000 Service Pack 2.

My problem is that any page of the report manager with a "OK" button, that button doen't do nothing, it is enabled bu doesn't do any action.

Can't figure this one out

Need Help Thank's

PS: Is did work early on this machine but stop working without notice, or any change at all.

Usuall this occurs due to a problem with ASP.net. Try running the asp.net 1.1 command aspnet_regiis.exe -ir and then aspnet_regiis.exe -s W3SVC/1/ROOT/Reports (change Reports if you do not have the default name).

After this try again, make sure to do a ctrl F5 on the browser to ensure you have the latest scripts.

I hope that helps.

|||

Even after that the problem persists.

I've checked permitions, folder attributes the wole thing... nothing works...

Still, i can not execute "aspnet_regiis -c" even if it does create the "C:\Inetpub\wwwroot\aspnet_client\system_web\1_1_4322" it exits with " (0x80070005)You must have administrative rights on this machine in order to run this tool."

Help needed..

|||

Hi,

We have installed SQL Server 2005 with Reporting Service in a Windows 2003 Box. While working with the Reporting Manager through the browser we are gettting a strange problem. Whenever we are making any changes through Reporting Manager and trying to save the OK or Apply button is doing absolutely nothing. The button is enabled and is also getting 'pressed' once clicked but nothing is happening - no errors, no server trips.

In the 'New Data Sources' option whenever we are trying to change an option, we are also getting an Object Not Found javascript error.

We have enabled anonymous access for both Reports and ReportServer web services and the user for that access is a member of the machine's Administrators group. The reporting service configuration also is all green.

Can someone Help!!

Regards

Saunak

|||

Hi

Maybe this thread helps:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=173608&SiteID=1

OK button doesn't Work In Report Manager RS2000

Hi, i have a new instalation of RS2000 under Windows 2003 Server SP1 with a fresh reaplied Windows Service Pack 1 and RS2000 Service Pack 2.

My problem is that any page of the report manager with a "OK" button, that button doen't do nothing, it is enabled bu doesn't do any action.

Can't figure this one out

Need Help Thank's

PS: Is did work early on this machine but stop working without notice, or any change at all.

Usuall this occurs due to a problem with ASP.net. Try running the asp.net 1.1 command aspnet_regiis.exe -ir and then aspnet_regiis.exe -s W3SVC/1/ROOT/Reports (change Reports if you do not have the default name).

After this try again, make sure to do a ctrl F5 on the browser to ensure you have the latest scripts.

I hope that helps.

|||

Even after that the problem persists.

I've checked permitions, folder attributes the wole thing... nothing works...

Still, i can not execute "aspnet_regiis -c" even if it does create the "C:\Inetpub\wwwroot\aspnet_client\system_web\1_1_4322" it exits with " (0x80070005)You must have administrative rights on this machine in order to run this tool."

Help needed..

|||

Hi,

We have installed SQL Server 2005 with Reporting Service in a Windows 2003 Box. While working with the Reporting Manager through the browser we are gettting a strange problem. Whenever we are making any changes through Reporting Manager and trying to save the OK or Apply button is doing absolutely nothing. The button is enabled and is also getting 'pressed' once clicked but nothing is happening - no errors, no server trips.

In the 'New Data Sources' option whenever we are trying to change an option, we are also getting an Object Not Found javascript error.

We have enabled anonymous access for both Reports and ReportServer web services and the user for that access is a member of the machine's Administrators group. The reporting service configuration also is all green.

Can someone Help!!

Regards

Saunak

|||

Hi

Maybe this thread helps:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=173608&SiteID=1

OK button doesn't Work In Report Manager RS2000

Hi, i have a new instalation of RS2000 under Windows 2003 Server SP1
with a fresh reaplied Windows Service Pack 1 and RS2000 Service Pack 2.
My problem is that any page of the report manager with a "OK" button,
that button doen't do nothing, it is enabled bu doesn't do any action.
Can't figure this one out
Need Help Thank's
PS: Is did work early on this machine but stop working without notice,
or any change at all.
----
RgranadaIf there is an error in the page (E.g Missing Entry) it will be displayed in
the page in Red.
Do you see any Error message in the IE status bar. (i.e other than Done
message)?
--
THANKS & PLEASE RATE THE POSTING.
--RAVI--
"Rgranada" wrote:
> Hi, i have a new instalation of RS2000 under Windows 2003 Server SP1
> with a fresh reaplied Windows Service Pack 1 and RS2000 Service Pack 2.
> My problem is that any page of the report manager with a "OK" button,
> that button doen't do nothing, it is enabled bu doesn't do any action.
> Can't figure this one out
> Need Help Thank's
> PS: Is did work early on this machine but stop working without notice,
> or any change at all.
>
>
> ----
> Rgranada
>|||No errors In page, it just won't take the ok action...
i'm thinking something related to asp.net as framework1.1 service pack
1...
thanks
Ravi wrote:
> If there is an error in the page (E.g Missing Entry) it will be displayed in
> the page in Red.
> Do you see any Error message in the IE status bar. (i.e other than Done
> message)?
> --
> THANKS & PLEASE RATE THE POSTING.
> --RAVI--
>
> "Rgranada" wrote:
> > Hi, i have a new instalation of RS2000 under Windows 2003 Server SP1
> > with a fresh reaplied Windows Service Pack 1 and RS2000 Service Pack 2.
> >
> > My problem is that any page of the report manager with a "OK" button,
> > that button doen't do nothing, it is enabled bu doesn't do any action.
> >
> > Can't figure this one out
> >
> > Need Help Thank's
> >
> > PS: Is did work early on this machine but stop working without notice,
> > or any change at all.
> >
> >
> >
> >
> > ----
> > Rgranada
> >
> >

Offline Report Generation

Hi,

I have a requirement of generating very long reports (1-2hrs approx). Obviously the user would not like to wait for the report to come up to view.

Can I generate reports offline using SSRS 2005? If yes, then how can i submit the report for generation and re-direct the user to any other page, where he/she can see the status of the report (or continue to work on other pages).
If yes, then can I run an exe in the background to check the status of the report at regular intervals and notify the user once the report is completed? I checked the status of the report in the ExecutionLog table should be 'rsSuccessful', indicating the successful generation of the report.

If yes, then where (path) the reports generated offline are stored?

Thanks in advance.One option would be to schedule the reports and then deliver them to an email address or fileshare.
Another option would be to use the snapshot feature.
From BOL:

Report history is a collection of report snapshots. You can maintain report history by adding and deleting snapshots, or by modifying properties that affect report history storage. You can create report history manually or on a schedule.

To create report history, your role assignment must include the "Manage report history" task. To view report history, your role assignment must include the "View reports" task. Report history is available to all users who have access to the report. You cannot selectively enable or disable report history for a subset of users.

Snapshots in report history are identified by the date and time they were created. The date and time is based on when the query executed.

Offline mode ?

Hi all,
I am designing and testing a report using an ODBC connection. The
report is short (one or two pages) but the SQL request has many tables
and takes several minutes. Being in development phase I don't need the
datas to be refreshed from SQL database every time I click on
"preview" to see the report, but this is what happens (I find no other
reason for so long response time...). So I spend a lot of time waiting
for response.
Is there a kind of "offline" mode to see layout modifications without
refreshing datas every time ?
Thanks !
Jean-MarcTry using your SQL query to export the data from the multiple tables into a
single table. For your development and testing, base your report data on the
single table.
Using Query Analyzer, do:
SELECT * INTO MyTable FROM (rest of complex query)
Now base your test report on the data in MyTable. (You can also use DTS to
create the single table, and can even export the data into a local Access
table).
Charles Kangai, MCT, MCDBA
"Jean-Marc Audrin" wrote:
> Hi all,
> I am designing and testing a report using an ODBC connection. The
> report is short (one or two pages) but the SQL request has many tables
> and takes several minutes. Being in development phase I don't need the
> datas to be refreshed from SQL database every time I click on
> "preview" to see the report, but this is what happens (I find no other
> reason for so long response time...). So I spend a lot of time waiting
> for response.
> Is there a kind of "offline" mode to see layout modifications without
> refreshing datas every time ?
> Thanks !
> Jean-Marc
>sql

Odd report behavior

When I run a reporting services report from report manager the report
executes over and over again. I have to close the browser to stop it. Has
anyone seen this behavior
ThanksCheck report properties, autorefresh and make sure there is not a value for
it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Will Byron" <will.byron@.maxqtech.com> wrote in message
news:eBbrdKb%23EHA.2568@.TK2MSFTNGP11.phx.gbl...
> When I run a reporting services report from report manager the report
> executes over and over again. I have to close the browser to stop it. Has
> anyone seen this behavior
> Thanks
>|||Thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23aLcjRb%23EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Check report properties, autorefresh and make sure there is not a value
for
> it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Will Byron" <will.byron@.maxqtech.com> wrote in message
> news:eBbrdKb%23EHA.2568@.TK2MSFTNGP11.phx.gbl...
> > When I run a reporting services report from report manager the report
> > executes over and over again. I have to close the browser to stop it.
Has
> > anyone seen this behavior
> > Thanks
> >
> >
>

Odd error with Reporting Services and Oracle

I've got a fairly simple report that hits oracle with two parameters set as strings.

When I run the query in the designer, I get

Error Source: System.Data.OracleClient
Error Message: ORA-01858: a non-numeric character was found where a numeric was expected

However, when I run the report in preview everything just works. Same inputs on the parameters.

Any ideas?

What types are your parameters and what is the SQL you are using in your DataSet? I've seen this kind of error passing a parameter that is declared as a string in the report to an oracle parameter that is compared against a Date type in Oracle.

Mike

|||Sorery I meant to post a followup to this. The solution is that SQL RS 2k5 takes a string that happens to be a date and makes it a date without telling.

When it goes into oracle as this "Date" it will go in in the default SQL date format. So you need to match the format mask in the oracle TO_Date function call to the 3 letter month sql format.

Interesting, RS 2K did not do this.

Odd behavior (Pagebreaks & Visibility)

I built a report, that displays several Subreports. Then a request came, if it wouldn't be possible, to build a switch to turn on/off a page break after each report.

Since RS doesn't support a fexible page break controlling (you can either set or not set a page break hardcoded), I got an idea for a workaround:

After my Subreport I put a rectangle with a page break. Now every Subreport was displayed on a separate page.

Then I set the visibility for the rectangle to "hidded" and as expected, there was no page break after each subreport.

So far, so good. I then created a boolean parameter and set the Visibility expression to:

=Not Parameters!PageBreakAfterEachReport.Value

Now here comes the strange thing: If the Parameter is false, the rectangle is not displayed and therefor there is no page break, BUT, if the parameter is true, the rectangle is displayed correctly but there is STILL NO page break!!!?!?!!?!?

Why does the page break work, when I set the visibility hardcoded, but not when I try to control it via a parameter & expression?

I'm having the same issue here. If my control's visibility is dynamic, the pagebreaks do not work correctly. Is there any resolution/workaround to this problem?|||

Hi,

You could load the xml generated in XmlDocument and then using Xpath select the pagebreak element. Set this element dynamically.

Regards,

Alok

|||

Folks, I don't know if it is going to make you feel better or not, but apparently this behavior is "currently by design" -- at least I think that what is described in this thread is the same as what you are discussing.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=672379&SiteID=1

Actually (editing this post) now that I think about it, I may already have worked out a workaround that will work for this situation. Let me know what you think.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1682115&SiteID=1

In that post, I included a special dummy group and used a boolean parameter to determine the conditional page break. In your case, rather than the parameter, your condition would be something "if my other thing isn't visible, do this page break".

Hope this makes sense...

>L<

Odd behavior (Pagebreaks & Visibility)

I built a report, that displays several Subreports. Then a request came, if it wouldn't be possible, to build a switch to turn on/off a page break after each report.

Since RS doesn't support a fexible page break controlling (you can either set or not set a page break hardcoded), I got an idea for a workaround:

After my Subreport I put a rectangle with a page break. Now every Subreport was displayed on a separate page.

Then I set the visibility for the rectangle to "hidded" and as expected, there was no page break after each subreport.

So far, so good. I then created a boolean parameter and set the Visibility expression to:

=Not Parameters!PageBreakAfterEachReport.Value

Now here comes the strange thing: If the Parameter is false, the rectangle is not displayed and therefor there is no page break, BUT, if the parameter is true, the rectangle is displayed correctly but there is STILL NO page break!!!?!?!!?!?

Why does the page break work, when I set the visibility hardcoded, but not when I try to control it via a parameter & expression?

I'm having the same issue here. If my control's visibility is dynamic, the pagebreaks do not work correctly. Is there any resolution/workaround to this problem?|||

Hi,

You could load the xml generated in XmlDocument and then using Xpath select the pagebreak element. Set this element dynamically.

Regards,

Alok

|||

Folks, I don't know if it is going to make you feel better or not, but apparently this behavior is "currently by design" -- at least I think that what is described in this thread is the same as what you are discussing.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=672379&SiteID=1

Actually (editing this post) now that I think about it, I may already have worked out a workaround that will work for this situation. Let me know what you think.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1682115&SiteID=1

In that post, I included a special dummy group and used a boolean parameter to determine the conditional page break. In your case, rather than the parameter, your condition would be something "if my other thing isn't visible, do this page break".

Hope this makes sense...

>L<

ODBC to connect crystal report 8.5 and lotus notes 6.5

Hi:

I wanted to connect crystal report 8.5 with Domino lotus notes 6.5 through ODBC , so does any one know which ODBC i can use and how to download it ??

I found some where on internet that I have to use "NotesSQL" driver for this but I don't know what is that and from where to download

Thanks
-Jayesh MendparaHi all:

I found answer for my query and I am posting here because it might be useful to somebody else ,,

to conenct crystal report and domino's lotus notes your need NotesSQL ODBC driver and you can download it from ibm.com

Thanks

-Jayesh Mendpara

ODBC Select Data Source in Crystal reports - continuously prompts

I've created an ODBC entry for crystal reports. When I go to refresh and
run a report, it always prompts me with a select data source and SQL server
is at the bottom of the list under dBase, Excel and MS Access Database. If
I select it, the report runs. How do I have it automatically choose that
source so I don't have to select it each time?
Thank you.You should ask this question in a Crystal support newsgroup or site.
This one is for SQL Server, so your pickings will be slim.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 26 Dec 2003 13:41:50 -0500, "microsoft"
<advice1one@.hotmail.com> wrote:

quote:

---

>I've created an ODBC entry for crystal reports. When I go to refresh and
>run a report, it always prompts me with a select data source and SQL server
>is at the bottom of the list under dBase, Excel and MS Access Database. If
>I select it, the report runs. How do I have it automatically choose that
>source so I don't have to select it each time?
>Thank you.
>

---

|||Thank you, I figured it out, I needed to change the ODBC connector to named
pipes.
"Mary Chipman" <mchip@.nomail.please> wrote in message
news:do51vv0gshsu7e2g9mr6bl0i9sinf4bq4t@.
4ax.com...

quote:

---

> You should ask this question in a Crystal support newsgroup or site.
> This one is for SQL Server, so your pickings will be slim.
> -- Mary
> MCW Technologies
> http://www.mcwtech.com
> On Fri, 26 Dec 2003 13:41:50 -0500, "microsoft"
> <advice1one@.hotmail.com> wrote:
>
server[QUOTE]
If[QUOTE]
>

---

ODBC Redux

I asked the following a few days ago. Am I asking the wrong group?
I am attempting to put a couple of Oracle 8i views in a report project I am
building. When I attempt to build the connection I have two drivers to
choose from one is the Microsoft OLE DB provider for Oracle and the other is
"Oracle Provider for OLE DB". When I use the first I do not get all of the
views and when I get the second I get an error saying that the service name
cannot be resolved. I have created a regular DSN and looked at the data in
Access so I know the views I want are there but I cannot seem to make it
happen in Reporting services. Any Ideas?
--
Andrew C. Madsen
Network Specialist
Harley-Davidson Motor CompanySometimes when you ask a question there isn't anyone who knows the solution.
I don't know the solution but I do have some ideas on what you can try.
First, do not pick the Microsoft OLE DB Provider for Oracle. If you do it
will be trying to use OLEDB from the query designer and managed dotnet
provider when you run it. The dotnet provider requires the 9i client (not
sure if a 9i client can go against 8i). If you pick the Microsoft one it
might work from the designer but it would most likely not run when you
preview the report.
A DSN has nothing to do with OLEDB, that is an ODBC thing. So, as far as the
Oracle OLEDB provider you are missing a step in configuring, i.e. you have
not setup the service name (which is what the error says). I haven't worked
for awhile with Oracle so I can't give you the exact steps. Google OLEDB and
Oracle.
My suggestion is to go with the oledb provider for odbc because then you can
pick the DSN that you setup previously.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
news:%23Xwk2oO%23EHA.3932@.TK2MSFTNGP10.phx.gbl...
> I asked the following a few days ago. Am I asking the wrong group?
> I am attempting to put a couple of Oracle 8i views in a report project I
am
> building. When I attempt to build the connection I have two drivers to
> choose from one is the Microsoft OLE DB provider for Oracle and the other
is
> "Oracle Provider for OLE DB". When I use the first I do not get all of the
> views and when I get the second I get an error saying that the service
name
> cannot be resolved. I have created a regular DSN and looked at the data in
> Access so I know the views I want are there but I cannot seem to make it
> happen in Reporting services. Any Ideas?
>
> --
> Andrew C. Madsen
> Network Specialist
> Harley-Davidson Motor Company
>|||Oracle behaves differently when you use the QBE layout and the text layout.
More precisely, two different mechanisms are used to get to the database. I
think you're supposed to use the text layout for entering your query into
the datasource.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
news:%23Xwk2oO%23EHA.3932@.TK2MSFTNGP10.phx.gbl...
>I asked the following a few days ago. Am I asking the wrong group?
> I am attempting to put a couple of Oracle 8i views in a report project I
> am
> building. When I attempt to build the connection I have two drivers to
> choose from one is the Microsoft OLE DB provider for Oracle and the other
> is
> "Oracle Provider for OLE DB". When I use the first I do not get all of the
> views and when I get the second I get an error saying that the service
> name
> cannot be resolved. I have created a regular DSN and looked at the data in
> Access so I know the views I want are there but I cannot seem to make it
> happen in Reporting services. Any Ideas?
>
> --
> Andrew C. Madsen
> Network Specialist
> Harley-Davidson Motor Company
>|||Sorry if I sounded testy. I plead innocent due to the limitations of text.
There are a lot of messages that get posed here and I assumed that mine
either got lost in the mass or it was considered off topic hence the first
sentence of the message.
Now, that being said I am running the Oracle 9i client and when I try to use
the Microsoft OLE DB driver for ODBC I get the same error that the service
name cannot be resolved. I can connect any other tool using the ODBC DSN
except for the MS tool.
--
Andrew C. Madsen
Network Specialist
Harley-Davidson Motor Company
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OasNm5O%23EHA.2196@.TK2MSFTNGP11.phx.gbl...
> Sometimes when you ask a question there isn't anyone who knows the
solution.
> I don't know the solution but I do have some ideas on what you can try.
> First, do not pick the Microsoft OLE DB Provider for Oracle. If you do it
> will be trying to use OLEDB from the query designer and managed dotnet
> provider when you run it. The dotnet provider requires the 9i client (not
> sure if a 9i client can go against 8i). If you pick the Microsoft one it
> might work from the designer but it would most likely not run when you
> preview the report.
> A DSN has nothing to do with OLEDB, that is an ODBC thing. So, as far as
the
> Oracle OLEDB provider you are missing a step in configuring, i.e. you have
> not setup the service name (which is what the error says). I haven't
worked
> for awhile with Oracle so I can't give you the exact steps. Google OLEDB
and
> Oracle.
> My suggestion is to go with the oledb provider for odbc because then you
can
> pick the DSN that you setup previously.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
> news:%23Xwk2oO%23EHA.3932@.TK2MSFTNGP10.phx.gbl...
> > I asked the following a few days ago. Am I asking the wrong group?
> >
> > I am attempting to put a couple of Oracle 8i views in a report project I
> am
> > building. When I attempt to build the connection I have two drivers to
> > choose from one is the Microsoft OLE DB provider for Oracle and the
other
> is
> > "Oracle Provider for OLE DB". When I use the first I do not get all of
the
> > views and when I get the second I get an error saying that the service
> name
> > cannot be resolved. I have created a regular DSN and looked at the data
in
> > Access so I know the views I want are there but I cannot seem to make it
> > happen in Reporting services. Any Ideas?
> >
> >
> > --
> > Andrew C. Madsen
> > Network Specialist
> > Harley-Davidson Motor Company
> >
> >
>|||Hmm, there should not be any difference between Access (which you says works
with the DSN you have created) and using MS OLEDB Driver for ODBC. Is this a
system DSN or a user DSN. I used ODBC against Sybase and I see no
difference between using the DSN with Access (which I have done) and using
it in RS.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
news:%23rFT7wX%23EHA.2580@.TK2MSFTNGP15.phx.gbl...
> Sorry if I sounded testy. I plead innocent due to the limitations of text.
> There are a lot of messages that get posed here and I assumed that mine
> either got lost in the mass or it was considered off topic hence the first
> sentence of the message.
> Now, that being said I am running the Oracle 9i client and when I try to
use
> the Microsoft OLE DB driver for ODBC I get the same error that the service
> name cannot be resolved. I can connect any other tool using the ODBC DSN
> except for the MS tool.
> --
> Andrew C. Madsen
> Network Specialist
> Harley-Davidson Motor Company
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OasNm5O%23EHA.2196@.TK2MSFTNGP11.phx.gbl...
> > Sometimes when you ask a question there isn't anyone who knows the
> solution.
> > I don't know the solution but I do have some ideas on what you can try.
> > First, do not pick the Microsoft OLE DB Provider for Oracle. If you do
it
> > will be trying to use OLEDB from the query designer and managed dotnet
> > provider when you run it. The dotnet provider requires the 9i client
(not
> > sure if a 9i client can go against 8i). If you pick the Microsoft one it
> > might work from the designer but it would most likely not run when you
> > preview the report.
> >
> > A DSN has nothing to do with OLEDB, that is an ODBC thing. So, as far as
> the
> > Oracle OLEDB provider you are missing a step in configuring, i.e. you
have
> > not setup the service name (which is what the error says). I haven't
> worked
> > for awhile with Oracle so I can't give you the exact steps. Google OLEDB
> and
> > Oracle.
> >
> > My suggestion is to go with the oledb provider for odbc because then you
> can
> > pick the DSN that you setup previously.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
> > news:%23Xwk2oO%23EHA.3932@.TK2MSFTNGP10.phx.gbl...
> > > I asked the following a few days ago. Am I asking the wrong group?
> > >
> > > I am attempting to put a couple of Oracle 8i views in a report project
I
> > am
> > > building. When I attempt to build the connection I have two drivers to
> > > choose from one is the Microsoft OLE DB provider for Oracle and the
> other
> > is
> > > "Oracle Provider for OLE DB". When I use the first I do not get all of
> the
> > > views and when I get the second I get an error saying that the service
> > name
> > > cannot be resolved. I have created a regular DSN and looked at the
data
> in
> > > Access so I know the views I want are there but I cannot seem to make
it
> > > happen in Reporting services. Any Ideas?
> > >
> > >
> > > --
> > > Andrew C. Madsen
> > > Network Specialist
> > > Harley-Davidson Motor Company
> > >
> > >
> >
> >
>|||Ok this suggestion worked (in a kluge kind of way) even though I could not
see the view in the picker list if I entered the name manually it then
appeared. Thanks for the help.
--
Andrew C. Madsen
Network Specialist
Harley-Davidson Motor Company
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:u1bOydR%23EHA.2196@.TK2MSFTNGP11.phx.gbl...
> Oracle behaves differently when you use the QBE layout and the text
layout.
> More precisely, two different mechanisms are used to get to the database.
I
> think you're supposed to use the text layout for entering your query into
> the datasource.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
> news:%23Xwk2oO%23EHA.3932@.TK2MSFTNGP10.phx.gbl...
> >I asked the following a few days ago. Am I asking the wrong group?
> >
> > I am attempting to put a couple of Oracle 8i views in a report project I
> > am
> > building. When I attempt to build the connection I have two drivers to
> > choose from one is the Microsoft OLE DB provider for Oracle and the
other
> > is
> > "Oracle Provider for OLE DB". When I use the first I do not get all of
the
> > views and when I get the second I get an error saying that the service
> > name
> > cannot be resolved. I have created a regular DSN and looked at the data
in
> > Access so I know the views I want are there but I cannot seem to make it
> > happen in Reporting services. Any Ideas?
> >
> >
> > --
> > Andrew C. Madsen
> > Network Specialist
> > Harley-Davidson Motor Company
> >
> >
>|||So did you end up using Oracle OLEDB provider?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
news:eunzNeY%23EHA.2552@.TK2MSFTNGP09.phx.gbl...
> Ok this suggestion worked (in a kluge kind of way) even though I could not
> see the view in the picker list if I entered the name manually it then
> appeared. Thanks for the help.
> --
> Andrew C. Madsen
> Network Specialist
> Harley-Davidson Motor Company
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:u1bOydR%23EHA.2196@.TK2MSFTNGP11.phx.gbl...
> > Oracle behaves differently when you use the QBE layout and the text
> layout.
> > More precisely, two different mechanisms are used to get to the
database.
> I
> > think you're supposed to use the text layout for entering your query
into
> > the datasource.
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
> > news:%23Xwk2oO%23EHA.3932@.TK2MSFTNGP10.phx.gbl...
> > >I asked the following a few days ago. Am I asking the wrong group?
> > >
> > > I am attempting to put a couple of Oracle 8i views in a report project
I
> > > am
> > > building. When I attempt to build the connection I have two drivers to
> > > choose from one is the Microsoft OLE DB provider for Oracle and the
> other
> > > is
> > > "Oracle Provider for OLE DB". When I use the first I do not get all of
> the
> > > views and when I get the second I get an error saying that the service
> > > name
> > > cannot be resolved. I have created a regular DSN and looked at the
data
> in
> > > Access so I know the views I want are there but I cannot seem to make
it
> > > happen in Reporting services. Any Ideas?
> > >
> > >
> > > --
> > > Andrew C. Madsen
> > > Network Specialist
> > > Harley-Davidson Motor Company
> > >
> > >
> >
> >
>|||What I did:
I had created a DSN Called EMC. For the Data Source I used Microsoft OLE DB
connector for ODBC and selected the DSN. This gave me a list of tables and
views in the Table Picker but the views I wanted were not in the list so I
had to not use the picker and enter the SQL manually by using the syntax:
userview.viewname (stsview.ST_HOST_ARRAY in this case). When I entered that
the table picker then showed that table.
--
Andrew C. Madsen
Network Specialist
Harley-Davidson Motor Company
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OdsdGzY%23EHA.3988@.TK2MSFTNGP11.phx.gbl...
> So did you end up using Oracle OLEDB provider?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
> news:eunzNeY%23EHA.2552@.TK2MSFTNGP09.phx.gbl...
> > Ok this suggestion worked (in a kluge kind of way) even though I could
not
> > see the view in the picker list if I entered the name manually it then
> > appeared. Thanks for the help.
> >
> > --
> > Andrew C. Madsen
> > Network Specialist
> > Harley-Davidson Motor Company
> > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > news:u1bOydR%23EHA.2196@.TK2MSFTNGP11.phx.gbl...
> > > Oracle behaves differently when you use the QBE layout and the text
> > layout.
> > > More precisely, two different mechanisms are used to get to the
> database.
> > I
> > > think you're supposed to use the text layout for entering your query
> into
> > > the datasource.
> > >
> > > --
> > > Cheers,
> > >
> > > '(' Jeff A. Stucker
> > > \
> > >
> > > Business Intelligence
> > > www.criadvantage.com
> > > ---
> > > "Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
> > > news:%23Xwk2oO%23EHA.3932@.TK2MSFTNGP10.phx.gbl...
> > > >I asked the following a few days ago. Am I asking the wrong group?
> > > >
> > > > I am attempting to put a couple of Oracle 8i views in a report
project
> I
> > > > am
> > > > building. When I attempt to build the connection I have two drivers
to
> > > > choose from one is the Microsoft OLE DB provider for Oracle and the
> > other
> > > > is
> > > > "Oracle Provider for OLE DB". When I use the first I do not get all
of
> > the
> > > > views and when I get the second I get an error saying that the
service
> > > > name
> > > > cannot be resolved. I have created a regular DSN and looked at the
> data
> > in
> > > > Access so I know the views I want are there but I cannot seem to
make
> it
> > > > happen in Reporting services. Any Ideas?
> > > >
> > > >
> > > > --
> > > > Andrew C. Madsen
> > > > Network Specialist
> > > > Harley-Davidson Motor Company
> > > >
> > > >
> > >
> > >
> >
> >
>|||Thanks, I wondered what ended up working for you in case I see someone else
with the problem. I wonder if the views have some special naming to them
that causes them to not show in the list.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
news:e2wfiXZ%23EHA.1524@.TK2MSFTNGP09.phx.gbl...
> What I did:
> I had created a DSN Called EMC. For the Data Source I used Microsoft OLE
DB
> connector for ODBC and selected the DSN. This gave me a list of tables and
> views in the Table Picker but the views I wanted were not in the list so I
> had to not use the picker and enter the SQL manually by using the syntax:
> userview.viewname (stsview.ST_HOST_ARRAY in this case). When I entered
that
> the table picker then showed that table.
> --
> Andrew C. Madsen
> Network Specialist
> Harley-Davidson Motor Company
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OdsdGzY%23EHA.3988@.TK2MSFTNGP11.phx.gbl...
> > So did you end up using Oracle OLEDB provider?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
> > news:eunzNeY%23EHA.2552@.TK2MSFTNGP09.phx.gbl...
> > > Ok this suggestion worked (in a kluge kind of way) even though I could
> not
> > > see the view in the picker list if I entered the name manually it then
> > > appeared. Thanks for the help.
> > >
> > > --
> > > Andrew C. Madsen
> > > Network Specialist
> > > Harley-Davidson Motor Company
> > > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > > news:u1bOydR%23EHA.2196@.TK2MSFTNGP11.phx.gbl...
> > > > Oracle behaves differently when you use the QBE layout and the text
> > > layout.
> > > > More precisely, two different mechanisms are used to get to the
> > database.
> > > I
> > > > think you're supposed to use the text layout for entering your query
> > into
> > > > the datasource.
> > > >
> > > > --
> > > > Cheers,
> > > >
> > > > '(' Jeff A. Stucker
> > > > \
> > > >
> > > > Business Intelligence
> > > > www.criadvantage.com
> > > > ---
> > > > "Andrew Madsen" <andrew.madsen@.harley-davidson.com> wrote in message
> > > > news:%23Xwk2oO%23EHA.3932@.TK2MSFTNGP10.phx.gbl...
> > > > >I asked the following a few days ago. Am I asking the wrong group?
> > > > >
> > > > > I am attempting to put a couple of Oracle 8i views in a report
> project
> > I
> > > > > am
> > > > > building. When I attempt to build the connection I have two
drivers
> to
> > > > > choose from one is the Microsoft OLE DB provider for Oracle and
the
> > > other
> > > > > is
> > > > > "Oracle Provider for OLE DB". When I use the first I do not get
all
> of
> > > the
> > > > > views and when I get the second I get an error saying that the
> service
> > > > > name
> > > > > cannot be resolved. I have created a regular DSN and looked at the
> > data
> > > in
> > > > > Access so I know the views I want are there but I cannot seem to
> make
> > it
> > > > > happen in Reporting services. Any Ideas?
> > > > >
> > > > >
> > > > > --
> > > > > Andrew C. Madsen
> > > > > Network Specialist
> > > > > Harley-Davidson Motor Company
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

ODBC named parameters ??

Today we tried to connect to an Informix server and make a report, worked
fine until I need to put in parameters, then it said that the odbc
connection couldn't use named parameters and should use unnamed
parameters.
I also tried using an ole db connection with the same result.
What should I do to make use of parameters '
Jack
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at få 46338 spam-mails.
Betalende brugere får ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dkUse unnamed (put a ? in). Note that it will name your report parameters
unfriendly names. I always rename them then go back to the dataset, click on
..., parameters tab and remap the query parameters to the report parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
news:uiNFyOy3FHA.3136@.TK2MSFTNGP09.phx.gbl...
> Today we tried to connect to an Informix server and make a report, worked
> fine until I need to put in parameters, then it said that the odbc
> connection couldn't use named parameters and should use unnamed
> parameters.
> I also tried using an ole db connection with the same result.
> What should I do to make use of parameters '
> Jack
>
> ---
> Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> Den har indtil videre sparet mig for at få 46338 spam-mails.
> Betalende brugere får ikke denne besked i deres e-mails.
> Hent gratis SPAMfighter her: www.spamfighter.dk
>|||Hi Jack,
The .NET managed providers for ODBC and OleDb do not support named parameters.
You'll need to use ?'s to mark where the parameters ought to appear in your
SQL statement, and then make sure you add them in the proper order that they
appear in the SQL.
Best,
-Chris
> Today we tried to connect to an Informix server and make a report,
> worked fine until I need to put in parameters, then it said that the
> odbc connection couldn't use named parameters and should use unnamed
> parameters.
> I also tried using an ole db connection with the same result.
> What should I do to make use of parameters '
> Jack
> ---
> Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> Den har indtil videre sparet mig for at få 46338 spam-mails.
> Betalende brugere får ikke denne besked i deres e-mails.
> Hent gratis SPAMfighter her: www.spamfighter.dk|||> The .NET managed providers for ODBC and OleDb do not support named
> parameters. You'll need to use ?'s to mark where the parameters ought to
> appear in your SQL statement, and then make sure you add them in the
> proper order that they appear in the SQL.
Do you mean that the order of the report parameters have to be the order
in
which the ? appears in the sql statement ?
I'm a bit confused here :)
Jack
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at få 46339 spam-mails.
Betalende brugere får ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk|||No, the order of the mapping. Important concept. Even though RS makes it
seem like they are one and the same they aren't. There are Query Parameters
and Report Parameters. The query parameters are mapped to the report
parameters (click on the ..., parameters tab to see where you change this).
Note that query parameters can be mapped to an expression, they don't have
to be mapped to a report parameter. RS automatically creates report
parameters.
The order is the order of the mapping (dataset tab). In the layout tab,
report parameters, they can be in any order.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
news:u%23xGgEz3FHA.1188@.TK2MSFTNGP12.phx.gbl...
>> The .NET managed providers for ODBC and OleDb do not support named
>> parameters. You'll need to use ?'s to mark where the parameters ought to
>> appear in your SQL statement, and then make sure you add them in the
>> proper order that they appear in the SQL.
> Do you mean that the order of the report parameters have to be the order
> in
> which the ? appears in the sql statement ?
> I'm a bit confused here :)
> Jack
>
> ---
> Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> Den har indtil videre sparet mig for at få 46339 spam-mails.
> Betalende brugere får ikke denne besked i deres e-mails.
> Hent gratis SPAMfighter her: www.spamfighter.dk
>|||> No, the order of the mapping. Important concept. Even though RS makes it
> seem like they are one and the same they aren't. There are Query
> Parameters and Report Parameters. The query parameters are mapped to the
> report parameters (click on the ..., parameters tab to see where you
> change this). Note that query parameters can be mapped to an expression,
> they don't have to be mapped to a report parameter. RS automatically
> creates report parameters.
> The order is the order of the mapping (dataset tab). In the layout tab,
> report parameters, they can be in any order.
I've come a bit further but it now tells me something about setparameterinfo
when i try to run the statement in the data tab.
Jack|||Are you doing a query or calling a stored procedure?
I always use the generic query design window, the button to switch to it is
to the right of the ...
Are you using OLEDB or ODBC?
I go against Sybase and did better with ODBC than OLEDB.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jack" <jackdSPAM@.jackd.dk> wrote in message
news:uyb%23c%2373FHA.3592@.TK2MSFTNGP12.phx.gbl...
>> No, the order of the mapping. Important concept. Even though RS makes it
>> seem like they are one and the same they aren't. There are Query
>> Parameters and Report Parameters. The query parameters are mapped to the
>> report parameters (click on the ..., parameters tab to see where you
>> change this). Note that query parameters can be mapped to an expression,
>> they don't have to be mapped to a report parameter. RS automatically
>> creates report parameters.
>> The order is the order of the mapping (dataset tab). In the layout tab,
>> report parameters, they can be in any order.
> I've come a bit further but it now tells me something about
> setparameterinfo when i try to run the statement in the data tab.
> Jack
>|||> Are you doing a query or calling a stored procedure?
> I always use the generic query design window, the button to switch to it
> is to the right of the ...
> Are you using OLEDB or ODBC?
> I go against Sybase and did better with ODBC than OLEDB.
I've tried using oledb and odbc, now i'm using odbc against an informix
server. It's a normal query using the sql designer, haven't tried the
generic.
Jack|||Try having a single parameter. Hard code the rest. Execute from the data tab
and you should be prompted to put in the value. If this doesn't work then
you could be having a problem with the ODBC driver. Note that when putting
in the parameter value if it is a string or a date just put the value in.
For instance for a data just put in 9/1/2005 for example.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jack" <jackdSPAM@.jackd.dk> wrote in message
news:OCKRHUF4FHA.3400@.tk2msftngp13.phx.gbl...
>> Are you doing a query or calling a stored procedure?
>> I always use the generic query design window, the button to switch to it
>> is to the right of the ...
>> Are you using OLEDB or ODBC?
>> I go against Sybase and did better with ODBC than OLEDB.
> I've tried using oledb and odbc, now i'm using odbc against an informix
> server. It's a normal query using the sql designer, haven't tried the
> generic.
> Jack
>