Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 datasource confusion-edited subject

Author  Topic 

katiev
Starting Member

18 Posts

Posted - 2008-11-03 : 14:52:43
I have a basic rdl file that uses stored procedure and correctly prompts for the parameter that I want to use. But the formatting and expressions are competely basic.

I have a more complex rdl file that was converted from crystal that I want to set up the same data source and parameter for as the report above and when I do that, and I try to preview the report I get errors saying
'the tablix 'tabledataregion1'refers to an invalid dataset name,
dataset 1'

a company did the conversion and set up a datasource called 'katie' (which i have no idea what that is) and datasource 'katie' has MANY MANY fields set up under dataset properties
but I want to use datasource 1 which is a SQL data source that runs my stored procedure, this datasource and dataset have NO fields defined.
Is there a way to use both--even though the katie datasource should not be defined or DO i have to create all those fields under the datasource I want to use? Is anyone familiar with converting rpt files to rdl files enough to assist me with the remaining conversion of this report?


I have no idea if Im even asking the right questions...

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-11-03 : 16:06:46
You have deleted your other posts so I deleted mine because it's confusing while reading this thread.

Webfred


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

katiev
Starting Member

18 Posts

Posted - 2008-11-04 : 09:44:47
i know im not asking the right questions... and so i deleted what I had here, though I could delete the whole tread and start over...

THANKS!
Go to Top of Page
   

- Advertisement -