Hot News

Xbox One announced, launches with next-gen Kinect this year 206 10hrs 21mins ago
Xbox One not backwards compatible with 360 games 137 9hrs 10mins ago
Xbox Live Gold: is it still worth it? 100 1day 11hrs ago
Nintendo monetizing fanmade videos on YouTube 76 5days 8hrs ago
Xbox One doesn't require always-on connection, but mandatory installs tied to accounts 68 9hrs 18mins ago
In case you missed it, watch the Xbox One recap here 65 8hrs 10mins ago
Gran Turismo 6 coming to PS3 later this year [Update] 60 6days 11hrs ago
Madden NFL 25's $99 'Anniversary Edition' includes Sunday Ticket 52 4days 9hrs ago
Shadow Warrior trailer reveals 'reimagining' 49 1day 13hrs ago
Seeing Red: A History of the Xbox 360's Red Ring of Death 44 1day 7hrs 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
    - 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
    - #6355
      
      Refresh Thread
      
      By: bombay x Show Full Post
      
      Reply
      
      Do you have row level security in the erp, or a method to tell and slice the data at the erp level?
      
      Many erp systems lack that without a lot of coding, which I do not recommend because now you move reporting accurcy out of the app and onto your shoulders.
      
      Feb 23, 2010 5:22pm PST
      
      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