Hot News

Xbox One announced, launches with next-gen Kinect this year 238 1day 4hrs ago
Xbox One not backwards compatible with 360 games 145 1day 3hrs ago
Xbox Live Gold: is it still worth it? 100 2days 5hrs ago
Xbox One does not provide any built-in DVR capabilities 82 21hrs 45mins ago
Nintendo monetizing fanmade videos on YouTube 77 6days 2hrs ago
Backward compatability is 'backwards' strategy, says Microsoft 76 1hr 30mins ago
Xbox One doesn't require always-on connection, but mandatory installs tied to accounts 69 1day 3hrs ago
In case you missed it, watch the Xbox One recap here 65 1day 2hrs ago
Madden NFL 25's $99 'Anniversary Edition' includes Sunday Ticket 52 5days 3hrs ago
Kinect for Xbox One coming to PC 50 20hrs 15mins ago

Latest News

Morning Discussion

by Alice O'Connor, Feb 23, 2010 5:00am PST

Chris is jetting off to Mothership GameFly this morning to teach Brian the secret handshake, the Shackshake, leaving me in charge around here for a while.

To the Shackcave!

Read all the News

« Previous Story
Warner Bros. Buys Batman: Arkham Asylum Dev Rocksteady

Next Story »
Chris Taylor Narrates Two Supreme Commander 2 Unit Videos

See All Comments | 276 Threads | 6,339 Comments

#5335

Refresh Thread

By: epit x Show Full Post

Reply

Web reporting for business

Is there something out there that allows me to create web reports from my MSSQL server, but the reports are customized based on login to the site?

Something like SQL Reporting Services would be perfect if I could use a WHERE user='%USERNAME%' in the SQL and have the variable show that report with just the specific users' login name in it.

I'm afraid to ask if crystal reports does something like this cause I've heard its a bitch. or something like tying SQLRS into Sharepoint?

Feb 23, 2010 2:52pm PST

toggle
Web reporting for business Is there something out there that allows me to create web reports from my M... : epit
Thread Truncated. Click to see all 11 replies.
- toggle
  Do you want just the user's name or you want the data to be dynamic to just the user's data? : bombay
  - toggle
    well, I assume if you have at least the username, you can build sql around it to pull just the users' dat... : epit
    - #5500
      
      Refresh Thread
      
      By: spiffymc x Show Full Post
      
      Reply
      
      With Business Views in Crystal Reports you can link to two separate data sources (IE: AD and MSSQL) then join them together into one virtual data set. You still need some key to link the ERP ID to the AD ID but that shouldn't be hard to setup. Do that and you can easily create a Crystal Report do report on top of that data set.
      
      Feb 23, 2010 3:15pm PST
      
      toggle
      With Business Views in Crystal Reports you can link to two separate data sources (IE: AD and MSSQL) then ... : spiffymc
      
      I'd really shy away from this, you now own reporting accuracy. : bombay
    - Do you have row level security in the erp, or a method to tell and slice the data at the erp level? Many... : bombay
- toggle
  You people are crazy. Crystal Reports is awesome, you just need to learn how to use it properly =) : spiffymc
  - toggle
    And yes Crystal Reports can do that as long as you're not talking about two completely different reports,... : spiffymc
    - Actually even if it was two separate reports, I would just create them as sub-report objects and have the... : spiffymc
  - toggle
    I've just seen a lot of hate and very little love for CR. not sure where the hate comes from as I've only... : epit
    - I'm just biased because I used to teach a few basic and advanced Crystal Reports classes. It all comes do... : spiffymc